+ Reply to Thread
Results 1 to 2 of 2

How to make a worksheet the standard format for future worksheets?

  1. #1
    Registered User
    Join Date
    08-10-2012
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    11

    How to make a worksheet the standard format for future worksheets?

    Hello all,
    I am a newbie here and I am trying to make one sheet the standard for all future sheets that open for this workbook. Lets say "sheet 3" will be my standard sheet and I need the future sheets to open with the same formatting. As a side note sheet 3 has drop down lists, and needs to be linked to a master page.

    Long story short I am setting up a format to interview existing employees for new positions. I have set up sheet 1 with a drop down list that has all of the associates names. When I click on the name another sheet appears renamed as the associates name. Now I just need to figure out how to bring over the interview format and eval form for each person.

    Any advice?

    Thanks in advance!

  2. #2
    Forum Contributor
    Join Date
    07-27-2012
    Location
    California, USA
    MS-Off Ver
    Excel 2003
    Posts
    198

    Re: How to make a worksheet the standard format for future worksheets?

    Attached is an Excel 2003 workbook that may give you some ideas in
    developing your own employee interview worksheet. One of the things
    it does is that it copies a template into a new worksheet then adds
    employee information to the new sheet. You may want to use this
    copying method to get all the required formatting and employee data
    into a new sheet.
    Jerry
    Attached Files Attached Files

+ 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