How to create a VBA script to automate the process to separte reports from the master (sourse of the report)

[Ladybug924]

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.

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>