General discussion

Locked

Excel 97 cell refer to sheet

By sfath ·
I am trying to automate an entry in a cell to reference a certain sheet. I created a macro to enter data from an input box to cell B3. This is the same name as a sheet it creates at the same time. I would like to automaticly put the formula to refer to that sheet in cell G3.
Example: B3=Sheet1 G3= ='Sheet1'!J3.
Have I explained what I am looking for enough? I am stumped on this one.

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Excel 97 cell refer to sheet

by Jas03 In reply to Excel 97 cell refer to sh ...

I think this is what you need
formula on cell G3 would look something like this
if the file is open you don't need the path
='E:\My Documents\excelfile.XLS]b3'!b3

Collapse -

Excel 97 cell refer to sheet

by sfath In reply to Excel 97 cell refer to sh ...

Thanks for your help this is what I needed.

Collapse -

Excel 97 cell refer to sheet

by MqPasta In reply to Excel 97 cell refer to sh ...

If u want to link a cell from a sheet to another cell of another sheet but in same file , then u can done by the followinf:

=Sheet1!B3
[It will be there, where u want to link]

Thanks
M.Q. Pasta

Collapse -

Excel 97 cell refer to sheet

by sfath In reply to Excel 97 cell refer to sh ...

Thanks for your comments.

Collapse -

Excel 97 cell refer to sheet

by sfath In reply to Excel 97 cell refer to sh ...

This question was closed by the author

Back to Web Development Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums