ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Delete columns or rows (https://www.excelbanter.com/excel-worksheet-functions/29182-delete-columns-rows.html)

Ivor Williams

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



Ron de Bruin

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




Ivor Williams

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







All times are GMT +1. The time now is 04:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com