Færdiggjort

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.

Evner: Excel, Databehandling, Dataindførsel, Visual Basic

Se mere: 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

Om arbejdsgiveren:
( 6 bedømmelser ) Kelvin Grove, Australia

Projekt ID: #21824917

Tildelt til:

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 in 2 dage
(132 bedømmelser)
6.0

41 freelancere byder i gennemsnit $117 på dette job

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 Flere

$240 AUD in 5 dage
(352 bedømmelser)
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 Flere

$250 AUD in 7 dage
(88 bedømmelser)
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 in 7 dage
(99 bedømmelser)
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 Flere

$240 AUD in 4 dage
(125 bedømmelser)
6.1
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 Flere

$50 AUD på 1 dag
(53 bedømmelser)
5.5
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 Flere

$200 AUD in 3 dage
(67 bedømmelser)
5.7
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 Flere

$180 AUD in 7 dage
(43 bedømmelser)
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 på 1 dag
(56 bedømmelser)
4.9
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 Flere

$140 AUD in 7 dage
(2 bedømmelser)
3.2
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 in 10 dage
(1 bedømmelse)
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 på 1 dag
(3 bedømmelser)
2.0
writingstudio22

I am a multi-skilled person with sound proficiency in English language for being a native writer and proofreader while I am also well-versed in French and Portuguese languages. Furthermore, I am a PR professional with Flere

$100 AUD in 2 dage
(2 bedømmelser)
1.1
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 in 7 dage
(0 bedømmelser)
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 in 2 dage
(0 bedømmelser)
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 Flere

$140 AUD in 7 dage
(0 bedømmelser)
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 in 7 dage
(0 bedømmelser)
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 Flere

$140 AUD in 7 dage
(0 bedømmelser)
0.0
raghavendra678

I can create a template(dashboard) for getting each month data as per your requirement. Thanks, Raghavendra

$55 AUD på 1 dag
(0 bedømmelser)
0.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 in 7 dage
(0 bedømmelser)
0.0
$133 AUD in 3 dage
(0 bedømmelser)
0.0