Previous Topic Next Topic

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

Answer 1 / 2
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.
Answer 2 / 2
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor 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 Contributor Last seen December 27, 2022 555
Apr 5, 2018 at 10:51 AM
Thanks ... uhm kiss back
Blocked Profile
Updated on Apr 5, 2018 at 04:52 PM
No HOMO! I guess I should have clarified that!

KISS!
Keep It Simple Stupid!

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
How to add Rows automatically based on Cell Value In Excel?
Raj_2823 -
TrowaD -

7 responses