Lengkap

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.

Kemahiran: Excel, Pemprosesan Data, Pemasukan Data, Visual Basic

Lihat lagi: 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

Tentang Majikan:
( 6 ulasan ) Kelvin Grove, Australia

ID Projek: #21824917

Dianugerahkan kepada:

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 dalam 2 hari
(132 Ulasan)
6.0

41 pekerja bebas membida secara purata $117 untuk pekerjaan ini

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 Lagi

$240 AUD dalam 5 hari
(352 Ulasan)
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 Lagi

$250 AUD dalam 7 hari
(88 Ulasan)
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 dalam 7 hari
(99 Ulasan)
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 Lagi

$240 AUD dalam 4 hari
(125 Ulasan)
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 Lagi

$50 AUD dalam sehari
(53 Ulasan)
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 Lagi

$200 AUD dalam 3 hari
(67 Ulasan)
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 Lagi

$180 AUD dalam 7 hari
(43 Ulasan)
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 dalam sehari
(56 Ulasan)
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 Lagi

$140 AUD dalam 7 hari
(2 Ulasan)
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 dalam 10 hari
(1 Ulasan)
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 dalam sehari
(3 Ulasan)
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 Lagi

$100 AUD dalam 2 hari
(2 Ulasan)
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 dalam 7 hari
(0 Ulasan)
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 dalam 2 hari
(0 Ulasan)
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 Lagi

$140 AUD dalam 7 hari
(0 Ulasan)
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 dalam 7 hari
(0 Ulasan)
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 Lagi

$140 AUD dalam 7 hari
(0 Ulasan)
0.0
raghavendra678

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

$55 AUD dalam sehari
(0 Ulasan)
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 dalam 7 hari
(0 Ulasan)
0.0
$133 AUD dalam 3 hari
(0 Ulasan)
0.0