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 freelance font une offre moyenne de £108 pour ce travail
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl Plus
Hi, I am an Excel expert. Please refer my portfolio for Excel projects here: https://www.freelancer.com/u/best4best?w=f I am good with using INDEX/MATCH/VLOOKUP functions and macro to match the data. I believe I can Plus
Hi, You won’t make the right candidate selection without knowing what your project on transferring data from raw data sheet to monthly overhead files for the purpose of automation will look like. Fortunately, I can sho Plus
Hello there, I am an Excel expert with over 300+ project 5* in excel VBA. I read your docx and you do not attach the file so I can not see it but I can do it for you. Base on your document, I think with my Finance ex Plus
Hi, My name is Virendra. An Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of creating User Form, Command Button, Drop Down, Radio Plus
Hi Your Excel Specialist here. Graduated recently from California, USA; I have been doing numerous marketing and research projects. I feel I will be comfortable to work with you and perform tasks as per the quality Plus
I am experienced in excel, data entry, ms office, PPT, data entry and ensure that tasks are done efficiently and effectively. I want to use my skills in ensuring that this problem is resolved. Relevant Skills and Expe Plus
Dear Sir or Madam, I am South African based Accountant with more than 20 years of experience in Excel. I am comfortable with the use of Charts, PivotTables, converting documents from PDF etc. Can you possibly provide Plus
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
You do have a task at hand, I do have skills in data processing, entry, accounting, excel and analysis that drew my attention to your project. I am more than ready to help you with the task at hand. Thanks as I look Plus
I'm new data entry freelancer but I've 19 years experience in dealing with MS Office and web searching, I can provide free sample and I've the ability to get job done at time , willing to cooperate with you Shaimaa Al Plus
Hello, have a lot of relevant experience, looking forward to work with you. Expert in: ☆ VBA ☆ (Excel, access) ☆ C# ☆ SQL ☆ Google script ☆ Python Quality and problem oriented solutions guaranteed. Experienced with d Plus
Hello Dear !!! I have gone threw your project description . After understanding all things and situation i can help you easily because I am currently working as Business analyst in MNC company. My work is to maintain Plus
Hello I have gone through your project description. I will fulfill your requirements according to your project. I am a very good and helpful assistant, very fluent in languages and especially available all the time. I Plus
industrial Engineer with 7 years of experience in Project Management/ Reporting for major Oil&Gas Projects. Advanced skills in Excel, VBA, Spreadsheet and Complex Excel Design, Dashboards, Big Data etc. Experien Plus
I'm a public accountant and data scientist with experience in recommendation systems, deep learning and machine learning algorithms.
yours expert is here, I'm graduate in ACCOUNTABILITY AND ESPECIALLY IN TAX ,let's do it I can do that
How are you? I hope you are fine. I have read your request and I would love to work that I will work with your requirements. I have already put a thought on your design and would love to explain it to you through wo Plus