Matt Pinkston
asked on
Excel Copy Rows from one tab to another
I have an excel workbook with many rows in a tab called data... I would like to have another tab called terminated that would only show rows from the data tab where column K = terminated
how is this done with a formula or lookup etc...
how is this done with a formula or lookup etc...
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
okay then perhaps easier...
If I create a tab called totals and have a row labeled total active users how do I get the count of all records in tab data where column K=Active and column H=yes
If I create a tab called totals and have a row labeled total active users how do I get the count of all records in tab data where column K=Active and column H=yes
Has one or more of us answered your first question? If so then please close this question by selecting one or more of the suggestions and ask a new question.
ASKER
thanks for those answers
Hi Matt,
Seems like you haven't closed this question and requested 2 new questions.
If you are not aware of closing the question, please follow below links:
How do I accept a comment as my solution?
How do I close my question?
Thanks
Seems like you haven't closed this question and requested 2 new questions.
If you are not aware of closing the question, please follow below links:
How do I accept a comment as my solution?
How do I close my question?
Thanks
No comment has been added to this question in more than 14 days and OP agreed one of our solution helped him, so it is now classified as abandoned.
If you feel this question should be closed differently, post an objection and a moderator will read all objections and then close it as they feel fit. If no one objects, this question will be closed automatically the way described above.
If you feel this question should be closed differently, post an objection and a moderator will read all objections and then close it as they feel fit. If no one objects, this question will be closed automatically the way described above.
I’m glad I was able to help.
If you expand the “Full Biography” section of my profile you’ll find links to some articles I’ve written that may interest you.
Marty - Microsoft MVP 2009 to 2017
Experts Exchange MVE 2015
Experts Exchange Top Expert Visual Basic Classic 2012 to 2017
If you expand the “Full Biography” section of my profile you’ll find links to some articles I’ve written that may interest you.
Marty - Microsoft MVP 2009 to 2017
Experts Exchange MVE 2015
Experts Exchange Top Expert Visual Basic Classic 2012 to 2017
Copy or Move your Data Tab and rename it as "Terminated", then filter Col K with Terminated.
Else upload a sample workbook, we can provide you VBA solution.