Frode Hjoennevaag

Posts: n/a

Reference in a filename..

I need to create a filename based on the value in a cell for reference to
another worksheet. Is there any way I can do this with a formula?

='[Manager0"D4".xls]1A'!D4:D22

D4 contains the value I want into the filename and the stuff outside the
brackets is a reference within the ManagerXX.xls document..

If D4=3, the formula should get the referenced cells at the Manager03.xls
worksheet...

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
Maintaining cell reference after sorting	GRITS	Excel Discussion (Misc queries)	2	April 30th 23 07:42 PM
Absolute Worksheet reference number	Tony M	Excel Discussion (Misc queries)	4	March 21st 05 06:10 PM
Cell Reference Math	Ralph Howarth	Excel Worksheet Functions	0	January 26th 05 06:27 PM
Weekly Transaction Processing	Ralph Howarth	Excel Worksheet Functions	4	January 19th 05 05:37 AM
Insert value of a cell as a filename	Ralph Howarth	Excel Worksheet Functions	0	January 18th 05 12:03 AM

All times are GMT +1. The time now is 12:47 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us