View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
bony_tony bony_tony is offline
external usenet poster
 
Posts: 76
Default deleting rows in a huge spreadsheet with subtotals

so do you want to delete all the blank rows?

On Dec 13, 2:53 pm, ExcelNovice
wrote:
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.