Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
worksheet name variable external data cell
I have a workbook with several worksheets - one for every job, and each
worksheet is named with the job name. I am trying to make a summary sheet with each job as one line, and I need to get a specific cell value ($C$4) individually from each worksheet. The value for each line must correspond to the correct job, so I have entered the job name in the first column of the summary sheet I'm making. How can I use the job name (column 1 of the summary sheet) to reference the correct worksheet when I call up the value of cell C4 from each sheet individually? |
#2
|
|||
|
|||
Quote:
http://www.cpearson.com/excel/excelM.htm#SheetNames |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
worksheet name variable external data cell
Hi Chuck,
It sounds like an interesting problem to solve. May I request you to mail me the workbook at and explain the problem very clearly. -- Regards, Ashish Mathur www.ashishmathur.com http://www.linkedin.com/in/excelenthusiasts "Chuck" wrote in message ... I have a workbook with several worksheets - one for every job, and each worksheet is named with the job name. I am trying to make a summary sheet with each job as one line, and I need to get a specific cell value ($C$4) individually from each worksheet. The value for each line must correspond to the correct job, so I have entered the job name in the first column of the summary sheet I'm making. How can I use the job name (column 1 of the summary sheet) to reference the correct worksheet when I call up the value of cell C4 from each sheet individually? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Link variable data from one worksheet to another worksheet? | New Users to Excel | |||
Variable worksheet name (tab) linked to cell in same worksheet | Excel Worksheet Functions | |||
Variable external data through a Microsoft Query | Excel Worksheet Functions | |||
can a worksheet template contain variable data? | Excel Discussion (Misc queries) | |||
Get External Data Web Query new worksheet | Excel Discussion (Misc queries) |