Results 1 to 3 of 3

Mock Workbook, Multiple data transfer

Threaded View

  1. #1
    Registered User
    Join Date
    05-11-2017
    Location
    Irvine, CA
    MS-Off Ver
    2007
    Posts
    10

    Mock Workbook, Multiple data transfer

    So here's my conundrum,
    I have project that has spiraled out of control, for a family member by the way, went from simple data transfer which I was able to understand to pulling multiple parts from 1 worksheet to another and adding additional rows with set data.
    My project has only 1 workbook with 2 worksheets, But I will upload 2 workbooks, one for code and the other as a visual on how they want it completed. I have tried some code, was assisted from someone else here as well but now I have additional info that needs added.
    Thank you everyone for your help.

    Below is how they are looking to have it done: Information from "data" sheet to transfer to "template" sheet

    Part1 - Payments section in "data" sheet
    The information from the payments section needs to be pulled and placed into the "template" sheet starting in A12 then filling up box. Also adding a couple of things as well. But if there is no information from the "assignee" or "inflation" column, then skip
    Example:
    Paycode | Annual Amount | Currency | Pay Code Type | Projection growth rate (this is from the template tab)
    Payment 50,000 US F 3.5% (this is from the data tab)

    Part2 - Allowances
    This follows the information from part one in the same location but adds more code. If the Premium has a "dependent", then there needs to add that information just below the premium assignee information that includes the same name but adds the dependent amount instead. But if there is no information in dependent, continue to next row
    Example:
    Paycode | Annual Amount | Currency | Pay Code Type | Projection growth rate (this is from the template tab)
    Premium4 5,000 US A 3.5% (this is from the data tab)
    Premium4 10,000 US A 3.5% (this is from the data tab)

    Part 3 - First and return year
    This follows the information from part2 in the same location but adds even more code. If the Benefit has a "dependent" on FIRST YEAR, then there needs to add that information just below benefit assignee information that includes the same name but adds the dependent amount instead. If the Benefit does not have a "dependent" on FIRST YEAR, then continue to LAST YEAR adding below current Benefit putting same Benefit name and same result that if the Benefit has a "dependent" on LAST YEAR, then there needs to add that information just below benefit assignee information that includes the same name but adds the dependent amount instead.
    Example:
    Paycode | Annual Amount | Currency | Pay Code Type | Projection growth rate (this is from the template tab)
    Benefit7 5,607 US A BLANK (this is from the data tab)
    Benefit7 5,000 US A BLANK (this is from the data tab)
    Benefit7 6,056 US A BLANK (this is from the data tab)
    Benefit7 6,000 US A BLANK (this is from the data tab)

    The locations of each row and column are in exact order that they will be in on the live project if this helps. Thank You
    "MockWB1" is for coding and "MockWB2" is how my family member was trying to have it look
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Transfer data from multiple workbooks to a single sheet in another workbook.
    By mike rand in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-01-2017, 02:54 PM
  2. Replies: 0
    Last Post: 02-08-2017, 09:42 PM
  3. Transfer data from multiple workbooks to master workbook automatically
    By Scrapnforfun in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-29-2016, 01:15 PM
  4. Transfer data from multiple workbooks into Master workbook in SharePoint
    By faraha91 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-14-2016, 05:58 AM
  5. Multiple Choice Mock Test With History
    By msuhaib in forum Excel General
    Replies: 1
    Last Post: 08-22-2015, 04:40 AM
  6. [SOLVED] How to transfer specific row of data from multiple workbooks to master workbook using VBA
    By rajeshntiwari in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-08-2014, 08:08 AM
  7. Replies: 1
    Last Post: 12-24-2013, 02:00 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