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:
ActiveSheet.Name = "FORM"
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.