Example:
http://speedy.sh/N7RM3/Test.xlsx
I'm trying to summarize data for those that open an email newsletter. Each sheet in a workbook will be unique to the date of the email.
Format
The format/headings of each sheet will be the same.
Email/Name
I need the summary to recognize unique email addresses and append data from subsequent dates onto the same row on the summary tab. However, their will also be email addresses that are removed or added. In this case the email address would show a blank for the date(s) where the email address was not included. (richard@test.com is an example of this on the example)
What is the best way to accomplish this?
I posted a similar request for help using Pivot Table in the heading, but have realized that a Pivot Table may not be the best option. I've tried using a PT that summarizes multiple sheets, but they output behaves differently than when you use one sheet. For example, the column headings are consolidated into 'columns' making it difficult to display the data you are looking for.
http://speedy.sh/N7RM3/Test.xlsx
I'm trying to summarize data for those that open an email newsletter. Each sheet in a workbook will be unique to the date of the email.
Format
The format/headings of each sheet will be the same.
Email/Name
I need the summary to recognize unique email addresses and append data from subsequent dates onto the same row on the summary tab. However, their will also be email addresses that are removed or added. In this case the email address would show a blank for the date(s) where the email address was not included. (richard@test.com is an example of this on the example)
What is the best way to accomplish this?
I posted a similar request for help using Pivot Table in the heading, but have realized that a Pivot Table may not be the best option. I've tried using a PT that summarizes multiple sheets, but they output behaves differently than when you use one sheet. For example, the column headings are consolidated into 'columns' making it difficult to display the data you are looking for.
