Avatar of 3wits
3wits
Flag for United States of America asked on

How do I highlight a row containing certain key words

I have attached my spreadsheet for reference.  I have a common spreadsheet with formulas.  It contains a macro that 1)removes totals; 2)set filter; 3)sort A; 4)sort C highest to lowest; 5)add subtotals: and last 6)remove filter.  Crtl-t is used to activate the macro.

This is what I still want to do.  Highlight the subtotal rows (or columns A-P) AND insert a blank line under the subtotals.

Can you help?
test--8-5-11.xlsm
Microsoft Excel

Avatar of undefined
Last Comment
3wits

8/22/2022 - Mon
ukerandi

check this one
test--8-5-11.xlsm
ASKER CERTIFIED SOLUTION
JP

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
3wits

ASKER
I've requested that this question be deleted for the following reason:

found my solution
3wits

ASKER
I found my solution
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
JP

I dont agree that the question should be able to be removed after a working solution has been provided.
JP

I dont agree that the question should be able to be removed after a working solution has been provided.
Saqib Husain

The first comment addresses only one of the two requirements.

The second and third comments each address both comments.
Points may be split between #36321455 and #36321492
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
JP

Why split the points if the second addresses both concerns and the third was submitted over 20I minutes later.
Saqib Husain

Splits are done with even larger time gaps.

Besides the two which address both issues do so in different ways. Any one may be preferred over the other. The OP is the best judge for the choice. That is why I suggested a split.
3wits

ASKER
I'm sorry for the problems this has caused.  I just registed for this site 2 days ago and I guess I was not aware of how it worked.  I actually deleted the question because I received the answer on another question from dlmille that also answered this question.  However, it was a separate question. You are correct, the first comment only answered part of the question and the 2nd and 3rd answered completly.  I will make sure I do things correctly the next time.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck