Sorting and copying data in Excel

[Jim R]

First off I am using Excel XP and Windows2000. What I would like to do is to take the items I type into a requisition form on Excel and then have them copied to different work sheets based on the budget code assigned to each item. Any direction on how to do this would be help. Thanks

Jim

 

[Dave Peterson]

Debra Dalgleish has an example workbook that does this using advanced filter.

http://www.contextures.com/excelfiles.html#Filter
Look for "Create New Sheets from Filtered List"

 

[Dave Peterson]

Oops. Look for this workbook:
Update Sheets from Master
from Debra Dalgleish's site:
http://www.contextures.com/excelfiles.html#Filter