+ Reply to Thread
Results 1 to 3 of 3

Complicated Accounting

  1. #1
    Registered User
    Join Date
    03-23-2022
    Location
    boston, usa
    MS-Off Ver
    2013
    Posts
    3

    Complicated Accounting

    Hello !
    Been kind of stuck on this project and I would just like to see more recommendations / ways of thought. If someone can maybe help with the needed functions (explaining what functions to use or macros to build) that would be awesome
    So these are the steps I need to get done...
    1) Make Excel open a new sheet each month (done)
    Now these I need help with....and im stuck af.
    2) This worksheet now needs to automatically import data from a specific new LOCAL file each month(the file name template stays the same, only month and year change. For example abcd_3_2022, next month would be abcd_4_2022) (generated on the first day of the month, before the new worksheet) - This data is specific - each column has a bit of words and the amount of rows changes - For example:
    Screenshot 2022-03-23 213939.jpg
    Screenshot 2022-03-23 214016.jpg


    im completely lost on the actions i need to do. help please

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, Suffolk (England), but grew up in Sawley, Derbyshire
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2211 (Windows 11 22H2 64-bit)
    Posts
    65,438

    Re: Complicated Accounting

    I would look at PowerQuery (Get & Transform on the Data ribbon).
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

  3. #3
    Registered User
    Join Date
    03-23-2022
    Location
    boston, usa
    MS-Off Ver
    2013
    Posts
    3

    Re: Complicated Accounting

    thank you !

+ 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] Accounting issue
    By Miroslavjp in forum Excel General
    Replies: 3
    Last Post: 07-26-2017, 02:33 AM
  2. How to load value from cell in accounting format and save in accounting format back
    By lazyserv in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-27-2015, 01:21 PM
  3. [SOLVED] Accounting i guess
    By Duggie06 in forum Excel General
    Replies: 10
    Last Post: 04-17-2012, 12:40 PM
  4. accounting
    By Abuali in forum Access Programming / VBA / Macros
    Replies: 1
    Last Post: 05-24-2010, 11:16 AM
  5. *Accounting system*
    By ben1991 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-15-2007, 02:28 AM
  6. complicated accounting formula
    By achinfish in forum Excel General
    Replies: 1
    Last Post: 09-18-2007, 04:08 PM
  7. Accounting
    By Offedoruife in forum Excel General
    Replies: 1
    Last Post: 06-24-2007, 05:32 AM

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