Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
consolidate data (i.e. a single cell) from multiple spreadsheets intoa single sheet
Hello. I have about 900 worksheets (worksheet1, worksheet2, etc) all
of which have a single cell (mixed in with many other cells with data) that i am interesting in copying and pasting into a single spreadsheet. Am wondering if this is possible to pull of. Basically, in every single worksheet, in rows 2, 3 or 4, there is a single cell that has "PCP:" followed by the address i need. Ideally, i can find a way to copy the contents of all of those address cells into a single worksheet in A2, A3, A4, etc (i.e., into a single column). Any suggestions (including VBA code) would be greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to consolidate multi-row data into a single row? | Excel Worksheet Functions | |||
How to consolidate multi-row data into a single row? | Excel Programming | |||
Consolidate multiple workbooks into a single worksheet | Excel Worksheet Functions | |||
Consolidate multiple spreadsheets into a single workbook | Excel Discussion (Misc queries) | |||
Multiple sheets as data for a single sheet | Excel Worksheet Functions |