Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula - Capture Multiple names into One cell | New Users to Excel | |||
Excel screen capture to capture cells and row and column headings | Excel Discussion (Misc queries) | |||
How do I capture info from multiple sheets to main worksheet? | Excel Discussion (Misc queries) | |||
capture last cell in column | Excel Discussion (Misc queries) | |||
Multiple Workbook Data Capture Summary Sheet | Excel Discussion (Misc queries) |