+ Reply to Thread
Results 1 to 3 of 3

Copy cell based on Date (Similar like Bank statement), how to do it? VBA code here

  1. #1
    Registered User
    Join Date
    11-12-2015
    Location
    Surabaya, Indonesia
    MS-Off Ver
    MS 365 (Windows 11 64-bit)
    Posts
    84

    Copy cell based on Date (Similar like Bank statement), how to do it? VBA code here

    Hi All,

    Happy Easter.

    I need some help here, on how to write VBA code to input data, like a bank statement did.

    here's the form that need user to input the name, date, amount debit or credit (could be both), and notes in it. This form will be in sheet "Input Form"
    Form.JPG

    and here's the recorded table, in a sheet "Statement"
    Table.JPG

    the idea is to copy/input the amount in each respective column, based on the date in the form.

    thanks a lot for the help
    warm regards,

    Adrian

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,612

    Re: Copy cell based on Date (Similar like Bank statement), how to do it? VBA code here

    Want to get your question answered quickly?
    • Ensure your question is not too vague. Don't assume anyone is familiar with your problem. While you can upload small attachments, describe your problem in the body of the post. We are fortunate to have several Excel gurus, but few mind-readers.
    • On the other hand, skip irrelevant details. Be descriptive and concise. Short, direct, and to-the-point questions with apt thread titles are almost always answered promptly.
    • Keep the scope reasonably narrow. Questions like, "How do I set up an accounting system in Excel?" might be a long time waiting.
    • Explain what you've already tried. ("Calculation is set to automatic, but formulas still don't compute") so helpers don't waste your time or theirs.
    • Post a WORKBOOK. Nobody wants to type data from a picture or paste text from your post into a spreadsheet as a prelude to helping. To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
    • If your question has not been answered within a day, consider adding another post with any additional information you believe is relevant. If you think your post is good as is, just reply to your own thread with the words "Bump no response", which will bring it to the top of the forum.
    Go to the Commercial Services section of this site http://www.excelforum.com/commercial-services/
    And read the FAQ on how to solicit paid help.
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    11-12-2015
    Location
    Surabaya, Indonesia
    MS-Off Ver
    MS 365 (Windows 11 64-bit)
    Posts
    84

    Re: Copy cell based on Date (Similar like Bank statement), how to do it? VBA code here

    Whooops

    Just found the solution,

    Sheets("Statement").Range("A" & Rows.Count).End(xlUp).Offset(1).PasteSpecial xlPasteValues


    sorry to post this... my brain still freeze after Long weekend

    thanks a lot for reading
    warm regards

    Adrian

+ 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. Replies: 6
    Last Post: 07-11-2017, 11:48 PM
  2. Replies: 1
    Last Post: 02-28-2016, 05:54 AM
  3. Replies: 2
    Last Post: 05-06-2015, 02:44 AM
  4. VBA code needed deserately for similar cells but do not know how to copy code!
    By Gunner_gav in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-19-2013, 03:39 AM
  5. Can't copy bank statement
    By grandpa2390 in forum Excel General
    Replies: 3
    Last Post: 10-12-2013, 08:34 PM
  6. [SOLVED] Sum values if text is found in string of cell from downloaded bank statement
    By riveras in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-06-2013, 12:47 PM
  7. [SOLVED] Excel 2007 : Find bank balance in bank statement
    By Baldev Kumar in forum Excel General
    Replies: 5
    Last Post: 07-05-2012, 02:58 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