Automate External References

J

Jeremy

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Embedded Excel into Word with Tables 0
Cell data entering slow! 0
Merge contents of two worksheets 1
Save workbook without shapes 0
Excel file linked to external source 0
selecting workbook/sheet 3
V Lookup multiple entires 1
Excel Macro help to merge multiple files 0

Top