bomberchia
New Member
- Joined
- Nov 28, 2008
- Messages
- 3
Hi Community,
I was browsing through the forum and found a few interesting topics on using macros to extract data out from multiple sheets in Excel as seen as via the trackbacks.
What I have on hand is slightly different hence requiring some advice.
I have the followings:
So the Social IDs submitted by Sales on the Submission Data sheet could be approached / pitched by another sales agent on the phone on different months of leads (as seen in the leads files)
What is the best way via macro to display in the Submission Data sheet the months which the lead appeared in (could be more than 1 month) and pitched by which sales agent (could be different agents on the same month or different months?
I was browsing through the forum and found a few interesting topics on using macros to extract data out from multiple sheets in Excel as seen as via the trackbacks.
What I have on hand is slightly different hence requiring some advice.
I have the followings:
- Sheet 1:Submission Date
- Sheet 2: April Leads
- Sheet 3: March Leads
- Sheet 4: Feb Leads
So the Social IDs submitted by Sales on the Submission Data sheet could be approached / pitched by another sales agent on the phone on different months of leads (as seen in the leads files)
What is the best way via macro to display in the Submission Data sheet the months which the lead appeared in (could be more than 1 month) and pitched by which sales agent (could be different agents on the same month or different months?
