J
James Lee
Aladin, David & Arvi,
THANK YOU FOR YOUR KIND ADVICE!
I tried and it does not work.
May you allow me to illustrate the table structure for you
to better understand it?
This is the worksheet for a 3 months rolling sales report
that I am working.
A1 = is the global cell reference that I need to change
every month. I start with Jan-04
The sales report is in range a3:d4 as follows
2 A B C D
3 Jan-04 Feb-04 Mar-04
4 Sales 100 110 131
Cell B3 reference to A1 and it will change accordingly, C3
& C4 is reference to a formula with an increment of 1
month dervied from B3.
The Sales data contained in B44 is drawn from a separate
file with named range as follows in G2:H5
1 G H
2 Jan-04 Act01
3 Feb-04 Act02
4 Mar-04 Act03
5 Apr-04 Act04
By creating a vlookup function in B44 with direct
reference is not a problem. What I need is an indirect
reference of the vlookup to reference each cell in B33
to the table in G2:H5, so that when I change the global
cell in A1 to say Feb-04, the 3 months sales data will be
updated with Feb-04 to Apr-04 sales data in B4 to D4,
instead of Jan-04 to Mar-04.
I wish that this is clear to you.
Once again, thank you!
James Lee
THANK YOU FOR YOUR KIND ADVICE!
I tried and it does not work.
May you allow me to illustrate the table structure for you
to better understand it?
This is the worksheet for a 3 months rolling sales report
that I am working.
A1 = is the global cell reference that I need to change
every month. I start with Jan-04
The sales report is in range a3:d4 as follows
2 A B C D
3 Jan-04 Feb-04 Mar-04
4 Sales 100 110 131
Cell B3 reference to A1 and it will change accordingly, C3
& C4 is reference to a formula with an increment of 1
month dervied from B3.
The Sales data contained in B44 is drawn from a separate
file with named range as follows in G2:H5
1 G H
2 Jan-04 Act01
3 Feb-04 Act02
4 Mar-04 Act03
5 Apr-04 Act04
By creating a vlookup function in B44 with direct
reference is not a problem. What I need is an indirect
reference of the vlookup to reference each cell in B33
to the table in G2:H5, so that when I change the global
cell in A1 to say Feb-04, the 3 months sales data will be
updated with Feb-04 to Apr-04 sales data in B4 to D4,
instead of Jan-04 to Mar-04.
I wish that this is clear to you.
Once again, thank you!
James Lee