Consolidate based on a value in Excel

[Closed]
Report
-
 Blocked Profile -
Hi All,

I have 2 worksheets and i want to consolidate them into a third sheet based on the value of column P.

If column P on either sheet (named 'SAP stock', and 'AS Stock') has 'No' from an if formula, i want the whole row to show on the third sheet.

I'm relatively new to using excel for reporting detailed info so any help would be appreciated.

Thanks!
Scott

2 replies


Take a look at this:
https://ccm.net/faq/53497-how-to-manipulate-data-in-excel-using-vba

Let us know if you get stuck with anything.
Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
486
Hi Scott,

Select a cell in your data table, go to Data ribbon and apply Filter. Now go to the header of column P and select 'No' from the drop down list. Select all visible rows and copy/paste them to the 3rd sheet. Repeat for the second sheet.

Best regards,
Trowa
Blocked Profile
LOL! What a great solution! KISS!
Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
486
Thanks ... uhm kiss back
No HOMO! I guess I should have clarified that!

KISS!
Keep It Simple Stupid!