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

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?

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


"2nd Time Around" <2nd Time wrote in
message ...
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?

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