Hi Teachexcel Team,
Hope everyone is doing great.
I have made a macro on copy, paste and than delete in attached sheet.
1. Here, I want to copy the entire filled row from "sheet1" i.e. from A3:C6 than
2. Paste at end below to "Report" and than
3. Delete the previous Rows from Report.
Require your help to fine tune the same, as i am facing some minor errors in running the macro.
Would appreciate your support for the same.
Regards,
Revised Question:
Below Time detail highlighted in bold to understand the difference.
1. Below Row to delete from Report:
Name | Stock production time | Current day Stock of Factory until time
a 2:00:00 2
b 2:00:00 3
c 2:00:00 4
d 2:00:00 5
2. Than, below Rows to copy from Sheet 1
a 5:00:00 2
b 5:00:00 3
c 5:00:00 4
d 5:00:00 5
3. and than paste to Report below past available Row and upgrade:
Name | Stock production time | Current day Stock of Factory until time
a 3:00:00 2
b 3:00:00 3
c 3:00:00 4
d 3:00:00 5
a 4:00:00 2
b 4:00:00 3
c 4:00:00 4
d 4:00:00 5
a 5:00:00 2
b 5:00:00 3
c 5:00:00 4
d 5:00:00 5
As you see, only below deleted rows are not available in final Report, rest is available:
Name | Stock production time | Current day Stock of Factory until time
a 2:00:00 2
b 2:00:00 3
c 2:00:00 4
d 2:00:00 5
Same I wanted and tried to run the macro in excel.
Hope you understand the problem.
Request you to Please help for solution.
Regards,