+ Reply to Thread
Results 1 to 5 of 5

Copy/paste row to another sheet based on value in column

  1. #1
    Forum Contributor
    Join Date
    12-27-2007
    Posts
    106

    Copy/paste row to another sheet based on value in column

    Hi

    I've two sheets: "present" and "removed"

    I would like to have a whole row copied and deleted and existing rows moved up in "present" when I type the word "yes" in column E.

    The deleted rows are to be pasted into "removed", with two extra pieces of data - date removed and name of person removing it - to be asked in pop up boxes and inserted into col F and G respectively in "removed".

    Spreadsheet attached

    Thanks in advance
    Attached Files Attached Files
    Last edited by tony0710; 03-19-2009 at 06:04 AM. Reason: solved

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Copy/paste row to another sheet based on value in column

    Please Login or Register  to view this content.
    Put this macro on a button in the first row of the PRESENT sheet. Click it anytime you want to transfer.
    Last edited by JBeaucaire; 03-17-2009 at 12:03 AM. Reason: Fixed USER Input test
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Forum Contributor
    Join Date
    12-27-2007
    Posts
    106

    Re: Copy/paste row to another sheet based on value in column

    Sorry, I got busy and side-tracked - the code worked a treat, but rather than pressing the button as suggested - is there anyway of doing this as soon as "yes" is typed into col E - automatically?

  4. #4
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Copy/paste row to another sheet based on value in column

    There is, by using a Worksheet_Change event, but I would find that hard to work with. It becomes a frustration to disable macros and manually unhide a row if a mistake is ever made.

    You sure you want to do it that way? What about the user name?

  5. #5
    Forum Contributor
    Join Date
    12-27-2007
    Posts
    106

    Re: Copy/paste row to another sheet based on value in column

    Hi

    I've got an idea from some of the other work I done and advice I got from the forum - let me try this weekend to put something together and IF it doesn't work - then I'll post the question again.

    But in the meantime - I'm marking this as "solved" as you have given me enough to work with - so thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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