Posted to microsoft.public.excel.misc

external usenet poster

Posts: 184

Automate External References

I have an excel sheet that has external references to other sheets. Is there
an easy way to automate the external references to be added to my
consolidated excel sheet? Below is an example of the consolidated sheet.

Consolidated Sheet
a B
1 Excel File 1 A12
2 Excel File QCA A12
3 Excel File PBC A12
4
5

The rows reference a differenct excell file but alwas the same cells in the
file.

Thank you

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
References to external workbooks	Preston	Excel Worksheet Functions	4	July 27th 09 07:03 PM
Using external references as hyperlinks	Jo	Excel Discussion (Misc queries)	1	May 3rd 07 06:07 PM
External References in Functions	Ferencko	Excel Worksheet Functions	2	March 21st 07 07:30 PM
External References	Iain	Excel Discussion (Misc queries)	1	February 3rd 05 09:45 AM
External References not working right.	Dread_Pirate_Roberts	Excel Worksheet Functions	13	December 8th 04 11:07 PM

All times are GMT +1. The time now is 11:39 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us