Populating Data to Different Sheets

[Tankpotato10]

Ok, I'm struggling with entering info into the master sheet that will automatically populate into different sheets. This doc is for a game day menu with numerous suites. The master has the different menu name and the next sheets have the menu items all broken down. Hope that's enough info to get started.

 

[My Aswer Is This]

Welcome to the Group.
Please show us how your data looks now and how you want it to look. And we can start working on a solution for you.

 

[Tankpotato10]

5th floor	The tailgate	Double R Bar	Boise BBQ	The Fiesta	Luau	The Graduate	Sicilian	Pacific Rim
501					1
502
503
504
505
506
507
508
509
510
511
512
513
514
515

<colgroup><col width="64" span="9" style="width:48pt"> </colgroup><tbody>
</tbody>

*This is the master page. When entering the amount for each room, the order will automatically breakdown on the next sheets...*

	Entrees
	Tulsa 9/24
Entrée	Sliders	Dogs	Brats	Burgers	Pork	Bakers
Amount to Prepare per suite

<colgroup><col><col span="6"></colgroup><tbody>
</tbody>

*when 1 order for a Luau in 501 in entered, the other sheets that have that menu broken down will automatically have the room number and amount (1) in each column... As you can see there are numerous rooms. I hope this isn't too confusing to read