PDA

View Full Version : MACRO/VBA - Extract unique values to different worksheet that meets a criteria



acerlaptop
02-17-2020, 01:34 AM
Hi everyone. (NOTE: Due to company privacy policy, I can't upload sample file)

I have to Worksheets.

Worksheet 1 = Summary
Worksheet 2 = Data

What I want is to update Summary, for example starting at cell L47 down until L56 (all blank cells). I want to put values in there from DATA worksheet that passes certain criteria, that is, DATA (Column A) = SUMMARY (A1).

Also, DATA (column F) contains different codes. So basically, Summary (L47) will be updated with unique values from DATA (column F) that passes the criteria. As long as there is a unique value from DATA (column F) that passes the criteria, the code will list it down to SUMMARY (L47), and if L47 to L56 are all full but there are still unique value to paste, then the code will add rows.