Posted to microsoft.public.excel.worksheet.functions

Paul

external usenet poster

Posts: 661

Variable cell referencing

Hey all,

I could really use some help. I need to create a formula to reference many
different external sheets at once automatically.

Column A Column B
Name1 \\Home\Folder\Name1.xls
Name2 \\Home\Folder\Name2.xls
Name3 \\Home\Folder\Name3.xls

Any help would be appreciated.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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
Referencing tab based on Variable	Chad	Excel Worksheet Functions	2	June 8th 07 03:48 PM
Variable in VLOOKUP and referencing a cell another file in excel	Dave T at home	Excel Worksheet Functions	1	August 9th 06 03:14 AM
Variable Cell Referencing	0-0 Wai Wai ^-^	Excel Worksheet Functions	3	June 16th 06 09:34 AM
Referencing a Value in variable length columns.	Kevin	Excel Worksheet Functions	11	January 28th 06 11:01 AM
Referencing Variable Name Worksheets	camerons	New Users to Excel	8	May 9th 05 09:57 PM

All times are GMT +1. The time now is 04:34 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us