Creating a master file using a macro

[RMGraham]

I am trying to Macro that will allow me to copy information from a standard sheet, to a master file that will record all information

This standard sheet I am using will have in Cell A1 the category "Job #", Cell B1 will have "Job Address", Cell C1 will have "Job Type", etc.

I want to be able to have a macro that will record this information into a Master File, and then when I clear the standard sheet, not have the information be cleared, while also having the next row of information inserted using the same cells from the Standard Sheet, A1,B1,C1, etc.

Standard Sheet (Cells A1,B1,C1)
Job 1, 1234 Street, Cars

MasterFile(Cells A1,B1,C1)
Job 1, 1234 Street, Cars

then

Standard Sheet(Cells A1,B1,C1)
Job 2, 5678 Road, Boats

MasterFile
Job 1, 1234 Street, Cars (Cells A1,B1,C1)
Job 2, 5678 Road, Boats (Cells A2,B2,C2)

and so on.

Can this be done with a Macro?

[JBeaucaire]

Here's a basic example:

Please Login or Register  to view this content.