LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JJ JJ is offline
external usenet poster
 
Posts: 122
Default Delete unwanted data

Hi, I try to delete many unwanted rows in the middle of spreadsheet. Some
are just blank rows while some contained a subtotal from previous rows. I
only need to retain the data that has the acct code references in the column
D.

Is there any function that I can use to sort the data and delete the
unwanted rows?

Any help would be greatly appreciated!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
macro to delete unwanted data pm Excel Discussion (Misc queries) 2 May 2nd 07 06:50 PM
Macro to delete unwanted sheets Sal Excel Discussion (Misc queries) 5 March 15th 07 09:33 PM
How do I delete unwanted extra pages on Excel worksheets RogerD Excel Discussion (Misc queries) 4 May 20th 06 11:53 PM
Delete unwanted page breaks. Tionne Excel Worksheet Functions 1 February 21st 06 03:38 PM
Delete Unwanted Data Happy Excel Discussion (Misc queries) 1 August 17th 05 06:20 AM


All times are GMT +1. The time now is 02:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"