Hi All
I'm trying to do something all with one macro to save some time if it's possible.
I have a worksheet currently with just over 100 rows, in column A I have a list of the new worksheets I'd like to create. In columns B to M adjacent i have the information that I'd like to copy to the new worksheet and transpose it the process.
So basically an example would be: Create a new worksheet named after the content of A2, Copy the information from B2:M2 paste into A1 to the newly created sheet and transpose, when this is done move to A3 and repeat.
Any help would be appreciated
cheers
Paul
I'm trying to do something all with one macro to save some time if it's possible.
I have a worksheet currently with just over 100 rows, in column A I have a list of the new worksheets I'd like to create. In columns B to M adjacent i have the information that I'd like to copy to the new worksheet and transpose it the process.
So basically an example would be: Create a new worksheet named after the content of A2, Copy the information from B2:M2 paste into A1 to the newly created sheet and transpose, when this is done move to A3 and repeat.
Any help would be appreciated
cheers
Paul