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