If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Using a Text Cell to Reference a Worksheet Name
I have one summary worksheet and approximately 45 data worksheets. Each row
on the summary page needs 8 - 10 cells from each data worksheet. The data worksheets are identical in format. I add about 4 new data worksheets a month. I am tired of the tedious formula entry for each new worksheet, and would like to have a way where i can enter the name of the new worksheet on the summary page and all of the formulas on that row use the entered text name to reference the appropriate worksheet and cell. Alas -- I have been unable to easily do this. I am still a relatively junior excel user. Any ideas? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Edit/Add record in form from cmdButton | doodle | General Discussion | 3 | December 28th, 2005 03:06 AM |
Newbie Looking for Help | Little Penny | Using Forms | 6 | December 27th, 2005 08:33 PM |
Is Access even the right idea? | BMB | New Users | 19 | November 21st, 2005 08:01 PM |
Change font of part of text | John | Powerpoint | 7 | March 15th, 2005 10:10 AM |
Access reports with a horizontal line after each record??? | Bill via AccessMonster.com | Setting Up & Running Reports | 6 | March 9th, 2005 04:51 PM |