Problem moving data between worksheets

**Timeferret** · 02-08-2009, 10:57 AM

I am having problems placing data from one worksheet into another.
I have 3 worksheets named, VAT Sales, VAT Purchases and VAT Return.
I need to place data from VAT Sales worksheet cell L54 into VAT Return worksheet A1.

In the selected cell, A1 in VAT Return worksheet I have typed in the formula =VAT Sales!L54 but when I press return the My Documents window pops up. If I cancel, the error #NAME appears
I have experimented just using the worksheet names Sheet1, Sheet2 and Sheet 3.
Using the formula =Sheet1!L54 in Sheet3 the data from Sheet1 L54 is placed in the selected cell with no problem.
Does this mean my spreadsheet cannot recognise my own worksheet names unless they are the default names of Sheet1 , Sheet2 etc??

I am currently using MS Office 2007

Thank you

**excelnovice2007** · 02-08-2009, 11:11 AM

Originally Posted by Timeferret

I am having problems placing data from one worksheet into another.
I have 3 worksheets named, VAT Sales, VAT Purchases and VAT Return.
I need to place data from VAT Sales worksheet cell L54 into VAT Return worksheet A1.

In the selected cell, A1 in VAT Return worksheet I have typed in the formula =VAT Sales!L54 but when I press return the My Documents window pops up. If I cancel, the error #NAME appears
I have experimented just using the worksheet names Sheet1, Sheet2 and Sheet 3.
Using the formula =Sheet1!L54 in Sheet3 the data from Sheet1 L54 is placed in the selected cell with no problem.
Does this mean my spreadsheet cannot recognise my own worksheet names unless they are the default names of Sheet1 , Sheet2 etc??

I am currently using MS Office 2007

Thank you

Try putting your sheet names in ' ' marks i.e. ='VAT Sales'!L54