+ Reply to Thread
Results 1 to 2 of 2

Macro that pastes a template from another tab

  1. #1
    Forum Contributor
    Join Date
    02-18-2020
    Location
    Ottawa, ON
    MS-Off Ver
    Professional Plus 2010
    Posts
    122

    Question Macro that pastes a template from another tab

    Hi there,

    I have been creating a worksheet for personal use that will track my project management duties much better than paper can. I have a row of information followed by a huge checklist for each project I am working on. Every time I have a new project, I need to enter all of this data again, so I created a separate sheet that includes a template that I can easily copy and paste under my current project row. My issue is this:

    I have tried to create a macro that goes into the template sheet, copies the cells, goes back to the project management sheet and pastes the template under my current work. The problem is that the macros always does exactly as I did, instead of ALWAYS pasting it one row beneath my current project, it will paste it in the exact spot every time, which will erase my data after I've input another row already.

    I hope I have explained this well enough. How can I create a conditional macro to always paste the template BELOW my already input work? MY file is attached so I hope that helps.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,942

    Re: Macro that pastes a template from another tab

    Please Login or Register  to view this content.
    Bernie Deitrick
    Excel MVP 2000-2010

+ 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. Macro that copy and pastes last used row under last used row
    By paytoplay in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-02-2017, 03:13 PM
  2. Error with macro which creates new workbook and pastes a template in
    By cheethamz17 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-23-2016, 03:07 AM
  3. [SOLVED] macro looks for blank row then pastes the row below it
    By munroa1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-16-2014, 05:56 PM
  4. Replies: 1
    Last Post: 10-03-2012, 07:06 PM
  5. Replies: 2
    Last Post: 09-05-2012, 03:20 PM
  6. [SOLVED] Automating a macro that copies and pastes data and pastes 2 rows under the previous one.
    By thebank in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-30-2012, 05:02 PM
  7. I have a script in where it copies a sheet's data, and pastes it, but over pastes...
    By Cyberpawz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-24-2012, 02:20 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