Excel Users

sparrowhawk · 10-20-2008, 10:09 AM

I have two Excel workbooks, one of which contains a lot of data, the other just a small amount but it duplicates a lot if stuff from the main workbook. I know there's a way to get the smaller one to update data from the main workbook - effectively linking the two together - 'cos I've done it before but I'll be jiggered if I can remember. I'm on Excel 2007.

Appreciate any input guys. Sorry it's such a boring question too!

Nomad · 10-20-2008, 10:33 AM

open both workbooks

go to the field you want to have your data/answer and type = then click on the window menu and select the workbook with the data click on the field you want and press enter

robertall · 10-20-2008, 10:52 AM

Copy, then go to the second sheet, go to paste special, and paste link. (Go to the little drop down menu below the paste).

Rob

10-20-2008, 10:09 AM	#1 (permalink)
sparrowhawk Junior Member Join Date: Sep 2008 Location: Truro, Cornwall Posts: 19	Excel Users I have two Excel workbooks, one of which contains a lot of data, the other just a small amount but it duplicates a lot if stuff from the main workbook. I know there's a way to get the smaller one to update data from the main workbook - effectively linking the two together - 'cos I've done it before but I'll be jiggered if I can remember. I'm on Excel 2007. Appreciate any input guys. Sorry it's such a boring question too!

10-20-2008, 10:33 AM	#2 (permalink)
Nomad Senior Member Join Date: Jul 2008 Location: Correze, France (19) Posts: 105	Re: Excel Users open both workbooks go to the field you want to have your data/answer and type = then click on the window menu and select the workbook with the data click on the field you want and press enter
	B&B 4 bikers by bikers in the beautiful Correze region of France....

10-20-2008, 10:52 AM	#3 (permalink)
robertall Senior Member Join Date: Apr 2008 Posts: 456	Re: Excel Users Copy, then go to the second sheet, go to paste special, and paste link. (Go to the little drop down menu below the paste). Rob
robertall Senior Member Join Date: Apr 2008 Posts: 456	Honda CG 125 CDI Import

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Sponsored Links

Sponsored Links