i know how to group sheets. but i need specific data to fill in automatically
into certain spots with certain criteria. is this possible?
example.
on master sheet i enter data daily for orders. i have order worksheets for
each community. i enter the order on the master sheet. I need the data to
also fill in on another worksheet. If the order is for Ohio, i need it to go
into one sheet. if its for Michigan i need it to go to another. How can i set
it up to do that?

The workbook would be easier to maintain if you keep everything on the
master sheet, and use filters and pivot tables to view specific data.

However, if you need to separate state data, there's a sample workbook
on my web site, that sends data to individual sheets from a table on the
master sheet

http://www.contextures.com/excelfiles.html#Filter
under the heading 'Update Sheets from Master'

And if you need to keep formulas intact:

http://www.contextures.com/excelfiles.html#Function
under the heading 'Extract Items with Formulas'

Lila wrote:
i know how to group sheets. but i need specific data to fill in automatically
into certain spots with certain criteria. is this possible?
example.
on master sheet i enter data daily for orders. i have order worksheets for
each community. i enter the order on the master sheet. I need the data to
also fill in on another worksheet. If the order is for Ohio, i need it to go
into one sheet. if its for Michigan i need it to go to another. How can i set
it up to do that?


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