Copy row(s) from Sheet 1 to new row(s) on Sheet2

[mikewoool]

Hello,

Can you please help me with this problem. On my excel file I have a sheet named Form and one name MaintenanceLog. When someone fills out the Form sheet I would like that row(s) copied on to a new row(s) in the MaintenanceLog sheet. The Form sheet will be printed or saved as a different file name so every time you open the excel file the Form sheet will be blank but the MaintenanceLog sheet will show a history. Please help, thank you in advance.

mike

[jraj1106]

Hi Mike.

I checked the excel file. In MaintenanceLog sheet you have three columns "Date Opened", "Date Closed" and "Status". How will this be filled?

[jraj1106]

Try this :

MXLog.xlsm

In case the file cannot be opened the this is the code:

Please Login or Register  to view this content.