Pivot table v Advance filtering v Macro v VLookup
I have an extensive worksheet where I want to bring over specific data to a new worksheet. What I am trying to do is determine the best approach.
There are 18 columns with data, number of rows just depends.
Out of the 18 columns, there are 3 columns that I use to determine as to what data needs to be brought over to the new worksheet.
I need all columns to the left and right for each row that contains my specific parameters to be brought over, keeping totals as well.
All data that does not meet the parameters in not necessary.
On the attached document the RAW Data tab is what is brought over, the row/s columns are the parameters I use to filter.
The Result tab is what I need for the final worksheet to look like.
What would be the best approach - Pivot Table, Advanced Filter, Macro OR VLookup
|