hi all
i have an excel sheet that looks like below
I'm looking for a VBA that would automate for me column D and assign category numbers starting with 001 002 etc..
the criteria is if they are are all the same price, but also right underneath each other so for example the item number 00001 and item number c123 are both 100 dollars but not the same group
there will always be an empty row between each group
any help is greatly appreciated
thanks
i have an excel sheet that looks like below
I'm looking for a VBA that would automate for me column D and assign category numbers starting with 001 002 etc..
the criteria is if they are are all the same price, but also right underneath each other so for example the item number 00001 and item number c123 are both 100 dollars but not the same group
there will always be an empty row between each group
any help is greatly appreciated
thanks