3wits
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I've requested that this question be deleted for the following reason:
found my solution
found my solution
ASKER
I found my solution
I dont agree that the question should be able to be removed after a working solution has been provided.
I dont agree that the question should be able to be removed after a working solution has been provided.
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
The second and third comments each address both comments.
Points may be split between #36321455 and #36321492
Why split the points if the second addresses both concerns and the third was submitted over 20I minutes later.
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.
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.
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.
test--8-5-11.xlsm