ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Updating Sublists from Master worksheets (https://www.excelbanter.com/new-users-excel/148466-updating-sublists-master-worksheets.html)

[email protected]

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?



All times are GMT +1. The time now is 11:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com