theprincipal78
Board Regular
- Joined
- Aug 5, 2009
- Messages
- 68
Hi. it's been some time since I posted something. Thank you in advance.
I handle very large amounts of distribution ists and email addresses.
here is the situation:
I have 9 columns of email addresses over multiple worksheets in a workbook. Every worksheet represents a distribution list
the categories are "To", "Cc" and "Bcc" for 3 different groups of peple. hence 9 columns.
I would like to Identify how many email addresses are on each sheet.
I would approach this by counting the number of "@" on every sheet.
Table of contents across the web count the number of rows or cell for every sheet. I would like to count the number of "@" for every sheet instead.
thank you for any ideas.
I handle very large amounts of distribution ists and email addresses.
here is the situation:
I have 9 columns of email addresses over multiple worksheets in a workbook. Every worksheet represents a distribution list
the categories are "To", "Cc" and "Bcc" for 3 different groups of peple. hence 9 columns.
I would like to Identify how many email addresses are on each sheet.
I would approach this by counting the number of "@" on every sheet.
Table of contents across the web count the number of rows or cell for every sheet. I would like to count the number of "@" for every sheet instead.
thank you for any ideas.