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
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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.
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
test--8-5-11.xlsm