Results 1 to 7 of 7

Need to copy specific cells into an existing worksheet based on date entered by user

Threaded View

jrfleury Need to copy specific cells... 10-12-2011, 09:28 AM
tigeravatar Re: Need to copy specific... 10-12-2011, 10:59 AM
jrfleury Re: Need to copy specific... 10-12-2011, 11:22 AM
tigeravatar Re: Need to copy specific... 10-12-2011, 11:29 AM
jrfleury Re: Need to copy specific... 10-12-2011, 11:43 AM
tigeravatar Re: Need to copy specific... 10-12-2011, 12:34 PM
jrfleury Re: Need to copy specific... 10-17-2011, 09:44 AM
  1. #1
    Registered User
    Join Date
    09-30-2011
    Location
    canada
    MS-Off Ver
    Excel 2003
    Posts
    9

    Need to copy specific cells into an existing worksheet based on date entered by user

    Hi all,
    I am looking to gather data from Sheet (“NSF Log”) and copy it to Sheet (“Journal”) based on the date found in column “B” of Sheet (“NSF Log”). The intent is that using a command button, a message box will appear and the user can enter the date. The system will then look through column B of Sheet (“NSF Log”) to find the date and whenever there is a match, it will copy specific information on the corresponding rows as follows:

    "NSF Log” copy columns “O” to “V” and paste it to “Journal” starting on “C17”.
    “NSF Log” copy column “K” and paste it to “Journal” starting on “K17”.
    “NSF Log” copy column “A” and paste it to “Journal” starting on “M17”.

    Also, before copying the data to Sheet "Journal", I would like the system to erase any existing data from prior searches.

    I have included a copy of the excel spreadsheet with sample data.

    I don't know much about VBA, but any help is greatly appreciated!
    Attached Files Attached Files
    Last edited by jrfleury; 10-17-2011 at 09:47 AM.

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