I have a workbook with about 200 worksheets. I want to transfer the data
in a number of cells in each worksheet to a new worksheet. I would like
to do this automatically (not type in each entry). The data is not
contiguous...it's in different cells throughout the worksheet. The
transfer has to be done in order so that data for Wkst 1 is on one row,
data for Wksht #2 on the next and so on. I would then have new column
headings for the entrys. Any ideas? Thanks so much.


--
jimbob
------------------------------------------------------------------------
jimbob's Profile: http://www.excelforum.com/member.php...o&userid=29107
View this thread: http://www.excelforum.com/showthread...hreadid=488524