| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking References from Multiple Sheets to One Summary Sheet | Setting up and Configuration of Excel | |||
| Linking sheets when sorting row and column data | Excel Worksheet Functions | |||
| Linking 2 Excel Sheets, Anticipating Lines. | Excel Worksheet Functions | |||
| Linking sheets to a summary sheet in workbook | Excel Discussion (Misc queries) | |||
| linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) | |||
Linear Mode
