Thread
:
Macro to keep 15 specific records and delete 1000 other rows.
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
Macro to keep 15 specific records and delete 1000 other rows.
You don't say how many of each or if they are together or separated
1 a
1 b
2 a
4 b
8 c
--
Don Guillett
SalesAid Software
"Sam" wrote in message
ps.com...
Hi Gang,
I work inventory control for a company in Texas and have to check stock
levels for around 15 parts daily. The download for these parts contain
an additional 1000 other rows of part numbers I dont need. I have used
Excel macros in the past that delete rows based on specific criteria
but how
do I do the reverse? Essentially use a macro that says "keep these 15
specific part numbers" but delete everything else that isnt them. I
posted this question mistakenly in an Access forum so my aplogies if
this looks like a double post.
Your help is greatly appreciated.
Sam
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett