Complex search, copy, and move opperation. Please HELP!!!

[Redoctober]

I need help with what seems to me a complex problem. Every week I get a
production report that I must then go through and search for items that have
been coded wrong in my territory. The catch is the production report covers
all of the US. So what I need to come up with is either a macro or a formula
that I can use to search for all the items that should be coded to my
territory. I have a list of all the cities in my territory in one file and
the production report comes every week in another file. I need all the rows
that match my list of cities to be cut and pated into a new sheet or new file
so i can then submit them for recoding. In the production report the cities
are in column Q. In the file that has my list of cities for my territory the
cities are in column B. The production report columns range from A to AL and
the number of rows keep changing every week.

Is what I am trying to accomplish even possible? PLEASE HELP ME!!!

 

[Don Guillett]

Yes, it's possible. Without seeing your layout I think?? what you need is a
macro that looks thru YOUR list of cities to get a match in the variable
master list and recode it. Shouldn't be too hard.

 

[Redoctober]

How do i do that?

Yes, it's possible. Without seeing your layout I think?? what you need is a
macro that looks thru YOUR list of cities to get a match in the variable
master list and recode it. Shouldn't be too hard.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)

 

[Don Guillett]

If you can't figure it out, send your file to my address below with snippets
of these emails and a VERY clear explanation of what you want and I'll take
a look when I have time.