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.
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]
42 freelancers are bidding on average $118 for this job
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.
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.
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
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.
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.
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!
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.
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.