Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Macro for Excel to eliminate rows
Name: eboudrot Date: January 20, 2004 at 13:26:28 Pacific OS: xp CPU/Ram: intel
Comment:
Hi, I am working with Excel and looking for a way to create a Macro to delete specific rows of data that are unnecessary. For example the worksheet contains the following rows.
Net Sales 100K Costs 50K Estimated income 400K
How would I create a Macro to delete the rows containing "Net Sales" and estimated income?
Name: Report_2 Date: January 20, 2004 at 17:38:08 Pacific
Reply:
I do not know how to do that but in this scenario I would use the Sort function and then delete the unneeded rows.
But, the wonderful and free Excel add-in called ASAP Utilities can perform this function under Select, Conditional row and column select, hide or delete; where you can specify rows that are not like "Costs" and it will then delete the others. See the screenshots on that webpage.
Loading ASAP Utilites with Excel slows down the startup of Excel but it is worth it. There are several other functions that I use often within this add-in of about 300 functions not available in Excel.
Summary: Yes but, before running the macro you must Cut column E and Paste it into column A for it to work as it only looks at column A. You can cut&paste it back into column E when done. You may have to inden...
Summary: hi I need any function or macro to do this conditional task as below! In excel file,I have a data from A1 to C300 then criteria 1: Check if A1= A2 then Criteria 2: Check if C1 = -C2 then Criteria 3: d...
Summary: Thanks for the access suggestion, I will try that. If anyone else has a suggestion or MACRO that I could use to force excel to do an "F2" and "enter" that would be appreciated too. ...
0 
