Refer to previous sheet

Topic

New Reply

Hello

I am working on a sheet called 03.
I need to reference/pull in information from the previous sheet called 02DelRec from cell cc523.

My formula works when I use sheet numbers that do not have a zero in front of them.

=INDIRECT(“‘”&TEXT(BX505,”00″)&”‘!cc523”)
where BX505 is the cell containing the sheet name – for example 02DelRec (does not work) or 11DelRec (works) etc

Regards

Reply | Quote

Replies

Have you tried switching the code so it refers to the Worksheet numbers within the Workbook instead of the Worksheet names?

Reply | Quote

This may be too simplistic but have you tried:

Put a + sign in the cell you want the data to appear
Go to the other spreadsheet and highlight the cell that has the data you want
Hit enter
This will take you back to the first spreadsheet and the info will appear.

Reply | Quote

Shouldn’t your formula be:

=INDIRECT(“‘”&TEXT(BX505,”00″)&”DelRec’!cc523”)

Reply | Quote