Copy from another sheet

  • Thread starter Thread starter cottage6
  • Start date Start date
C

cottage6

I'm want a formula on Sheet 1 to refer back to a cell on Sheet 6, but I keep
getting an error no matter what I do. This is an example of the formula:
=Sheets(6)!G53
Can't I use a sheet name to get a value from another sheet, or am I missing
something stupid I'm doing? I do know the sheet name is correct. Thanks!
 
Just ='Sheet 6'!G53 should do the trick

Sheet(6) is VBA syntax for referring to sheet position in the workbook.


Gord Dibben MS Excel MVP
 
I've used that formula to no avail, but after I got thinking about this I
think I've figured out why the formula isn't working. I converted this file
from Lotus 123. Even though the sheet index number says it's Sheet 6, I
think it lost that affiliation somewhere along the line. I can reference it
with VB, but not in a formula. I'll just do this a different way, and forget
the formula altogether. Thanks to you and Max for your responses.
 
Back
Top