+ Reply to Thread
Results 1 to 11 of 11

Creating location specific order sheets from master record

  1. #1
    Registered User
    Join Date
    01-06-2012
    Location
    MN
    MS-Off Ver
    Excel 2013
    Posts
    62

    Creating location specific order sheets from master record

    Does anyone know how I can use a master order sheet to create individual location order sheets? I've created a rough example without any code. In the example, the user would put X's in master tab columns j, k and l to indicate which locations carry certain items. I'd like the program to use the master information to create individual tabs by location, adding the location name to the tab name and order sheet if possible. Any ideas or suggestions would be greatly appreciated. I've needed som3ething like this for some time, have never made the effort to learn how. I can create simple macro's and copy others code, mMy thanks for any and all help.
    Attached Files Attached Files

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Creating location specific order sheets from master record

    This example will work for sheet columns going from J:Z. You can expand that if needed. It will create sheets if needed, update existing sheets.
    Please Login or Register  to view this content.
    Attached Files Attached Files
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    01-06-2012
    Location
    MN
    MS-Off Ver
    Excel 2013
    Posts
    62

    Re: Creating location specific order sheets from master record

    Thanks JBeaucaire! How can we set it such that the only items shown on the individual order sheets correspond with the X's from the Master tab columns j, k, and l? In other words, only show the item information for the items that contain and X?

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Creating location specific order sheets from master record

    tommypkoch,

    Is this how you want?

    Please Login or Register  to view this content.
    Attached Files Attached Files

  5. #5
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Creating location specific order sheets from master record

    You tried it?
    When I run the macro from post #2 it does that exact thing.

  6. #6
    Registered User
    Join Date
    01-06-2012
    Location
    MN
    MS-Off Ver
    Excel 2013
    Posts
    62

    Re: Creating location specific order sheets from master record

    Yes, I just got the chance to try it and it works. Thanks so much for your help!


  7. #7
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Creating location specific order sheets from master record

    As it appears you've reached a conclusion, I've marked this thread SOLVED for you.
    FYI, this is done through the Thread Tools located above the first post in this thread. Thanks.

  8. #8
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Creating location specific order sheets from master record

    tommypkoch

    You are welcome and thanks for the rep.

  9. #9
    Registered User
    Join Date
    01-06-2012
    Location
    MN
    MS-Off Ver
    Excel 2013
    Posts
    62

    Re: Creating location specific order sheets from master record

    One more question - how hard would it be to lock (protect) the item number and item description on the individual tabs (leaving them open or unprotected on the master)? I have given it a try and failed thus far. Thanks - Tom

  10. #10
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Creating location specific order sheets from master record

    Unlock the cells E16:F10000 on the Master.

    This tweaked macro will then relock them on the child sheets.
    Please Login or Register  to view this content.

  11. #11
    Registered User
    Join Date
    01-06-2012
    Location
    MN
    MS-Off Ver
    Excel 2013
    Posts
    62

    Re: Creating location specific order sheets from master record

    Thanks for the fast reply, I will get a chance to give this a try over the weekend. I really appreciate all your help.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Find value on two sheets and copy in correct order on master list
    By danfullwood in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-05-2015, 08:19 PM
  2. [SOLVED] Match criteria between sheets and copy cell values to existing record in master sheet
    By Hirad001 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-05-2015, 04:28 PM
  3. Creating other Sheets from a Master Sheet
    By papereditnow in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-16-2013, 01:35 PM
  4. creating a master sheet from different .csv sheets
    By pani_hcu in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-24-2012, 02:26 PM
  5. Creating sequential numbers & save to specific file location
    By ajaaay in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-22-2012, 06:19 PM
  6. Creating new sheets from master list with VBA
    By philjoel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-01-2007, 12:23 PM

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