Delete rows w/values; create mult. sheets from data

tweetyksc

New Member
Joined
Mar 4, 2002
Messages
19
What's the best way to automatically search for and delete rows that have a certain value in a field? For example, in a spreadsheet, I want to find all the lines that have "x" in a field and delete them from the spreadsheet.
Also, is there a way to extract certain data and create separate worksheets? For example, each different sales person code should be on a different worksheet; all are on one currently.
 

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.
On 2002-03-22 09:49, tweetyksc wrote:
What's the best way to automatically search for and delete rows that have a certain value in a field? For example, in a spreadsheet, I want to find all the lines that have "x" in a field and delete them from the spreadsheet.
Also, is there a way to extract certain data and create separate worksheets? For example, each different sales person code should be on a different worksheet; all are on one currently.

I'd suggest using Data|Filter|AutoFiler. Select custom, containing X; then you can delete the rows that contain that value.

As for creating a sheet per sales rep, an "idea" is to create one master sheet that has a table containing all the information headings from the master sheet, the populate it with vlookups that run off the sales rep name: then make copies for as many sales reps as you have and input the unique rep name for each sheet -- the tables would fill in with the vlookups for just that rep on each sheet.

If you can "see" this idea, great - if not, give a shout for more clarification.

_________________
Regards, Duane
This message was edited by Duane on 2002-03-22 11:05
 
Upvote 0

Forum statistics

Threads
1,213,526
Messages
6,114,122
Members
448,550
Latest member
CAT RG

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top