+ Reply to Thread
Results 1 to 2 of 2

Structuring a workbook - Maintaining Same Structure In Multiple Sheets

  1. #1
    Registered User
    Join Date
    08-25-2009
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    38

    Structuring a workbook - Maintaining Same Structure In Multiple Sheets

    I have a long and elaborate table on Sheet1 of my workbook.

    I would like to have the same exact table on approx. 10 other sheets:

    -Same Formatting / Structure
    -Same Formulas in locked/protected cells
    -Mostly same named ranges but some will vary (Sheet1Column1, Sheet2Column1, etc.)
    -Different Values in unlocked cells

    When I make changes to Sheet1, I would like:

    STRUCTURAL CHANGES to apply to all 10 sheets (adding columns, table headers, formulas, formatting, etc.)
    DATA ENTRY CHANGES to apply only to the active sheet (entering a non-formula value)


    I know there is no magic trick that will make this all happen exactly as I want. I'm looking for strategies for organizing and structuring a workbook to make this more efficient.

    My current method is to make changes to sheet 1, copy them, select all 10 to make them active, paste the changes, then paste column widths. Then I have to go in and adjust all of my named ranges. It's tedius and easy to make mistakes... Any thoughts on a better system?

    Thank you

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Structuring a workbook - Maintaining Same Structure In Multiple Sheets

    Before you create the table or make changes to it, Group the sheets that you want to have the same formulas/formatting.

    Hold down the control key and click on any sheets you want grouped. Changes to the active sheet will carry over to all grouped sheets.
    IMPORTANT: Remember to ungroup them when you are done (Right click on any of the sheet tabs and choose "Ungroup")
    Does that help?
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1