 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / May 2008Copy 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! > =Sheets(6)!G53 If the sheetname is really: Sheet 6 then: ='Sheet 6'!G53  SignatureMax Singapore http://savefile.com/projects/236895 xdemechanik --- > 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'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! 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. > Just ='Sheet 6'!G53 should do the trick > [quoted text clipped - 7 lines] > >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 to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.