Results 1 to 2 of 2

a sheet to 'push' data to other sheets

Threaded View

  1. #1
    Registered User
    Join Date
    05-24-2012
    Location
    Phoenix, Arizona
    MS-Off Ver
    2010
    Posts
    17

    a sheet to 'push' data to other sheets

    Family monthly budget1.xlsm

    Attached is the file associated with this thread.
    I am new to VBA and therefore more or less illiterate. I need a code written that will allow me to enter information into this budget spreadsheet. The sheet name to enter information is called ‘push’. The information on that sheet corresponds with cells on the remaining monthly sheets.
    What we need to have is for us to be able to enter currency into cells on the ‘push’ sheet and have it correspond with the cells on the correct month’s sheet. Cell E5 will be used to enter the correct sheet. A button needs to be placed on the ‘push’ sheet in cell A5 to activate the code. All currency added to ‘push’ sheet will need to return to ‘0’ when the button is activated.
    On the corresponding sheet, the information needs to be entered into the cells in the ‘actual cost’ columns and add. Every time currency is ‘pushed’ it will need to add to the currency already in the monthly sheet. This way we won’t have to add the numbers one by one when entering information.
    I hope this is enough information. As I mentioned, I am just beginning to learn VBA and will need specific instructions as to how to proceed.
    Thanks in advance!
    Last edited by brownie4321; 05-25-2012 at 02:11 AM. Reason: Changed title

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