Link to home
Start Free TrialLog in
Avatar of crash1624
crash1624

asked on

Excel formula

Hello,

I need a formula to populate "tab1" with all data in all rows from "tab2" if that row's cell "total" equals "abc".

Thanks in advance for any tips.
SOLUTION
Avatar of Glowman
Glowman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of crash1624
crash1624

ASKER

Thanks for the answer.  To elaborate, I need to copy all row data on "Sheet3" if cell C of that row equals "$0".  I need this row data to copy to "Sheet4"

Thanks.
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial