Hello.

Im a beginner in Excel, but have been asked from my boss to create a spreadsheet. My problem is:

I´m going to make day sheets for crew working on a production. The different crews will need different day sheets.

I´m going to need the following spreadsheets:



1 day sheet for band and dancers
1 day sheet for crew
1 day sheet for the artist

Ideally should all these sheets be feeded with information from one complete sheet containing all information needed.

So I´m asking all of you experts / geeks 8) - is this possible? And if so if so, how?

Thanks!

Make up your daily sheet with all the information you want as your basis. Based on what I could glean from your post, I would have one workbook with separate tabs for each group: band/dancers, crew, artist.

At this point, I think it should be saved as a template: File: Save As, choose Excel Template for the File Type. Call it something like "Daily template".

Close Excel. Now when you open Excel to start a new sheet, File: New and select the template. When using templates, when you modify the sheets, you will be prompted to name the new sheet upon saving or closing. Thus, the underlying template is never changed and you can keep reusing it over and over again.

Next step, Excel journeyman level: locking cells that shouldn't be edited and protecting the sheets in the template.

If you need additional help, please post your first cut and I will be glad to help.