Modifying the code

[dreknapalci]

Hello,

can somebody please modify the code. I want to:

• The numbers which appears in column A- Exclude in sheet DATA should not be included in any of the RES. () sheets.
• In addition please make sure to sort each one of the RES sheets from smallest to largest.

What the code does now: It copies the values from sheets F, AR, AD into F-RES, AR-RES, AD-RES, adds prefix "972" in front of the values, removes duplicates and empty rows + few more conditions, which are not important for this task.

So when values are copied from F, AR and AD sheets into RES sheets, the code must check also into sheet DATA into column A and not add that values into RES sheets.

Hopefully I explained it well enough, I would appreciate any help.

Thanks in advance!

 

[Nebu]

Hi:

Sorry for the late reply. I was on my X'Mas and New Year break. I have modified the code.As per this logic you will get data only of F-RES , the other 2 tabs will be empty as the length of all the numbers on that tab is less than 12. Let me know with questions if any.

Thanks

 

[dreknapalci]

Hey Nebu, no problem, thank you very much!

I modified your code a bit and now it works as a charm, thanks!

Happy and successeful 2016