Hi,
I need a macro that would do the following. Can anyone help me out please?
Thanks.
Get unique item numbers and copy them on to a sheet
Do a sumif on each unique item number (that was created in the previous step - on the sheet containing unique item numbers) and sum column C of the originial shee.
Do a vlookup on the item in the unique numbers sheet, and get values from column F for that item
Subtract the value in the Sumif column from the value in the vlookup column
Mark (check mark or anything) on entries where the subtraction is =<0
Do a vlookup on the unique item number sheet, and put the mark (see above) on the items in the original sheet
Keep all the items with the mark and delete the rest
save the sheet in a specific location
Bookmarks