Transpose 2 rows to column

Hi, I am trying to transpose 2 rows to column of different sheets, except summary and data sheets, and I've been trying to use this formula I got from the forum.

Please Login or Register  to view this content.

But I want to do two columns, first range is D10:D44 and the 2nd one is G10:G44, and also will clear all the contents of the target sheet every time it is run. The transpose will go into summary sheet

give this a try. Note my comments on the sheet names to be excluded.

Please Login or Register  to view this content.

Hi, Thanks for the reply. I want to clear the Sheets("Master").Cells(Rows.Count, 2) and below everytime i will run the macro.

It is difficult to understand how to modify the code. You need to provide the following information.
1. What are the names of the sheets you do not want to copy from? Show the names exactly as they appear on the sheet name tabs.
2. Do you want any of the range that is copied to be cleared on the sheet it is copied from? i.e. D10:D44 and G10:G44?
3. Is sheets("Master") the destination sheet for the copied ranges?
4. Do you want column B of Sheets("Master") cleared beginning on row 2 before or after the copy action?

Please answer all four questions to help clarify the issue.

Hi,

1. Names of the sheets are names of the employees, except Data and Master
2. No. Data will remain as it is from the copied range
3. Yes, "Master" sheet is the destination
4. I want column A of Sheet "Master" cleared beginning row 2 before the copy action.

Thank you for helping out. I really appreciate it.

See if this does it

Please Login or Register  to view this content.