+ Reply to Thread
Results 1 to 4 of 4

How to cut a row of data and paste it into another when data is entered into a column

  1. #1
    Registered User
    Join Date
    09-29-2015
    Location
    London
    MS-Off Ver
    windows 7
    Posts
    2

    How to cut a row of data and paste it into another when data is entered into a column

    So i'm looking to make a task list with date set, date due and date completed as column options. I would love it so when I enter the completed date, the whole row is cut from sheet 1 and pasted into sheet 2. After some research I think I'm going to need to use VBA but I am struggling with this. If anyone can help or has advice for me I would be really grateful!
    Many Thanks!!

    Ps I am using excel 2010 if thats important

  2. #2
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: How to cut a row of data and paste it into another when data is entered into a column

    Hi owen.harries

    Welcome to the Forum!!!

    I think you'll be looking at Worksheet Change Event Code for this.

    If you will attach a File with sample Data that's of the same structure as your actual file I'll look at it with you.
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  3. #3
    Registered User
    Join Date
    09-29-2015
    Location
    London
    MS-Off Ver
    windows 7
    Posts
    2

    Re: How to cut a row of data and paste it into another when data is entered into a column

    Task Log.xlsm
    Hopefully this attachment has worked!

  4. #4
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: How to cut a row of data and paste it into another when data is entered into a column

    Hi owen.harries

    Try this Code. Place the Code in the Sheet Module for Current Tasks.
    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. [SOLVED] If data entered in cell, on same row, copy and paste data from other cells to front sheet
    By Christopher135 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-27-2013, 06:34 PM
  2. Copy and paste the most recent entered data from other worksheets to summary sheet
    By cvsrini in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-18-2013, 04:51 AM
  3. Replies: 8
    Last Post: 01-23-2013, 03:36 AM
  4. Replies: 0
    Last Post: 07-02-2012, 05:50 AM
  5. Macro to copy and paste special values for column data and filter column data
    By ascottbag in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-10-2012, 02:15 PM
  6. Replies: 4
    Last Post: 02-28-2012, 11:17 PM
  7. Replies: 11
    Last Post: 07-13-2011, 05:37 PM
  8. Pushing data across column when new data it entered.
    By Kiwi1 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 02-16-2011, 12:39 PM

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