I have an MS Excel database that is populated with an import from MS Access.
I would like to embed a Macro into this Excel Spreadsheet that does the following functions:
1. Automatically opens up any time it is updated (an import is received from Access)
2. Has a Filter intact for each column when it opens
3. Combines any duplicates:
Some records will have the exact same data except the 'AgentNo' column will be different. I would like only one record that simply combines all the 'AgentNo's' into a single cell.
On stead of reading:
8/9/14 ABC International, Inc. ABA12345 John Mistur VP of Accounting
8/9/14 ABC International, Inc. ABA54321 John Mistur VP of Accounting
It should read:
8/9/14 ABC International, Inc. ABA12345 ABA54321 John Mistur VP of Accounting
4. I would like this Macro Run, for this Spreadsheet, automatically every time it is open.
Can someone give me the Macro Code to do this?
Please see attached for the actual Spreadsheet.