+ Reply to Thread
Results 1 to 3 of 3

Code to move data from an entry table to a historical table by date.

  1. #1
    Registered User
    Join Date
    08-21-2013
    Location
    NE
    MS-Off Ver
    2013
    Posts
    42

    Code to move data from an entry table to a historical table by date.

    In the attachment you will see an example of what I am trying to accomplish. What I am trying to do is find VBA code that is either specific to this worksheet or in a macro. When the sheet is opened I enter a date in B2. I then enter data into A7, B7, and C7. What I would like to happen is when the data is entered into A7, B7, and C7 the sheet goes and finds the same date that I entered in B2 and copies that data from A7, B7, and C7 into F7, G7, and H7.


    Thank you and any help given is greatly appreciated.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    02-22-2013
    Location
    London, United Kingdom
    MS-Off Ver
    Office 365
    Posts
    1,217

    Re: Code to move data from an entry table to a historical table by date.

    Hi rlh, try this for the sheet module (see attached):

    Please Login or Register  to view this content.
    Cheers,
    berlan
    Attached Files Attached Files
    Last edited by berlan; 03-14-2014 at 06:09 PM. Reason: added functionality

  3. #3
    Registered User
    Join Date
    08-21-2013
    Location
    NE
    MS-Off Ver
    2013
    Posts
    42

    Re: Code to move data from an entry table to a historical table by date.

    Berlan,

    Thank you very much for your help. This is a perfect solution to my problem. You have saved me a ton of time.

+ 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. Normalizing historical data with a pivot table parse
    By portsample in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 03-06-2020, 01:59 AM
  2. Help creating vba function to move data from table to table on if condtion
    By damaple in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-09-2013, 05:42 AM
  3. Replies: 2
    Last Post: 10-08-2012, 03:47 PM
  4. Date capture in Entry Form to Data Table
    By JIBG in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-02-2007, 09:14 PM
  5. Pivot Table VBA code to move a row
    By uclawarren in forum Excel General
    Replies: 0
    Last Post: 10-10-2005, 03:49 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