| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro/VBA to delete rows in Spreadsheet
Hi all... looking for wisdom...
I have a text report that is pulled into Excel which I then sort & then manually delete certain rows (basically those with header/footer/total information from the original report). What I would like to do is create a macro/VBA code to do this automatically so that, for example, it looks down Column A for any cells with "A/C No" in & deletes any complete rows that have this information & then looks for the next "deletable header" e.g. "Report Total". It then needs to check column B for an "@" symbol or blank cells & again delete the whole row (blank cells in column B will have data elsewhere that I want to remove) Finally, ideally, it then needs to convert the text in columns B & D to Proper case Any suggestions would be welcome, Regards Colin Foster |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to delete alternate rows in a spreadsheet? | New Users to Excel | |||
| How do i delete empty rows in a spreadsheet | Excel Discussion (Misc queries) | |||
| delete all blank rows in a spreadsheet | Excel Programming | |||
| How do I delete both duplicate rows from a spreadsheet? | Excel Discussion (Misc queries) | |||
| Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) | |||
![Colin Foster[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
