Hi guys,
I’m having serious issues with a macro and I can’t figure it out : D this is the deal:
I’ve a worksheet with 12 columns. The last column contains only 1’s. The 5th column contains the ID-numbers that I need and the 10th column contains the criteria. Some of the ID’s are packages and sub package’s. The 1’s column L need to retain but all the 1’s of the sub packages needs to be deleted. For more clarification, I’ve added a worksheet as an example with two sheets (current version and preferred version).
Summarized:
If cell contains PP in column J, then --> check column E for ID.
IF ID contains numbers that are also in the cells below it, then remove the number 1 from cell L (of sub package).
I hope that you can help me because it’s a hard one.
Kind regards,
Flunzy
Bookmarks