Hello,
I am trying to create a series of workbooks which enable me to manage a number of different email distribution lists.
Workbook 1 contains all the data of everyone on all email distribution lists.
Workbook 2 contains all the data of everyone in distribution list 1
Workbook 3 contains all the data of everyone in distribution list 2
And so on.
The reason behind this is so that I can quickly update my gmail distribution lists by importing contacts whilst remaining certain that I have all the data on my computer as well.
The question I have is, is it possible to add a new row in Workbook 1, enter all the data, including a specific distribution list, and then have that new data added to the correct workbook which refers to that distribution list?
Or is it something I have to do manually each time?
If it makes any difference - I have next to no knowledge of VBA...
Many thanks in advance
I am trying to create a series of workbooks which enable me to manage a number of different email distribution lists.
Workbook 1 contains all the data of everyone on all email distribution lists.
Workbook 2 contains all the data of everyone in distribution list 1
Workbook 3 contains all the data of everyone in distribution list 2
And so on.
The reason behind this is so that I can quickly update my gmail distribution lists by importing contacts whilst remaining certain that I have all the data on my computer as well.
The question I have is, is it possible to add a new row in Workbook 1, enter all the data, including a specific distribution list, and then have that new data added to the correct workbook which refers to that distribution list?
Or is it something I have to do manually each time?
If it makes any difference - I have next to no knowledge of VBA...
Many thanks in advance
