Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Updating Sublists from Master worksheets
My company just compiled a large list of names and addresses for my
job (roughly 22,000) and right now the data is sorted by zipcode. This list is a mailing list for our clients and I'm trying to do a mail merge so we can send them a notice for a change in policy. I'd like to split the zip codes up into separate worksheets (sheet2 being zip codes that start with 0, sheet3 being zip codes that start with 1, etc) so that when we make a mail merge to print the labels we can do it in sections rather than the whole glob at once. Is there a way to have the non-master sheets reference that certain range (e.g. sheet2 going from zipcodes of 00000 to 09999) and updating when new addresses are added to the master list? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating Master Log records | Excel Worksheet Functions | |||
Updating Individual Sheets from a master | Excel Discussion (Misc queries) | |||
Updating Individual Sheets from a master | Excel Worksheet Functions | |||
Updating tabs linked to master tab | Excel Discussion (Misc queries) | |||
Automatically updating worksheets from a master worksheet | Excel Worksheet Functions |