consolidate data (i.e. a single cell) from multiple spreadsheets intoa single sheet

J

James Sheriff

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extracting data from Multiple columns to a Single row 3
Search and consolidate multiple values in multiple fields 2
Pasting a cell into bookmarked table from excel vba 1
Applying a formula to multiple values within a single cell? 1
Multiple selections in a single cell - How? 14
sorting data from different sheets into single sheet 0
Transpose data into a single cloumn 6
Concatenate multiple lines 2

Top