D
dido22
Hello,
I have asked this before and thought I undestood the answer, but I was
wrong. Can I ask it again please ?
I have a workbook with several sheets. The 1st sheet is called 'Summary' and
uses data from any one of the other sheets. The other sheets are montly data
and are named 'Jan' 'Feb' 'Mar' etc.
At the moment I copy the required data manually using copy & paste, eg from
sheet Mar into Summary. No problem.
I would like to automate this by entering the name of the required month
into cell A1 in Summary, ie A1 contains the string Mar.
The other cells in Summary then need to reference the corresponding cells in
Mar.
I know how to do this sort of cell reference, eg in Sumary, in cell C3 I
put =Mar!C3, but I cant see how to get the Mar from cell A1 ?
I have tried as few things , eg =A1!C3 , and variants, but it doesn't seem
to work.
help & advice please?
Thanks
KK
I have asked this before and thought I undestood the answer, but I was
wrong. Can I ask it again please ?
I have a workbook with several sheets. The 1st sheet is called 'Summary' and
uses data from any one of the other sheets. The other sheets are montly data
and are named 'Jan' 'Feb' 'Mar' etc.
At the moment I copy the required data manually using copy & paste, eg from
sheet Mar into Summary. No problem.
I would like to automate this by entering the name of the required month
into cell A1 in Summary, ie A1 contains the string Mar.
The other cells in Summary then need to reference the corresponding cells in
Mar.
I know how to do this sort of cell reference, eg in Sumary, in cell C3 I
put =Mar!C3, but I cant see how to get the Mar from cell A1 ?
I have tried as few things , eg =A1!C3 , and variants, but it doesn't seem
to work.
help & advice please?
Thanks
KK