deleting rows not containing data found in table

joed · May 10th, 2002, 08:47 AM

I have a macro that opens a file and cusotm sorts according a custom sort list. This brings all my wanted data to the top of the sheet. I would like to delete all the rows with data that is not part of the sort list. Is it possible?

Corni · Jun 1st, 2002, 09:32 PM

I think that what you need is to filter/advanced filter the set of data. This way you can select what data you need left for further processing. By sorting a set of data, all records remain in your list but rearranged.

Jack in the UK · Jun 2nd, 2002, 06:30 AM

Post you script up on the board, i and many will look at it for you and make some edits and amendments to try a get the code to do as you wish.

Jun 2nd, 2002, 06:30 AM	#3
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	Post you script up on the board, i and many will look at it for you and make some edits and amendments to try a get the code to do as you wish. __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 10th, 2002, 08:47 AM	#1
joed New Member Join Date: May 2002 Posts: 48	I have a macro that opens a file and cusotm sorts according a custom sort list. This brings all my wanted data to the top of the sheet. I would like to delete all the rows with data that is not part of the sort list. Is it possible?

Jun 1st, 2002, 09:32 PM	#2
Corni Board Regular Join Date: Mar 2002 Location: Brampton Posts: 324	I think that what you need is to filter/advanced filter the set of data. This way you can select what data you need left for further processing. By sorting a set of data, all records remain in your list but rearranged.