deleting rows in a huge spreadsheet with subtotals

G

Guest

I use Peachtree which is an accounting package to run a small business. I
export Accounts Payable data from this package into Excel. When the data is
exported, it is subtotaled by each vendor with a blank row before and after
the vendor total.

I am looking for a way to easily delete rows from this report. The report
is updated daily and has over 600 rows. Any ideas or recommendations would
be greatly appreciated.
 
P

PY & Associates

If we know what rows to delete, automation is straight forward please.

Cheers
 
G

Gord Dibben

Select a column and F5>Special>Blanks>OK

Edit>Delete>Entire Row.


Gord Dibben MS Excel MVP
 
G

Gord Dibben

You do not delete each row individually.

Select an entire column by seleting the column header.

After the F5>Special>Blanks>OK all blank rows are selected.

With them still selected just Edit>Delete>Entire Row


Gord
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

macro to delete lines based on a value - Repost 2
How do I reverse a spreadsheet that is in the format of a subtota. 2
sum the number of rows in a spreadsheet given 2 criteria??? 3
Dealing with data in several columns AND rows 2
copying rows to all possible records during a macro 4
Adding Subtotals automatically to a TransferSpreadsheet Exported Excel File. 4
Transfer Spreadsheet not starting new Tab 1
Deleting rows based on values in a column 6

Top