Accounting Excel Project - transferring figures from raw data sheet (new figures and combinations every month) into a monthly Overheads MM/YY file in order to get away from manual checking and "Edit links" as this process does not pick up new data.
Full Excel task project written up on Word file is attached!!
The below is taken from the full Word file.
The aim of the project:
At the moment, this process is done through “Edit Links” function on the Data tab for the Actual figures which is picking up from the raw Essbase data sheet. But it can only edits links for the GL and Cost Centre lines that I already know about. The current sheet doesn’t know of any new GL/Cost Centre combinations that can come into play in a new month.
The new aim is to create some sort of automated process so every new month in a relevant month’s Overheads MM/YY sheet, I should be able to pick up the numbers from the “Overheads ESSBASE” Raw data file by doing some sort of Drop down list function, Macros/VBA code, etc. so I don’t have to look for new G/L code AND Cost Centre combinations manually.
Tip: You may not need to work with all the columns back on the “Copy of Overheads ESSBASE unsuppressed” sheet because if you look at the SUM of some the cells along Row 27, it comes to ZERO. So maybe hide or delete those columns so you have less columns in the way of the task.
The ultimate aim is to match the total of the figures in the “Copy of Overheads ESSBASE unsuppressed” sheet just against Order number 582Z1MAOVH11 which comes to £2,910,368.69 (total sum of cells E29 to IT1572)
The total of Column X back on the Copy of Overheads Jun-19 sheet (Cell X168) comes to the amount of £2,791,953 and as you can see it is lower than the Unsuppressed sheet total (by £118,415.69) which is where the problem is…. I want to capture everything from the raw sheet into the main monthly Overheads sheet (which I will perform monthly) so that the totals match exactly. It could be as simple as V-Lookup or INDEX/MATCH formula or drop down list button but it could also involve MACROS/VBA Code.
I’m not sure what the best solution is so this is why I need your help.
27 фрилансеров(-а) в среднем готовы выполнить эту работу за £108
Hi. Great app writer for your projects. I have writen excel app, macro, vba for many years. I am ready to write your project. Thank you for visiting my profile