Does this summarise everything correctly:
- copy Range("AR3:BB28") from each sheet in turn
- paste values to sheet "Gail"
- "Gail" headings are in Row1 and the data starts in A2
- remove any rows where Units = 0 (in "Gail")
- put all text into uppercase (in "Gail")
Where (in relation to other sheets) should "Gail" be placed?
Bookmarks