This is a follow-on from Part B:
A macro is needed which will look at Col A of tab “Raw Data – copy” and where it finds a “C_Num” which has an alpha character it will:
- remove that row and write it to a new tab called “CS only”.
- Insert row totals and cross-totals
- Adjust the totals of tab “Raw Data – copy”