| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Delete columns or rows
I regularly import a spreadsheet created in an accounting program. In order
to do what I want to do with it, I have to delelte rows and columns based on criteria, usually the row or column is blank. How can I do this using a macro or code? Ivor |
|
#2
|
|||
|
|||
|
Try this Add-in for rows (very easy to use)
http://www.rondebruin.nl/easyfilter.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Ivor Williams" wrote in message news:Iv%ne.1562042$8l.586206@pd7tw1no... I regularly import a spreadsheet created in an accounting program. In order to do what I want to do with it, I have to delelte rows and columns based on criteria, usually the row or column is blank. How can I do this using a macro or code? Ivor |
|
#3
|
|||
|
|||
|
Great add-in! Thanks very much for your help.
Ivor "Ron de Bruin" wrote in message ... Try this Add-in for rows (very easy to use) http://www.rondebruin.nl/easyfilter.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Ivor Williams" wrote in message news:Iv%ne.1562042$8l.586206@pd7tw1no... I regularly import a spreadsheet created in an accounting program. In order to do what I want to do with it, I have to delelte rows and columns based on criteria, usually the row or column is blank. How can I do this using a macro or code? Ivor |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to delete blank rows | Excel Discussion (Misc queries) | |||
| hidden rows & columns slow file open | Excel Discussion (Misc queries) | |||
| Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
| how do i delete the extra empty rows and columns that i dont need. | Excel Discussion (Misc queries) | |||
| How to delete extraneous rows and columns | Excel Discussion (Misc queries) | |||
Linear Mode
