Friends,

I have a need to create a macro that will transpose data from all o
the pages (tabs) of an Excel spreadsheet onto a new tab. Th
information I need is contained in the same cells on each of th
worksheet pages. How can I transpose the data that I need?

Here is an example of what I have and the cells that need to b
transposed:

Page 1 - cell h20, c23, c24, h28
Page 2 - cell h20, c23, c24, h28
page 3 - cell h20, c23, c24, h28
etc.

I need to move this data to a new page (page 4) where only the cel
values (not the fourmulas that are present) are listed on the new pag
- one row for each page. I don't need header titles created in th
macro. The catch? Each tab is individually named after the employe
whose data appears on the page and I need the macro to create then nam
a new page to hold the transposed data.

Can anyone help create a macro to do this??
Thank you very much for your help!

Mik

--
Message posted from http://www.ExcelForum.com