Copy Certain Columns to Multiple Sheets

    Hi,


    I have a master spreadsheet ("Sheet 1") containing data from A:BF.
    In columns A:F I have data that needs to be copied in all sheets (sheets 2, 3 and 4).
    Columns G:Q are specifically info that needs to be copied to "sheet 2"
    Columns R:AD are specifically info that needs to be copied to "sheet 3"
    Columns AE:AV are specifically info that needs to be copied to "sheet 4"
    Columns AW:BF are specifically info that needs to be copied to "sheet 5"


    So, essentially, "Sheet 4" should read data from master spreadsheet ("Sheet 1")like:


    A,B,C,D,E,AE,AF,AG,AH,AI,AJ,AK,AL,AM,AN,AO,AP,AQ,AR,AS,AT,AU,AV



    I hope my question was clear enough for someone to understand.

    Re: Copy Certain Columns to Multiple Sheets


    uhhhhhhhh, questions:


    1) You are using the word "copied", does it need to be copied? or do you just want sheet4 to contain the appropriate info from the master sheet?
    2) It would be...... relatively simple to set formulae on sheets 2-5 that would autofill the appropriate values from the master as they were entered.
    3) It would be relatively easy to write vba to fill values on sheets 2-5 from the master sheet when run

    Re: Copy Certain Columns to Multiple Sheets


    I want sheet 4 to contain the appropriate info from the master spreadsheet. I am also updating the master sheet so I need it to auto populate to the corresponding sheet.

    Re: Copy Certain Columns to Multiple Sheets


    Well, tbh, probably the quickest and easiest way to do this is just formula's. Put a named range around the data on your first sheet (called Main), ideally this should by dynamic. If you don't know how to to that, just make it "bigger".
    Then on all of the sheets, put this formula in cell a2 "=INDEX(main,ROW(),MATCH(A$1,INDEX(main,1,0),0))" then fill across and down. Set your column headings, and this will automatically pull information from the main table based on column headings.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login