+ Reply to Thread
Results 1 to 1 of 1

Need macro to cut and paste data from one sheet to another

  1. #1
    Registered User
    Join Date
    04-02-2019
    Location
    USA
    MS-Off Ver
    Excel 2013
    Posts
    74

    Need macro to cut and paste data from one sheet to another

    Hello,
    I have two files attached: "'Copy" and "Paste"

    1. Assume the Copy file updates intermittently via macros and the outputs land on the page shown in the "Item 1" row. I need a macro button in the "Paste" file that will grab the updated information from the "Copy" file and paste it into the next blank column, in this case column L (and transposed as shown in previous columns).

    2. As an alternate option I would also like a macro button on the "Paste" file that would simply copy the tab from the "Copy" tab and append to the tabs in the "Paste" file. Once complete, I would like this new tab to automatically be named the number of the next project shown in the next available column, in this case column L, Project 11. The newly added tab would be named, "Project 11".

    Any help is greatly appreciated.
    Attached Files Attached Files

+ 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 will not paste data into sheet
    By rcdavis28 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-31-2018, 02:48 PM
  2. Replies: 6
    Last Post: 11-25-2015, 02:08 AM
  3. How to write macro to find certain data in master sheet and paste into another sheet?
    By travis.cook21 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-16-2015, 09:21 AM
  4. [SOLVED] Macro to copy data from one sheet, paste in another sheet
    By papi-O in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-30-2014, 04:06 AM
  5. [SOLVED] I'm a new user: Need a macro that will auto paste data from one sheet row to another sheet
    By Daotor in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-22-2013, 10:15 AM
  6. Macro to Copy data from one sheet and paste to another sheet based on a condition
    By SaurabhShri1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-20-2013, 09:30 AM
  7. Macro to search the sheet name and copy and paste the data from a major sheet
    By salma2009 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-04-2009, 02:11 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