+ Reply to Thread
Results 1 to 32 of 32

Sum Data Based on a GL Code and Month in Year

Hybrid View

  1. #1
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365
    Posts
    3,187

    Re: Sum Data Based on a GL Code and Month in Year

    oeldere - thank you for the compliment! I appreciate it, I agree that it's not the ideal solution, that was also what I wrote when I uploaded the file, and said it was a little primitive, as I gave an IF formula for each 12 scenarios (1 for each month). That's the only way I found to accomplish that without having a PIVOTABLE in action.
    since I'm familiar with the trial balance report - I assume that the structure of the report is quite solid, columns will always remain Jan-Dec, and lines are not expected to change massively, only the values are varying each period - so I guess no great changes are needed to be done.

    Thanks again, great honor hearing that from an expert user
    Last edited by Limor_OP; 04-28-2020 at 04:39 AM.

+ 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. Month and Year in footer based on cell data
    By ERI GURU in forum Excel General
    Replies: 1
    Last Post: 03-06-2015, 02:10 PM
  2. Extract data based on month/year to a simple table.
    By maax555 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-15-2014, 09:55 AM
  3. [SOLVED] Copying data based on current month of the year
    By D.Lovell in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-22-2014, 06:33 PM
  4. Change year but keep the month the same based on current year
    By Jamon Fries in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-11-2014, 05:29 PM
  5. [SOLVED] Making data static based upon Month of Calendar Year
    By rishinag in forum Excel General
    Replies: 1
    Last Post: 04-01-2013, 03:17 AM
  6. Retrieving data from two pivot tables based on date (grouped by month and year)
    By TheCyrusVirus in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-05-2010, 04:37 AM
  7. Get Data based on Month and Year
    By karstens in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-01-2006, 07:50 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