hi
first of all I would thank Mr. Jindon for a great code from this earlier post https://www.excelforum.com/excel-pro...inventory.html
I would amend the code based on what I put in sheet"inventory1"
it supposes summing duplicated data in other sheets and put the result in columns f, g, h, I based on name headers are the same sheets name to understand it
thanks again
Bookmarks