Copy from another sheet

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!
 
G

Gord Dibben

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
 
C

cottage6

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dependent drop down dynamic range formula, off sheet. 7
Vlookup and return sheet name also 2
INDIRECT with Sheet Level Defined Name 2
Referencing formula using Indirect 4
Automatic Sumning of Same Cell from Different Sheets 3
Can I use a worksheet name in a formula? 4
COUNT rows on external sheet if between date range 3
reference work sheet name by using a formula 3

Top