Hi

I am looking for some advise in how to write a macro to create a named range IE upsJnl1 and then when the journal reference changes which is located in column b, it then names the range for the next journal to upsjnl1


in the attached image you can see there are two journals and the first named range upsjnl1 which is B1 to J10 and the second range is B11 to J20, there could be as many as 200 journals with the number of rows ranging from 2 - 100 lines and the upsjnlx reference needs to be unique for each journal and sequential

thank you so much in advance
in screenshot.JPG