Hi everyone
I need help with creating a macro that will paste named ranges into the correct order from one (Before) WS to another (After) WS on the same WB.
i have a macro that looks for *Top and * Bottom borders on the "Before" WS. Then it names this found range ( for eg A11:H15) according the value found in the Top Left Cell value for that found Range; in the example it would be the value in cell A11)
Then i have another macro that copies, pastes and reorganises all the values found in the "A" column from the 'before' WS to a new sheet (shown as midway sheet in the attached file).
Where i need your help is from here:
The names of all the ranges on the before sheet have now been sorted into order and the values have been split from just column A to columns A, B & C
Using the above information i need to be able to look at which resource is listed first. Copy and paste the corresponding Named range from the 'before' worksheet to the after so that they are in order
Please see the attached WB it provides a much more simple explaination to my problem
Regards
Jordan
Bookmarks