Consolidate based on a value in Excel Closed

Question

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

ac3mark · Answer

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 · Answer

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

Consolidate based on a value in Excel

2 responses

Similar discussions

Subscribe To Our Newsletter!