+ Reply to Thread
Results 1 to 5 of 5

Script to paste certain sets of data to other sheet then delete current row

  1. #1
    Forum Contributor
    Join Date
    07-19-2019
    Location
    Illinois, USA
    MS-Off Ver
    365
    Posts
    164

    Script to paste certain sets of data to other sheet then delete current row

    Current Script that I need to modify:

    Please Login or Register  to view this content.
    The above code will take your selection on the current worksheet and paste it to the bottom row, column "C", in another worksheet. It works great, no problems for me.

    BUT! I want to expand it so that instead of copying the specific selection, it'll evaluate which row you've selected, and copy/paste data, from that row, in the following manner (FROM current sheet -->TO)

    Column M --> Finish!C
    Column D --> Finish!D
    Column E --> Finish!E
    Column F --> Finish!F
    Column G --> Finish!G
    Column H --> Finish!H

    Then, once all of the copy/pasting is complete, I want it to still delete the selected row that you started with.

  2. #2
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Re: Script to paste certain sets of data to other sheet then delete current row

    Here is a really good example. Just change it to your needs: https://stackoverflow.com/questions/...w-into-a-row-o
    Click the * to say thanks.

  3. #3
    Forum Contributor
    Join Date
    07-19-2019
    Location
    Illinois, USA
    MS-Off Ver
    365
    Posts
    164
    Please forgive me... I have stared at this and messed with it for 3 days... I cannot figure out how to get it work for my issue

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,080

    Re: Script to paste certain sets of data to other sheet then delete current row

    How about
    Please Login or Register  to view this content.

  5. #5
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,527

    Re: Script to paste certain sets of data to other sheet then delete current row

    Or maybe use something like this for the transferring.
    Please Login or Register  to view this content.

+ 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. VBA Script for looping over copy,paste, filter and delete
    By mvneema in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-18-2014, 02:24 PM
  2. Script to update data in other sheets with data from current sheet
    By SeagullWardy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-19-2014, 12:00 PM
  3. Replies: 2
    Last Post: 06-21-2013, 12:26 PM
  4. VBA script problem - Copy and Paste Special data from one sheet to another.
    By akarev in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-05-2013, 12:19 PM
  5. [SOLVED] VBA to paste 2 sets of formatted data into one sheet
    By kenadams378 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-11-2012, 06:40 AM
  6. Delete current record from data list on separate sheet?
    By SueJB in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-28-2012, 09:37 PM
  7. Copy two data sets, filter it and paste to summary sheet
    By pauldaddyadams in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-03-2012, 07:15 AM
  8. delete column sets current cell wrong
    By davegb in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-08-2006, 04:10 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