Hello can somebody help with the following problem please?
I'm trying to create a macro which I will then attach to a button.
Macro steps:
1. Select next available row after row 3 on 'sheet2'
2. Insert current time of day into column B on selected row
3. Copy cell C7 from 'sheet1' and paste onto 'sheet2' into column A on selected row
4. Copy cell C5 from 'sheet1' and paste onto 'sheet2' into column C on selected row
(There are a lot more cells to copy over but if someone is able to provide the two above as templates, hopefully I'd be able to replicate)
(All of the boxes are all over the place but I want to put them into an order onto Sheet 2)
5. Once pasted on 'sheet2', delete the data that was copied so that sheet 1 is blank again ready for more data
Thank you
I'm trying to create a macro which I will then attach to a button.
Macro steps:
1. Select next available row after row 3 on 'sheet2'
2. Insert current time of day into column B on selected row
3. Copy cell C7 from 'sheet1' and paste onto 'sheet2' into column A on selected row
4. Copy cell C5 from 'sheet1' and paste onto 'sheet2' into column C on selected row
(There are a lot more cells to copy over but if someone is able to provide the two above as templates, hopefully I'd be able to replicate)
(All of the boxes are all over the place but I want to put them into an order onto Sheet 2)
5. Once pasted on 'sheet2', delete the data that was copied so that sheet 1 is blank again ready for more data
Thank you