Terminé

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.

"""

Compétences : Comptabilité, Analyse des Affaires, Saisie de Données, Traitement de Données, Excel

en voir plus : 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

Concernant l'employeur :
( 0 commentaires ) Ilford, United Kingdom

Nº du projet : #20010661

Décerné à:

                                                    rIbrarahmed
                                                's Profile Picture"                                                    >
                                                </a>
                                            </figure>
                                        </div>
                                        <div class=
rIbrarahmed

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 Plus

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% GBP en 1 jour
(26 Commentaires)
4.5

27 freelance font une offre moyenne de £108 pour ce travail

schoudhary1553

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 4 jours
(322 Commentaires)
7.9
best4best

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 2 jours
(192 Commentaires)
6.5
dvcontact

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 4 jours
(51 Commentaires)
6.3
nvchien94

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 5 jours
(97 Commentaires)
5.4
vsprybhanu

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 5 jours
(61 Commentaires)
5.2
cooolwriter

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(9 Commentaires)
4.3
Rugues

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(8 Commentaires)
3.4
pjlnel

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 7 jours
(4 Commentaires)
2.8
writingapp

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 2 jours
(4 Commentaires)
1.9
josephkirkmaling

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 7 jours
(2 Commentaires)
1.6
shaimaa33lux

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(3 Commentaires)
1.3
ArturQQ

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(2 Commentaires)
1.4
pmanalyst

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 2 jours
(1 Évaluation)
0.7
vipulshirbad14

Plzzzzz

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(0 Commentaires)
0.0
OUTYOUSSEF

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 2 jours
(0 Commentaires)
0.0
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(0 Commentaires)
0.0
fjanzen

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(0 Commentaires)
0.0
diegoedunapo

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 5 jours
(0 Commentaires)
0.0
sefiros123

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 4 jours
(0 Commentaires)
0.0
NAJAM5313

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 7 jours
(0 Commentaires)
0.0