Updating Inventory Macro

[Fredbugatti]

Hi,
I need a button in sheet 1 which will update inventory for UPC in column B with the greater inventory in Sheet 2 since there are 2 UPCS with different SKUS which are technically the same item but different packaging.
I have attached the sheet.

For example:
I vlookup Inventory for UPC- ABC123

and in sheet 2 there 2 of the same UPC, I need it to take the greater number.

Thanks!

[dflak]

You state that you have Excel 2003 but attached a file in 2007+ format. What version do you truly have? This issue can be solved with a pivot table. If you have Excel 2010 or later, you could use a slicer to control it making it a lot easier to manipulate.

[Fredbugatti]

Hi,
Sorry for the confusion, Please see attached I would like a VBA code implemented within a button on sheet 1 to return result of greater number from sheet 2 even though they have the same UPC.
The issue is every time I vlook up the inventory it shows me the lower number instead of the higher.


I have attached a sheet and made it simpler with just 2 items, when I vlookup it gives me the lower number result and not the higher.


Please see attached.

[dflak]

The pivot table picks the maximum value for the item selected.

[Fredbugatti]

That will not give me the result I need since I need to input information in sheet 1

[bakerman2]

You could try this.

Please Login or Register  to view this content.