Closed Thread
Results 1 to 6 of 6

Auto copying entered Preferences from a Master sheet to multiple worksheets

  1. #1
    Registered User
    Join Date
    06-26-2009
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2003
    Posts
    2

    Post Auto copying entered Preferences from a Master sheet to multiple worksheets

    Hi all - I have a master page with A1 containing the names of staff members and then 5 columns indicating preference1 .... preference5.

    Each preference column will have one 4 digit site code i.e. 8156 entered

    I will have 64 worksheets matching all potential 4 digit site codes that could be entered in the preferences columns

    SAMPLE - one staff member entering 5 site codes (A1 to A6)

    Billy Bloggs - 8124 - 8456 - 8456 - 8123 - 8882

    What I am looking for is a way to autocopy the persons name to the appropriate worksheet and into the correct preference column as I enter the 4 digit code against the staff members name on the master sheet.

    Sorry if this sounds a bit confused but so am I.
    Attached Files Attached Files
    Last edited by Exxon97; 06-27-2009 at 05:33 AM.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Auto copying entered Preferences from a Master sheet to multiple worksheets

    Maybe like this:
    Please Login or Register  to view this content.
    Code goes in the MASTER sheet module.

    Adding Code to a Sheet module
    1. Copy the code from the post
    2. Right-click on the tab for the relevant sheet and select View Code. This opens the Visual Basic Editor (VBE) and shows the object module for the selected worksheet.
    3. Paste the code in the window
    4. Close the VBE to return to Excel
    Last edited by shg; 06-26-2009 at 06:18 PM.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    06-26-2009
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Auto copying entered Preferences from a Master sheet to multiple worksheets

    Perfect
    Works just the way I need it!
    Many thanks

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Auto copying entered Preferences from a Master sheet to multiple worksheets

    You're welcome. Would you please mark the thread as Solved?

  5. #5
    Registered User
    Join Date
    05-31-2012
    Location
    TX
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: Auto copying entered Preferences from a Master sheet to multiple worksheets

    I copied and paste the script into my workbook to see if it would work. I had no luck. How can I ensure the aformentioned script applies to my own workbook?

  6. #6
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Auto copying entered Preferences from a Master sheet to multiple worksheets

    Truerookie,

    Welcome to the Forum, unfortunately:

    Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

Closed Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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