Home > IT Answers > Development > Selecting data to delete from column & rows
Mcgrath69
10 pts.
 Selecting data to delete from column & rows
VBA, VBA functions
I have a sheet that shows me supplier codes - example - these are four digit numbers like 1501 , 1524 , 1701 My problem is I only want to see data from certain suppliers. I have thousands on the sheet that runs daily, but I want to extract data from selected suppliers in column B and delete all others. I am completely new to this and hope you can help.

Software/Hardware used:
ASKED: July 18, 2012  9:50 PM
UPDATED: July 19, 2012  12:13 PM
RELATED QUESTIONS
Answer Wiki:
Use a filter. Select the entire sheet, go to Data/Filter and select Auto Filter. You will be able to click on the drop down arrow in the supplier column and choose the supplier you want.
Last Wiki Answer Submitted:  August 2, 2012  10:52 pm  by  scuzantip   35 pts.
All Answer Wiki Contributors:  scuzantip   35 pts. , Michael Tidmarsh   11,400 pts. , Mcgrath69   10 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

I have a sheet…
 
A “sheet” of what? What kind of thing is it? What type of file? What created it?
 
Tom

TomLiotta
 108,055 pts.