This is a follow-on from Part A ref:
A macro is needed which:
- copies all the data from tab “Raw Data” to a new tab called “Raw Data – copy”
- looks at Col D of “Raw Data – copy” and where it finds “Job Cost” it removes that row from “Raw Data – Copy” and copies it to a new tab called “Job Cost”. So that when the macro is done executing, there will be no “Job Cost” rows in Tab “Raw Data – copy” as they would have all been moved to Tab “Job Cost”.
- Insert totals in Tab “Job Cost” (as was done in Tab “Raw Data”)