+ Reply to Thread
Results 1 to 4 of 4

Daily Budget File: I'm looking for a non-macro solution (for mobile use)

  1. #1
    Registered User
    Join Date
    03-24-2014
    Location
    Vienna, Austria
    MS-Off Ver
    Excel 2010
    Posts
    72

    Daily Budget File: I'm looking for a non-macro solution (for mobile use)

    Hello. I created a file to track my daily spendings. However it's dependent on a macro and as a consequence I can't use it on my Android phone.

    Quickly explained, you have to enter for each spending:
    - Amount
    - Name of Vendor
    - Choose spending category from an ActiveX dropdown (not working on mobile use)
    - What exactly was bought

    After that I press on a button ("NEUE ZEILE") with a macro underlaid, which basically puts the current date on another cell and then automatically inserts another cell on top.

    The best is probably you just try it out, its quite intuitive.
    >>> Download:
    Budget.xlsm <<<
    My problem however is due to the Dropdown & Macro I can't use it on my mobile phone. However it would be a lot better if I could, as it's a bit annoying to enter all the spendings at the end of the day on my laptop.

    If anybody has an idea how I could handle it, I would be so glad

    Thanks alot!
    Last edited by chrisignm; 05-07-2014 at 05:55 PM.

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Daily Budget File: I'm looking for a non-macro solution (for mobile use)

    I would recommend perhaps using a notepad on your phone to write your expenses in free hand, but in a standard format.

    5.00, Starbucks, Food
    4.00, Chevron, Gas
    137.00, Comfort Inn, Lodging


    Simple as this is, it can be saved as a CSV file and emailed. It's blindingly simple to import CSV files into Excel at the end of the week.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    03-24-2014
    Location
    Vienna, Austria
    MS-Off Ver
    Excel 2010
    Posts
    72

    Re: Daily Budget File: I'm looking for a non-macro solution (for mobile use)

    Thanks, but that's kind of similiar to what I am currently already doing.

    I would really like to solve it immediately in Excel, if possible. I also have a formula dependent on my daily spendings which tells me how much I can still spend during the day. (this can vary due to several factors each day)

    Best regards

  4. #4
    Forum Expert
    Join Date
    06-25-2009
    Location
    Sofia, Bulgaria, EU
    MS-Off Ver
    Excel 2003-2013
    Posts
    1,290

    Re: Daily Budget File: I'm looking for a non-macro solution (for mobile use)

    well, there are number of wonderful free apps in the play store, which will be much more convenient to use, instead of using excel for tracking daily expenses. they offer export, graphs and a bunch of other useful functionality.
    I used this one https://play.google.com/store/apps/d...expensemanager and also tried this one https://play.google.com/store/apps/d...rvice.expenser and this one https://play.google.com/store/apps/d...y.wallets.lite
    Last edited by buran; 05-08-2014 at 04:36 AM.
    If you are pleased with a member's answer then use the Star icon to rate it.

+ 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. Calculate daily targets given: month, monthly budget, daily indexes
    By Chuckyrp in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-06-2013, 03:30 AM
  2. Macro to full in data from Master file to a daily recon file
    By Dnels in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-21-2013, 12:03 PM
  3. Need a better charting solution for daily data
    By masfkb2424 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 04-06-2013, 03:00 PM
  4. Daily Budget Formula Needed
    By sammir in forum Excel General
    Replies: 1
    Last Post: 02-07-2012, 02:30 PM
  5. daily/weekly budget calculation (if cell1 is less than 0 take X from cell2)
    By rhalstead22 in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 01-24-2011, 04:17 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