James Sheriff formulated on Wednesday :
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.

More info would be helpful for making suggestions.

Are all 900 worksheets in a single workbook?
Are all the cells containing the address you need always in the same
column?
Do you need to parse the address from the cell contents?
Are there likely to be several cells with needed addresses on one
sheet? IOW, do you want to extract addresses from all cells on a sheet
in rows 2 to 4 that contain "PCP:"?
....

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc