Hi,

I have a spreadsheet with 72 worksheets. I have to copy the data
from each one of them into a master sheet. My problem is I can not copy
everything. I have to look for particular data and then copy it.

My data looks something like this:

Sheet1 :

Business Services
Date
abcd

BUILT BILLED PHONE EXT

07/09/05 07/10/05 345-6789 22


Sheet2:

Summary
Date

BUILT BILLED PHONE EXT

07/09/05 07/10/05 345-6789 22


I have to extract only the data from BUILT column to the EXT column but
on each sheet the data does not start(BULIT BILLED PHONE EXT)
consistently from one certain row.


Please help!

Azra


--
Azra Akhter
------------------------------------------------------------------------
Azra Akhter's Profile: http://www.excelforum.com/member.php...o&userid=27483
View this thread: http://www.excelforum.com/showthread...hreadid=471160