Redwinger354
New Member
- Joined
- Aug 22, 2007
- Messages
- 5
Hello All!
I have a spreadsheet nearing 10000 various products with columns A-M.
I need to do the following:
Delete the entire row and shift up
If column H contains "this text" or "File Server Manager" or "ABT". Column H being the product description.
Basically, I have customers that are authorized only to sell certain products. So instead of filtering threw and saying, ok he cant sell "File Server Manager" delete that entire row. OR he cant sell these 10 products cause it says oracle in the product description then delete that row.
I was researching the fourms and saw something on AutoFilter. Will that work?
It was something along the lines of:
.AutoFilter field:=1, Criteria1:="ENTER TEXT HERE"
rng.SpecialCells(xlCellTypeVisible).EntireRow.Delete
I appreciate all your help!
Sincerely,
James
I have a spreadsheet nearing 10000 various products with columns A-M.
I need to do the following:
Delete the entire row and shift up
If column H contains "this text" or "File Server Manager" or "ABT". Column H being the product description.
Basically, I have customers that are authorized only to sell certain products. So instead of filtering threw and saying, ok he cant sell "File Server Manager" delete that entire row. OR he cant sell these 10 products cause it says oracle in the product description then delete that row.
I was researching the fourms and saw something on AutoFilter. Will that work?
It was something along the lines of:
.AutoFilter field:=1, Criteria1:="ENTER TEXT HERE"
rng.SpecialCells(xlCellTypeVisible).EntireRow.Delete
I appreciate all your help!
Sincerely,
James