+ Reply to Thread
Results 1 to 2 of 2

Create and Auto-Populate One Multi-Row Worksheet Using Three Worksheets As Inputs

  1. #1
    Registered User
    Join Date
    08-14-2013
    Location
    NC
    MS-Off Ver
    Excel 2007
    Posts
    1

    Post Create and Auto-Populate One Multi-Row Worksheet Using Three Worksheets As Inputs

    It’s been about 20 years since retiring. Prior to that I programmed different flavors of Cobol, Clist, Assembler, Focus, dBase (I-III) and several dialects of Basic (Quick, Extended, TI-Basic, etc.), but I must say Visual Basic (VBA) is a new and confusing “animal” to and for me. Maybe it’s because I’ve aged a bit . With the previous in mind, here are my challenges:
    1. I have already built an Inventory Workbook currently consisting of 4-tabs
    a. Warehousing Keeps a running list of what I have on-hand
    b. OrderBy Keeps a running list of who actually orders my product(s)
    c. Ordering Keeps a running list of who my customers are, what they purchase, etc.
    d. Pick-Pack-Fields is created from certain fields within each of the above worksheets so that a Word 2007 mail merge can be used to create print shipping labels for the ordered product on any given day.
    2. So I’d like to be able to…
    a. Automatically create a new Pick-Pack-Fields (shipping label) worksheet .xlsx external file by automatically populating fields, row-by-row in the shipping label worksheet populated from one Inventory Workbook made up of: the Warehousing, OrderedBy and Ordering worksheets.
    b. Automatically create each shipping label .xlsx file with a unique identifier such as:
    Pick-Pack-Fields(yymmdd) – e.g. Pick-Pack-Fields(130814) while the next day’s output file would be Pick-Pack-Fields(130815), and so on…
    c. Automatically run the Word 2007 Mail Merge from within Excel 2007 using the shipping form I’ve already created in Word and using only the Pick-Pack-Fields(yymmdd) file I choose to run, to prevent redundant shipping label prints, wasted time, toner and paper.
    Since c.8/1/2013, I have tried several techniques no avail. Only manual intervention works for creation of the Pick-Pack-Fields (shipping labels) in Excel 2007 to be passed to the Word 2007 mail merge process. The mail merge using the Pick-Pack-Fields works fine. It’s just tedium ad infinitum.
    Kindly help my understanding!
    ---Thanking You In Advance For You and Your Assistance, EWBJ
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    03-22-2013
    Location
    Australia,NSW, Wirrimbi
    MS-Off Ver
    Excel 2013
    Posts
    1,057

    Re: Create and Auto-Populate One Multi-Row Worksheet Using Three Worksheets As Inputs

    Hi..

    Points a) and B) seem pretty straight forward..

    For point c).. Other than Mail Merge.. you could use the "BookMark" method or the "Word Form Fields" methods to populate your Word doc from Excel..

    Can you upload your Word doc(shipping form) please..

+ 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. Replies: 2
    Last Post: 05-06-2013, 08:53 AM
  2. Replies: 3
    Last Post: 06-12-2012, 09:08 AM
  3. Vba to Create copy of worksheet and range of cells to used to calculate inputs.
    By Wyliecody in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-22-2012, 04:48 AM
  4. Multi Sheet formula auto-populate?
    By healimonster in forum Excel General
    Replies: 5
    Last Post: 05-17-2010, 05:58 PM
  5. auto populate within multiple worksheets
    By r3b3ckah in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-02-2009, 12:52 AM

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