Good morning Experts,
I need your help.
attached is a sample sheet prices.
I need few things done.
1- increase the values in cells by the amount in cell L1
2- Create new sheets based on Column A
3- Copy Header into all new sheets created, and copy the rows. (paste on new sheet Starting A7)
4- Find the same postal code in Column B, Copy Rows as well. (At the bottom of what has already been copied from previous). HOWEVER, when pasting, switch Column A with B and B with A.
Example: Postal Code (CORE)
I have 24 rows in Column A, 116 rows in Column B,
All will have to be copied to the new created sheet (Core) with headers.
I should have about 150 or so new sheets created
Every sheet will have about 140 rows plus header.
Any help is greatly appreciated.