Hi All,
I am sure this will be simple to do but I have a very limited knowledge of VBA.
I have a workbook that has a tab for each week of the year "Jan 4-10", "Jan11-17" etc. On the corresponding week, an engineer will enter details of machinery breakdowns, machinery number, start time and finish time. Using a new line for each breakdown. The user has 50 rows that can be used but may use as little as 10 a week.
For ease of trending the breakdowns throughout the year, I would like to copy the entries for each week into one final sheet "analysis" which I can then filter.
Simply: On each seperate tab copy the filled rows between A10:I60 and paste them into the final sheet each week following on from the last entry from the week before.
Hope somebody can help
Cheers
km555uk