Creating a macro to create sequential named ranges based on the content of a column

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

Hi
Sorry if my thread was not clear, I am not trying to create named ranges with the same name
The named ranges need to be unique and they need to increment with the same prefix ie upsJNL1, upsJNL2, upsJNL3etc
its to load into a oracle software package called FDM for loading multi journals and it has to be in a specific format

Basically, I want to be able to store in a variable of the current range which changes as it goes down the
spreadsheet, to be able to store the Start:finish cell reference to use as a named range formula,
and save the named range with the content of the cell of the first row/column of the range.

Be grateful for any assistance, I have tried to search to do this but cannot find any examples which match my issue