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
|
|||
|
|||
Cell Capture Multiple WorkSheets?
Excel2003 ... I have approx 90 WorkSheets ... Cell D6 of each worksheet
contains a value I wish to capture in a single worksheet Col. I can select each cell & then select Cell D6 of the applicable worksheet, but I will have to do this 90 times ... & I have other Values I need to capture same way. Sooo ... is there a "Magic" way to do this? Thanks ... Kha |
#2
|
|||
|
|||
Cell Capture Multiple WorkSheets?
Do the 90 sheets have a pattern to them?
If so, you can use indirect... if you happen to have, say, Sheet1 - Sheet 90.. You'd have 1 - 90 as a row of values in say, row 1 then, you can enter: =INDIRECT("Sheet"&A1&"!D6) and copy across your row. Depending on your pattern, you coudl do this one of a few ways. If no pattern like that, it would require Visual Basic code... "Ken" wrote: Excel2003 ... I have approx 90 WorkSheets ... Cell D6 of each worksheet contains a value I wish to capture in a single worksheet Col. I can select each cell & then select Cell D6 of the applicable worksheet, but I will have to do this 90 times ... & I have other Values I need to capture same way. Sooo ... is there a "Magic" way to do this? Thanks ... Kha |
#3
|
|||
|
|||
Cell Capture Multiple WorkSheets?
You looking for a single column with D6's values of each sheet?
if yes one way is use indirect and address embeded like =indirect(address(6,4,1,1,"name of the sheet") hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Ken" escreveu: Excel2003 ... I have approx 90 WorkSheets ... Cell D6 of each worksheet contains a value I wish to capture in a single worksheet Col. I can select each cell & then select Cell D6 of the applicable worksheet, but I will have to do this 90 times ... & I have other Values I need to capture same way. Sooo ... is there a "Magic" way to do this? Thanks ... Kha |
Thread Tools | |
Display Modes | |
|
|