Hi, hopefully someone can help.
I have a 2 sheet spreadsheet.
The first sheet is an input sheet, with cells A2-5 all required entry fields.
The next sheet is a replica, but will hold all entries.
How do i write a macro which copys the data from sheet 1 into the next availabe blank row in sheet 2?
I have no experience of macro writing so would like to know all the steps from please.
Thanks
I have a 2 sheet spreadsheet.
The first sheet is an input sheet, with cells A2-5 all required entry fields.
The next sheet is a replica, but will hold all entries.
How do i write a macro which copys the data from sheet 1 into the next availabe blank row in sheet 2?
I have no experience of macro writing so would like to know all the steps from please.
Thanks