I want to do a simple copy and paste from one tab of my workbook to another.
I created 24 named ranges (not efficient I know), 12 for the copies and 12 for the pastes, again all a part of 12 cases.
The copy is somewhat static, it will always be one row of cells, the reason I have it to be...