+ Reply to Thread
Results 1 to 1 of 1

Match info in file and copy into template

  1. #1
    Forum Contributor
    Join Date
    09-25-2011
    Location
    Lenasia, Johannesburg,South Africa
    MS-Off Ver
    Excel 2019
    Posts
    269

    Match info in file and copy into template

    Greetings

    I have a file that I need to be able to copy data matching race and number and copy all data from there into the template

    in the file kenilworth -wcp match Race-1 in col A1
    need to copy all the data from col a to e ... end of row to the template racedata
    paste under Race-1


    therafter it must match Rcae-2 and copy all data into the template under Race-2

    and continue
    Currently I am cutting and pasting the data

    Also before writing to the template called racedata , it must clear the the data after each identifier eg Race-1 . race-2 etc

    Trust this will help

    Thank you for all help received

    Regards

    Rajann
    Attached Files Attached Files
    Last edited by khanaran; 05-20-2019 at 10:43 AM. Reason: add info

+ 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. [SOLVED] VBA to copy data to a template file then save it as a new file.
    By Efjoker in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-20-2019, 12:10 PM
  2. Copy data from Excel 07 and paste it into an Outlook 07 email template
    By manieldunk in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-26-2018, 05:21 PM
  3. Copy a range of data and paste to multiple sheets using "User" as key identifier
    By cmicmac in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-01-2015, 09:59 AM
  4. Replies: 11
    Last Post: 05-12-2013, 11:30 AM
  5. Charting file template to clear old data, paste new data and update chart
    By cwilliams321 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-29-2012, 04:13 PM
  6. Copy and paste data from a worksheet to template, save it with a name and location.
    By sumplacenwa in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-28-2012, 12:47 AM
  7. Replies: 1
    Last Post: 04-07-2011, 01:21 AM

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