I want to Extract Data from multiple excel files based on Enquirer ID.
In Enquirer.xls I have Enquirer ID in Col A, Name in Col B.
ID - - - Name
1234 - - - Charles
1235 - - - Bennet
1236 - - - Andrew
1237 - - - Abraham
In Postal.xls I have date-wise Postal Communication information done on various dates.
So, ID may be repeated. (Date column is not given below)
ID - - - Postal Communication
1234 - - - Discount offered
1235 - - - New Scheme introduced
1234 - - - 30 days more
1237 - - - Introduce your Friends
Similarly in Email.xls I have date-wise Email information done on various dates. Again, ID may be repeated.
(Date column is not given below)
ID - - - Email Communication
1234 - - - Photos attached
1235 - - - MP3 Attached
1235 - - - more info
1237 - - - Invitation
Now, through VBA, I want to create Report ID-wise, omitting if no data found in Postal and Email (eg. 1236):
(Date column is not given below)
ID - - - Name - - - Postal - - - - - - - - - Email
1234 - - - Charles - - - Discount offered
1234 - - - Charles - - - - - - - - - - - - - - Photos attached
1234 - - - Charles - - - 30 days more
1235 - - - Bennet - - - New Scheme introduced
1235 - - - Bennet - - - - - - - - - - - - - - - - - MP3 Attached
1235 - - - Bennet - - - - - - - - - - - - - - - - - -more info
1237 - - - Abraham - - - - - - - - - - - - - -- Invitation
1237 - - - Abraham - - - Introduce your Friends
Please help. Thanks in advance.
Bookmarks