+ Reply to Thread
Results 1 to 3 of 3

Copy cell from one sheet, find coresponding date on 2nd sheet data table, paste value

  1. #1
    Registered User
    Join Date
    02-05-2019
    Location
    Tyler, TX
    MS-Off Ver
    2016
    Posts
    7

    Copy cell from one sheet, find coresponding date on 2nd sheet data table, paste value

    I am extremely new to VBA and am having trouble figuring out how to write code for the following situation. (visual help because I have a hard time explaining it properly).

    I made a sheet to be able to look up a date and have all pertinent information auto populated from my data table. That was the easy part.

    Form.png

    Search.jpg

    I then want to be able to hit the "Paid" button and copy data from one specific place and put it into the proper cell in my data table.

    Copy.jpg

    Paste.jpg

    Problem is I don't even know where to start on this. I have been searching for 2 days and can not find anything that resembles this process. Please help, and remember I am very new to VBA and would appreciate any help I can get. Thank you.

  2. #2
    Registered User
    Join Date
    02-06-2019
    Location
    Bangalore, India
    MS-Off Ver
    MS Office 2013
    Posts
    9

    Re: Copy cell from one sheet, find coresponding date on 2nd sheet data table, paste value

    Attaching a small sample file would make it easier for people like us to work on it and try to find a solution.

    Regards,
    Sarath

  3. #3
    Registered User
    Join Date
    02-05-2019
    Location
    Tyler, TX
    MS-Off Ver
    2016
    Posts
    7

    Re: Copy cell from one sheet, find coresponding date on 2nd sheet data table, paste value

    Sarath,
    Thank you for letting me know. I really appreciate you taking the time to look at my thread and help me.

    I have attached a full copy of the file I have. It's not pretty but it's what I have come up with. I'm open for any critisism and help. I have deleted all personal information for privacy but I'm sure anyone can figure out pretty quickly how everything is working.

    Thank you again for your help.
    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. [SOLVED] Copy paste data one to multiple sheet based on cell value to sheet name
    By kannan1847 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-15-2015, 12:54 AM
  2. [SOLVED] VBA to find data in Sheet 2 copy and paste back in Sheet 1
    By shiva_reshs in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-10-2014, 09:39 PM
  3. [SOLVED] Find Value of First sheet in another and copy related data for that cell value and paste.
    By deepak.sirsale in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-30-2013, 09:26 AM
  4. Replies: 0
    Last Post: 05-21-2013, 03:09 PM
  5. [SOLVED] Find the date and copy the values from the colum of the date find and paste to other sheet
    By nizzcmzph in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-20-2013, 10:03 AM
  6. Find Adjacent Data In One Sheet and Copy/Paste Into Other Sheet
    By jaylotheman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-06-2011, 07:19 PM
  7. Find value from sheet 1, cell A1 in sheet(s) 2 (3, 4?), copy, paste row to sheet 8
    By fleeting in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-27-2011, 03:31 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