Help:macro to auto sort data to different worksheets...

[Guest]

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?

 

[Anne Troy]

Hi, 2nd. If you're going to use a main sheet all month, and then distribute
it to other sheets at the end of each month, this just might be your ticket:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=318
*******************
~Anne Troy

www.OfficeArticles.com

 

[Debra Dalgleish]

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 here:

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