Consolidate based on a value in Excel

Closed
Sgot101 - Updated on Apr 2, 2018 at 03:06 PM
 Blocked Profile - Apr 5, 2018 at 04:51 PM
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
Related:

2 responses

Blocked Profile
Apr 2, 2018 at 04:42 PM
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.
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Apr 3, 2018 at 11:43 AM
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
Apr 3, 2018 at 04:44 PM
LOL! What a great solution! KISS!
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Apr 5, 2018 at 10:51 AM
Thanks ... uhm kiss back
No HOMO! I guess I should have clarified that!

KISS!
Keep It Simple Stupid!