I need a Macro to Create Dynamic named Ranges on a cost schedule based on all the codes Ive entered in to column B, example (AB1, AB2, AB3 etc) these codes are also entered in column H additionally.
I need for the each Named Range to Start from the row position of the code in Column B in Column A (eg "AB1" is Cell B1 but need the Range to Start in A1) , then ending in Column H where that code is repeated (eg "AB1" in Cell H3) and so on for the other codes AB2, AB3 etc
Table Example.jpg
Bookmarks