+ Reply to Thread
Results 1 to 4 of 4

Transfer data from a "template" into a tracking log

  1. #1
    Registered User
    Join Date
    09-19-2015
    Location
    Arizona
    MS-Off Ver
    2010
    Posts
    5

    Transfer data from a "template" into a tracking log

    I have a template that a customer service rep fills out for each order. When a new order comes in, the original data is just deleted and the new order info is filled out. However, each order is tracked on a log. I need to figure out a way to transfer the data from the template into the next available row on the tracking sheet.

    On the template, I have all filled out cells pulling into one single row and named the range Input - hoping it makes it easier.

    If anyone could give a look, I would appreciate it.

    File attached.

    Thanks for any help.

    Zak
    Attached Files Attached Files

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Transfer data from a "template" into a tracking log

    The way I'd do it is with a macro that's attached to an 'Update Log' button on the face of the form.
    e.g.

    Please Login or Register  to view this content.
    I'd also think about extending the macro so that the entries in the form are cleared after the log sheet has been updated.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,908

    Re: Transfer data from a "template" into a tracking log

    No need to use Copy and PasteSpecial.
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    09-19-2015
    Location
    Arizona
    MS-Off Ver
    2010
    Posts
    5

    Re: Transfer data from a "template" into a tracking log

    Worked perfectly. Thank you for taking the team to help! Much appreciated.

+ 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. Need help transferring data from a "template" into a tracking log
    By The Zak in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-20-2015, 06:09 PM
  2. Can my textbox transfer the "Required" data, without the formula to a cell?
    By gmr4evr1 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-07-2015, 03:59 PM
  3. Trying to transfer to worksheet in Cell "A1" vice "A2"
    By gunsmith01 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-03-2014, 07:41 AM
  4. Replies: 1
    Last Post: 05-23-2013, 02:04 PM
  5. Automatically transfer "IV" data to sheet 2
    By jawaune in forum Excel General
    Replies: 5
    Last Post: 06-16-2009, 08:41 PM
  6. Replies: 2
    Last Post: 06-26-2006, 05:35 PM
  7. [SOLVED] Guides "Template" - in Danish "Guiden Skabelon"
    By DasLederlap in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-15-2006, 07:10 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