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.

Skills: Excel, Data Processing, Data Entry, Visual Basic

See more: 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

About the Employer:
( 5 reviews ) Kelvin Grove, Australia

Project ID: #21824917

Awarded to:


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 in 2 days
(121 Reviews)

42 freelancers are bidding on average $118 for this job


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 More

$240 AUD in 5 days
(342 Reviews)

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 More

$250 AUD in 7 days
(84 Reviews)

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 in 7 days
(98 Reviews)

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 More

$240 AUD in 4 days
(120 Reviews)

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 More

$200 AUD in 3 days
(65 Reviews)

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 More

$50 AUD in 1 day
(52 Reviews)

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 More

$180 AUD in 7 days
(43 Reviews)

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 in 1 day
(50 Reviews)

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 in 10 days
(1 Review)

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 in 1 day
(3 Reviews)

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 More

$140 AUD in 7 days
(1 Review)

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 in 7 days
(0 Reviews)

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 More

$90 AUD in 4 days
(0 Reviews)

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 More

$140 AUD in 7 days
(0 Reviews)

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 in 7 days
(0 Reviews)
$133 AUD in 3 days
(0 Reviews)

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 More

$140 AUD in 7 days
(0 Reviews)

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 in 2 days
(0 Reviews)

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 in 2 days
(0 Reviews)

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 in 7 days
(0 Reviews)