Hi:
I have excel sheet1 (Employees) with Name of employees in cell P1,Q1,R1, and so on.
I need the formula to transpose Name of employees in sheet2 in D6,D7,D8 and so on.
Thank you on advance for the help.
RM.
Hi:
I have excel sheet1 (Employees) with Name of employees in cell P1,Q1,R1, and so on.
I need the formula to transpose Name of employees in sheet2 in D6,D7,D8 and so on.
Thank you on advance for the help.
RM.
=TRANSPOSE() confirmed with Ctrl+Shift+Enter.
Before writing your formula, you need to mark the entire area to where you want transpose.
Sincerely
S?ren Larsen
"Give a man a fish, and you'll feed him for a day. Give a man a fishing rod, and he'll steal your yacht!"
Look at the function =TRANSPOSE(array)
HTH
Regards, Jeff
Hi:
Please refer to the attached sheet and help with formula.
Thanks
RM
On the Transpose tab, highlight C6:C42
Type =TRANSPOSE(Employees!$P$1:$AZ$1)
to confirm function, press Control + Shift + Enter
If done correctly, the formula will be encased with {}.
Do not enter these manually
Hi :
I will have employee list updated every pay period.
So would i need to do this every time.
If so then this will be a problem.
I wanted an easy way to transpose.
Thanks
RM
Easy is a relative term as to what you want to accomplish. How ofter is a pay period? Once a month, Every other week, Once a week?
Will the number of employees always be the same? Right now you have 37 Employees from Adriana to Victoria. If they are the same you can just paste over the existing employees and the Transpose function will pick up the new employess.
Another alternative could be VBA. Do you want this?
Hi Rizmomin. Maybe so
Please Login or Register to view this content.
Hi :
Yes i think i would be ok with VBA as per Nilem's code.
Works great.
Thanks a lot to all of you.
RM
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks