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!!!

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

"Redoctober" wrote in message
...
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!!!

How do i do that?

"Don Guillett" wrote:


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

"Redoctober" wrote in message
...
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!!!

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.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Redoctober" wrote in message
...
How do i do that?

"Don Guillett" wrote:


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

"Redoctober" wrote in message
...
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!!!