delete garbage from worksheet

  • Thread starter Thread starter mkk
  • Start date Start date
M

mkk

Hi,

I got a large feed from our mainframe and am trying to clean it up.
just want to keep rows where the number in column A is between 8000 an
10,000. Is there any way to delete the rest?

Thank
 
One way would be to simply sort on Col A and then delete all rows above and
below your criteria. Anything can be automated, but for one offs, it's usually
just as quick to do it manually.
 
You must log in or register to reply here.

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 Convert Value to Number, Sort, then Delete 16
Split data into multiple worksheets by row count 3
Delete Blank Cells in a Row 6
Macro reads cells with numbers . If given number is found , delets 2
Code to do a simple clean of one column by copying and pasting(finding and replacing) phrases in adj 4
Copying then deleting every second row 2
Delete all rows below my data to the bottom of the sheet 5
delete rows from AutoFilter or Advanced Filter range 1

Back
Top