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?