+ Reply to Thread
Results 1 to 2 of 2

copy and paste rows based on date entered in userform textbox

  1. #1
    Forum Contributor
    Join Date
    06-27-2014
    Location
    bristol, england
    MS-Off Ver
    excel 2007
    Posts
    264

    copy and paste rows based on date entered in userform textbox

    Hi all I have a userform with a text box for users to enter a date, what I am looking to do is, in sheet1 column A contains dates, and I would like a macro to check column A for dates that match what date the user has entered, and then to copy and paste all the rows of data that match ,to sheet2, just to add the date column is column a but there is also data through to column X ( all needs to be copied,
    i.e if the user entered 25/02/2020 in the textbox, then any records in sheet1 with that date, the rows would be copied.

    Hope this is clear

    scouse13

  2. #2
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,304

    Re: copy and paste rows based on date entered in userform textbox

    Some thing like this
    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. R Click paste/copy in an textbox userform
    By IceSnakeR in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-04-2018, 07:54 AM
  2. Copy Paste value of UserForm TextBox to another Cell in a different sheet
    By Archrael0327 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-10-2016, 06:59 AM
  3. Copy & Paste rows based on Date Range
    By batchy in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-05-2015, 02:58 PM
  4. copy paste data from a userform textbox to worksheet
    By jalmeida87 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-14-2015, 10:51 AM
  5. Macro to copy rows based on moving date and paste the rows into an identical sheet
    By ivandc1234 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-28-2014, 11:59 AM
  6. copy n paste rows based on the specified date range
    By kmahesh in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-10-2012, 02:21 AM
  7. Copy/Paste from worksheet to textbox in userform
    By jarrods in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-06-2009, 05:52 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