There are a couple of sample files here that use programming to extract
data to separate sheets:

http://www.contextures.com/excelfiles.html

Under Filters, look for 'Create New Sheets from Filtered List' and
'Update Sheets from Master'

And Ron de Bruin has some examples he

http://www.rondebruin.nl/copy5.htm

2nd Time Around wrote:
I want to have a main worksheet that i enter data into (sales listed by
vendor), which would then automatically drop the vendor's sales into their
specific worksheet for end of month reconciliation.

would i be able to do this with a macro? HELP?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html