Posts by VBA1234567889

    Currently have a "MASTER" sheet that each row of data updates frequently on. Have a second sheet "FORM" that has the template on it to that I need to transpose each row of data on from "MASTER" into a specific column on "FORM". Ideally the macro will:


    Copy and create sheet "FORM" and then transpose the data into the specified column range for each new row of data. (Each row of data gets a needs a new "FORM" sheet)


    This is what I have so far:


    Sheets("MASTER").Copy After:=Sheets(Sheets.Count)

    ActiveSheet.Name = "FORM"


    Workbooks("Macro.xlsm").Worksheets("MASTER").Range("A1:D1").Copy Workbooks("Macro.xlsm").Worksheets("FORM").Range("B1:B4").PasteSpecial

    Paste:=xlPasteValues,_ Transpose:=True


    I would like to have it loop to the next row on "MASTER" so I do not have to go into the Macro every time to change the range for the new row of data that needs to be transposed on the new "FORM" sheet.