+ Reply to Thread
Results 1 to 5 of 5

Copy formula from horizontal to vertical format

  1. #1
    Forum Contributor
    Join Date
    01-03-2013
    Location
    Toulouse
    MS-Off Ver
    Excel 2010
    Posts
    141

    Copy formula from horizontal to vertical format

    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:
    Attached Files Attached Files

  2. #2
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2013
    Posts
    8,523

    Re: Copy formula from horizontal to vertical format

    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)
    Please Login or Register  to view this content.
    Try this, copy and paste towards down
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  3. #3
    Forum Expert Josť Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Copy formula from horizontal to vertical format

    Try this formula in D8 of each sheet

    Formula: copy to clipboard
    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)

  4. #4
    Forum Contributor
    Join Date
    01-03-2013
    Location
    Toulouse
    MS-Off Ver
    Excel 2010
    Posts
    141

    Re: Copy formula from horizontal to vertical format

    Hi,

    I Have Try It but It Is Not Working, Could You Please Exemplify on Attached Sheet
    Attached Files Attached Files

  5. #5
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2013
    Posts
    8,523

    Re: Copy formula from horizontal to vertical format

    see the attached file
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Convert Horizontal Data to a Vertical Format
    By skifiend in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-28-2018, 02:21 PM
  2. Excel VBA to copy and paste from horizontal to vertical format
    By ennin12 in forum Excel Programming / VBA / Macros
    Replies: 27
    Last Post: 09-24-2015, 05:12 PM
  3. Formula to get vertical data into horizontal format
    By razkowski in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 07-07-2015, 02:16 PM
  4. [SOLVED] Get horizontal data into vertical format using macro or formula
    By Sukhdev.Singh in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-07-2015, 06:47 PM
  5. [SOLVED] Change data from vertical format to horizontal format
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-27-2013, 07:06 PM
  6. HELP! Simple thing proving tricky! Horizontal/Vertical formula auto copy
    By Pudding in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-22-2012, 10:08 AM
  7. Convert Excel From Horizontal To Vertical Format
    By masrizam in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 04-13-2009, 02:29 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1