HEY Guys
Please I have a list of 5 people on Horizontal master sheet, and each person has
a dedicated sheet
I want to copy the formula from Horizontal master sheet to each person sheet but on vertical lay out (vertically) so each time I make a change on the master sheet it appears on correspondent day to a personal sheet
NOTA:
your data have leading spaces in C8:C12 of Horizontally sheet and in Cell "C4" , please remove the spaces and use below formula
D8=VLOOKUP(TRIM(SUBSTITUTE($C$4,"Name:","")),'Horizontally '!$C$8:$AH$12,MATCH($C8,'Horizontally '!$C$7:$AH$7,0),0)
Try this, copy and paste towards down
Please Login or Register to view this content.
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Try this formula in D8 of each sheet
Formula:
Please Login or Register to view this content.
and copy down
You can simplify the formula if you use a cell to put only the name , e.g. $C$4<-- "WALTER " (avoid the space after)
Hi,
I Have Try It but It Is Not Working, Could You Please Exemplify on Attached Sheet
see the attached file
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks