F
Fyrsign
Okay, I'll try to keep this fairly striaght forward, but let me explai
the why before I explain the what...
I am in charge of a marketing mailing project that covers all of Nort
America. My company has broken NA up into 5 zones, using zipcodes a
their guide... What I've been doing over the last few months i
tracking everything I send by requests per item, requests by produc
group, by total volume of requests per month. I am trying to tren
everything I possibly can right now... What I want to add to this is
breakdown how much of a months worth of mailings go to a particula
zone... And I can't use the Database Administrators to do this (the
are overworked and grumpy). I have an MS Access tool I've modifie
(hacked because I barely know Access) to run some reports for a dat
range, and it gives me an excel spreadsheet of all the item/addres
data I need.
I have been given a list of every zipcode in our database and what zon
it corresponds to. I've grouped them by zone and taken just the first
digits of the zipcode (which is how the rest of the company uses th
zips), and have 5 columns of zipcodes against which I can compare/coun
the zipcodes I retrieve through my reports.
But I don't know HOW to do this comparisson/count/filter. Everythin
I've tried (I've never made a macro in my life, and couldn't get thi
working through a pivot table, and the functions didn't work right) ha
come up short.
As I see it, this is how I should have it working:
1 worksheet for each zone, in which I place the first three digits o
the corresponding zipcodes into a column.
After extracting the first three digits of every zipcode to which
have mailed something for the month, I paste that entire list into eac
sheet so that I get a count of ONLY those zipcodes that match for th
zone worksheet I am comparing against, and all others are jus
ignored/filtered.
Clear as mud
the why before I explain the what...
I am in charge of a marketing mailing project that covers all of Nort
America. My company has broken NA up into 5 zones, using zipcodes a
their guide... What I've been doing over the last few months i
tracking everything I send by requests per item, requests by produc
group, by total volume of requests per month. I am trying to tren
everything I possibly can right now... What I want to add to this is
breakdown how much of a months worth of mailings go to a particula
zone... And I can't use the Database Administrators to do this (the
are overworked and grumpy). I have an MS Access tool I've modifie
(hacked because I barely know Access) to run some reports for a dat
range, and it gives me an excel spreadsheet of all the item/addres
data I need.
I have been given a list of every zipcode in our database and what zon
it corresponds to. I've grouped them by zone and taken just the first
digits of the zipcode (which is how the rest of the company uses th
zips), and have 5 columns of zipcodes against which I can compare/coun
the zipcodes I retrieve through my reports.
But I don't know HOW to do this comparisson/count/filter. Everythin
I've tried (I've never made a macro in my life, and couldn't get thi
working through a pivot table, and the functions didn't work right) ha
come up short.
As I see it, this is how I should have it working:
1 worksheet for each zone, in which I place the first three digits o
the corresponding zipcodes into a column.
After extracting the first three digits of every zipcode to which
have mailed something for the month, I paste that entire list into eac
sheet so that I get a count of ONLY those zipcodes that match for th
zone worksheet I am comparing against, and all others are jus
ignored/filtered.
Clear as mud