KevinB

Posts: n/a

Using a worksheet name in a formula

Hi,

I have 100+ worksheets. I have formulas that hard code those worksheet names.
Such as the the simple formula: =Sheet58!$E$2

I would like the "58" to be generated from cell (i.e. A1 has a value of 58)
so I can have a formula that like:

="Sheet($A$1)"!$E$2

What is the correct syntax? I tried INDIRECT, but could not get it to work
...

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
revert formula insertion to old method	Don't be a pain in the ass	Setting up and Configuration of Excel	0	January 24th 05 01:49 PM
If Formula	Bo	Excel Discussion (Misc queries)	0	January 19th 05 09:39 PM
Reference Data in Moved Worksheet	tommcbrny	Setting up and Configuration of Excel	1	December 1st 04 06:49 PM
Worksheet name and Backward compatibility	Rich	Excel Discussion (Misc queries)	3	November 30th 04 06:10 PM
Display excel formula on worksheet	superchica	Excel Worksheet Functions	2	November 3rd 04 06:38 PM

All times are GMT +1. The time now is 05:04 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us