Suoritettu

Complete my report with best excel lookup formulas

There are 3 sheets of Report Data that I need the formulas created.

Sheet DETAIL DATA is the source data.

Each month, I insert a row in front of the previous month to add new months data

For example, in October, I will insert a new Row I, and September will become Row J. The new months Data (October) will become Row I

There are a variety of formulas that I have tried in all the sheets and columns, but I need an expert to populate the best formula in each column and sheet.

In the SALES BY CUSTOMER tab, Row D has the formulat that seems to be working best at the moment.

I have tried a variety of SUMIF, SUMPRODUCT etc, but this longer formula seems to be the only one I can make work, in regards to:

1-getting the totals correct,

2-Being able to handle the fact that I add in a new months column of data in front of the prior month in the DETAIL DATA tab.

I need the Sheets SALES BY CUSTOMER, ALL DETAIL, and REVENUE and GROWTH, to pull data according to the row heading, from the DETAIL DATA sheet.

I also need all the heading rows to automatically populate the correct relevant dates based on the report month (contained in the REPORT INFO sheet).

I believe the column references are self explanatory in terms of what data is required, but happy to answer any clarification questions.

Taidot: Excel, tietojenkäsittely, tiedonsyöttö, Visual Basic

Näytä lisää: report database excel format php, inventory report daily excel file sample, best excel dashboards, report scraping excel, student report card excel, excel lookup google finance, best excel worksheet design, best excel reports, advanced excel skills test questions, report card excel, creating multiple report cards excel, getting report output excel oracle apps, oracle application report convert excel, excel bidding formulas, best excel data structure, best format monthly production report template excel, best excel formulas with examples

Tietoa työnantajasta:
( 5 arvostelua ) Kelvin Grove, Australia

Projektin tunnus: #21824917

Myönnetty käyttäjälle:

aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex formulas and macros. You may check some of my projects here: [login to view URL]

$100 AUD 2 päivässä
(121 Arvostelua)
5.9

42 freelanceria on tarjonnut keskimäärin 118$ tähän työhön

schoudhary1553

Hello Sir, I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without cha Lisää

$240 AUD 5 päivässä
(342 arvostelua)
8.0
dgled

Hi, I am financial experts and a guru in Excel with extensive knowledge and expertise in advanced formulas, Pivot Tables, Tables, and Visual Basic Application including preparation of available interfaces, dynamic dash Lisää

$250 AUD 7 päivässä
(84 arvostelua)
7.1
seoguru17

I am good at Excel formula and VBA/Macro, I need to see the data so I can understand your requirement, I have a few question to discuss so I need you to send a message on chat.

$140 AUD 7 päivässä
(98 arvostelua)
6.4
younus15

I have a suggestion for your project. You can use google sheets for that. google sheets has very better reports on that fro your [login to view URL] can use it online from anywhere that has a internet access. I can transfer yo Lisää

$240 AUD 4 päivässä
(120 arvostelua)
6.0
citijayamala

1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. I read your project description and I am sure that I can handle your project. 2. Have done many projects i Lisää

$200 AUD 3 päivässä
(65 arvostelua)
5.6
daniyal3214

I can definitely help you with that. I am a professional Financial Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Excel including VBA and Macro to perform automat Lisää

$50 AUD 1 päivässä
(52 arvostelua)
5.5
AkilaArun

Hi, I am interested in working on the task. I have more than 5 years of experience working with excel, VBA, Data Analysis( Graphically and Statistically) and in dashboard creation. Saw the [login to view URL] like to disc Lisää

$180 AUD 7 päivässä
(43 arvostelua)
5.0
wkcompany

Hi there! I read your description. I can make this done in very short time! I am ready to start work right now. i can do this work easily. IF you are interested to work with me message me.

$140 AUD 1 päivässä
(50 arvostelua)
4.8
Arahan00

Hi, I have worked with data analysis and visualization in excel and google sheet. I would like to work on your project. Let me know if you want to discuss further. Regards, Monir

$250 AUD 10 päivässä
(1 arvostelu)
2.7
silverrock

Hello Sir/Madam I am an expert user of MS Excel. I can help you in completing your report. I can start working right now if you accept my bid. Looking forward to hear a positive response from you. Regards, Ali F.

$60 AUD 1 päivässä
(3 arvostelua)
2.0
miansajid3000

Greetings! Happy to see your Job post! I am Sajid, having Academic Qualification of Charted Accountant. I have read your project details and I am confident I am the suitable and experienced candidate for the task. Loo Lisää

$140 AUD 7 päivässä
(1 arvostelu)
2.0
syfiqahrslan

Hi, i would be the most suitable person to do this job because it is one of my major. I hope that you consider to hire me as your worker. Looking forward to work with you. Thank you.

$30 AUD 7 päivässä
(0 arvostelua)
0.0
urbanestitch

Dear Employer, I am interested and ready to start working on your project assignment.I will need a day to go through the data while testing different formulae. I have understood the business process. I believe you need Lisää

$90 AUD 4 päivässä
(0 arvostelua)
0.0
vikasp007

I've 7+ years of experience in Web Development/Web design , Mobile App Development(IOS/android), Graphic design, Logo Design, UI/UX design Business Cards & Stationery, Flyers & Brochures, Packaging Design, Web & Mobile Lisää

$140 AUD 7 päivässä
(0 arvostelua)
0.0
Gowthan1982

I m capable of completing this project on time. I have all the skills required for this project. I'm very good at ms-office.

$140 AUD 7 päivässä
(0 arvostelua)
0.0
$133 AUD 3 päivässä
(0 arvostelua)
0.0
cse18bcs2240

Hello , my name is Aditya Raj Singh . I am a dedicated and hard working person who believes in honesty and working relation. Though I am new at this sector of job but I have certain qualities which makes me good at thi Lisää

$140 AUD 7 päivässä
(0 arvostelua)
0.0
swik6894

Hi I'm looking for working with you. I've got a good handson and experience in excel sheet. I assure you that I'll give you a 100% error free work. Looking forward to work with you. Lets talk in detail about it!

$30 AUD 2 päivässä
(0 arvostelua)
0.0
vasanthmadhav235

I am a Graduate in [login to view URL](CS). I have been working on excel, and word applications since 15 years. I will definitely complete your project on time with great accuracy.

$100 AUD 2 päivässä
(0 arvostelua)
0.0
Azrulizham97

Hi my name is Azrul Izham from Malaysia and i would love to apply for the task, I am an expert in data entry and Microsoft Excel. You can expect perfect data and early submission. Thank you for your consideration.

$140 AUD 7 päivässä
(0 arvostelua)
0.0