I need an Excel expert

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.


Kemahiran: Perakaunan, Analisis Perniagaan, Pemasukan Data, Pemprosesan Data, Excel

Lihat lagi: need excel expert, need excel expert match columns, need excel expert create macro, i need an expert in english language that would help to grade my essay test, i need an expert in formatting word documents in australia, i need an expert on whmcs to make a very simple job, i need an expert, i need excel data entry, i need excel expert, i need seo expert for my, i need seo expert, urgent i need an expert on grasshopper, www i need an expert to write my speech com, where can i hire excel expert, any company need excel expert from home, how do i find excel expert in sri lanka, i need a logo with an x, i need an expert in facebook, i need an expert modeler, i need an expert to build a website

Tentang Majikan:
( 0 ulasan ) Ilford, United Kingdom

ID Projek: #20010661

Dianugerahkan kepada:


hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I understand the value of deadline and do not compromise on quality. I feel fit myse Lagi

£60 GBP dalam sehari
(26 Ulasan)

27 pekerja bebas membida secara purata £108 untuk pekerjaan ini


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 Lagi

£220 GBP dalam 4 hari
(322 Ulasan)

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 Lagi

£100 GBP dalam 2 hari
(192 Ulasan)

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 Lagi

£150 GBP dalam 4 hari
(51 Ulasan)

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 Lagi

£250 GBP dalam 5 hari
(97 Ulasan)

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 Lagi

£120 GBP dalam 5 hari
(61 Ulasan)

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 Lagi

£100 GBP dalam 3 hari
(9 Ulasan)

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 Lagi

£111 GBP dalam 3 hari
(8 Ulasan)

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 Lagi

£150 GBP dalam 7 hari
(4 Ulasan)

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

£60 GBP dalam 2 hari
(4 Ulasan)

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 Lagi

£230 GBP dalam 7 hari
(2 Ulasan)

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 Lagi

£20 GBP dalam sehari
(3 Ulasan)

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 Lagi

£100 GBP dalam sehari
(2 Ulasan)

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 Lagi

£90 GBP dalam 2 hari
(1 Ulasan)


£150 GBP dalam 3 hari
(0 Ulasan)

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 Lagi

£30 GBP dalam 2 hari
(0 Ulasan)
£150 GBP dalam 3 hari
(0 Ulasan)

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 Lagi

£20 GBP dalam sehari
(0 Ulasan)

I'm a public accountant and data scientist with experience in recommendation systems, deep learning and machine learning algorithms.

£33 GBP dalam 5 hari
(0 Ulasan)

yours expert is here, I'm graduate in ACCOUNTABILITY AND ESPECIALLY IN TAX ,let's do it I can do that

£33 GBP dalam 4 hari
(0 Ulasan)

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 Lagi

£150 GBP dalam 7 hari
(0 Ulasan)