VBA code to copy paste transpose

[rshnkmr39]

Hi,

I have data in a particular row 7.

This row could have data anywhere from A7 to CD7. The data might start at B7 and End at Z7 or start from E7 and end at T7(the other cells being blanks).
There is data in each cell between the above mentioned range. it appears consequitively.The range can vary.
It could be from C7 to K7 or Z7 to AB.

I need to identify which is the first cell in the range with data and copy the rest into the next tab.
I would like to transpose it and paste it in the next tab from A1.


Thank You So much in advance

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.