Linking sheets
 

Hi,

I've got basic knowledge of Excel. Trying to keep some small business
bookwork. I was wondering if it was possible to link the data in a
field on sheet1 and a field on sheet 2 for instance.

At present I have a seperate file for each area of records. My aim is
to have one file with as many sheets a is needed or is possible

TIA

Alex


--
Alex01
------------------------------------------------------------------------
Alex01's Profile: http://www.excelforum.com/member.php...o&userid=26311
View this thread: http://www.excelforum.com/showthread...hreadid=395892

One way
In the cell in sheet 2 you want to bring the information into type"=" click
on sheet 1 and click the cell containing the information and press enter
HTH

"Alex01" wrote:


Hi,

I've got basic knowledge of Excel. Trying to keep some small business
bookwork. I was wondering if it was possible to link the data in a
field on sheet1 and a field on sheet 2 for instance.

At present I have a seperate file for each area of records. My aim is
to have one file with as many sheets a is needed or is possible

TIA

Alex


--
Alex01
------------------------------------------------------------------------
Alex01's Profile: http://www.excelforum.com/member.php...o&userid=26311
View this thread: http://www.excelforum.com/showthread...hreadid=395892

Thanks Ray.

It helps a lot.

Alex


--
Alex01
------------------------------------------------------------------------
Alex01's Profile: http://www.excelforum.com/member.php...o&userid=26311
View this thread: http://www.excelforum.com/showthread...hreadid=395892