Ladybug924
New Member
- Joined
- Jun 26, 2013
- Messages
- 2
Hello,
Can you please help me creating a VBA script to automate the process to separte data files by "Payee" from master source file? Below is a sample source report (much simpler and shorter) to generate a separate Excel report by Payee. So, out of this sample, 3-new reports should be created after a successful automation. Thank you in advance for your feedback.
<TBODY>
</TBODY>
Can you please help me creating a VBA script to automate the process to separte data files by "Payee" from master source file? Below is a sample source report (much simpler and shorter) to generate a separate Excel report by Payee. So, out of this sample, 3-new reports should be created after a successful automation. Thank you in advance for your feedback.
| PAYEE | CLIENT | MOS | TOTAL | INVOICE# | CK# | CK DATE |
| VENDOR 1 | ABC | MAY/2013 | $100 | AAA | 123 | 6/22/13 |
| VENDOR 2 | DEF | MAY/2013 | $200 | BBB | 456 | 6/22/13 |
| VENDOR 3 | GHI | MAY/2013 | $300 | 111 | 789 | 6/22/13 |
| VENDOR 1 | XYZ | MAY/2013 | $400 | 222 | 321 | 6/22/13 |
<TBODY>
</TBODY>
