| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy from another sheet
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy from another sheet
=Sheets(6)!G53
If the sheetname is really: Sheet 6 then: ='Sheet 6'!G53 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "cottage6" wrote: 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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy from another sheet
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 On Fri, 2 May 2008 13:41:12 -0700, cottage6 wrote: 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! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy from another sheet
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. "Gord Dibben" wrote: 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 On Fri, 2 May 2008 13:41:12 -0700, cottage6 wrote: 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search for rows in one sheet and copy into another sheet based on customer id | Excel Worksheet Functions | |||
| How can i copy data from a tabbed working sheet to a summary sheet | Excel Discussion (Misc queries) | |||
| how to copy a cell with formula from sheet 1 (data is all vertical) into sheet 2 | Excel Worksheet Functions | |||
| 'Copy to' Advance Filter depend only on sheet ID not start sheet | Excel Worksheet Functions | |||
| relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) | |||
Linear Mode
