A quick question

[Rob Ireland]

I've got a quick question on behalf of the boss here

He's got a worksheet with several pages on it for his supplier info.

What he wants to to is to link cells on one page (tab) to that of another.

I dold him that he COULD just copy and paste the contents of one
worksheet to the bottof of the other, but that can get pretty sloppy.

Is this doable in excell? If so, how is it achieved? (detailed syntax
would be very helpful, if possible.


Thanx in advance!

 

[Andy Brown]

Not sure that what I'm reading = what you're asking.

In a file with two sheets, you can use a simple formula anywhere on Sheet2,
eg:

=Sheet1!A1

HTH,
Andy


On the stereo this week ; Albinoni, Samuel Barber, Nirvana, Sinead O'Connor

 

[David Turner]

Rob Ireland wrote

What he wants to to is to link cells on one page (tab) to that of
another.

Another way to get Andy's result:
Select the desired range on Sheet1, Edit|Copy, click tab of Sheet2, click
cell where you want the links to start and Edit|Paste Special, and click
Paste Link