Avatar of akatz66
akatz66
 asked on

VBA Transpose from one worksheet to another

Hi there,
    I am trying to create a macro to copy the contents of what an employee enters into a sheet (cells c4:c13), copy and transpose to another sheet that has the same column headings, but transposed. Both sheets are protected, so I need code to unprotect the sheets and re-protect them both after as well.  The copy sheet, productivitylog.xlsm should be opened and the data from the form should be pasted in (transposed) into the first empty row. I want the macro to be ctrl + t/

Both files will be located in:  
Form worksheet: s:\andy\form.xlsm (sheet name "Log")
Copy Worksheet to be transposed to  s:\andy\productivitylog.xlsm (sheet name "Booking Log"

The sheet that contains the form is cells c4:c13
copy sheet =  columns a-j

I also attached a screen shot of the sheet i want it to be copied to.   It should be transposed to a1:M1, but I really want it to find the first empty row and put it in there.



Thanks,
Andy
form.jpg
Copy-Sheet.jpg
Microsoft ExcelVisual Basic ClassicVB Script

Avatar of undefined
Last Comment
akatz66

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Norie

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
akatz66

ASKER
worked perfectly! Thanks so much, I love the experts and love this site!
akatz66

ASKER
thanks so much, you all are the best
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy