Web Development

Ask something
Discussion Locked

Excel 97 cell refer to sheet

0 helpful
5 replies

by sfath 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

5 replies

by jas03

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

by mqpasta

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

This discussion is closed to new replies.