Dynamic Report in Excel 2010

I have a very large raw set of data that I would like to transform into a dynamic reporting tool in Excel. I want to speak with someone who is very good in Excel to show me how to develop a dynamic report out of this data. The data has a combination of text and numbers, so pivot tables won't work. What is needed is something like a pivot table, but that also works for raw data that has a combination of numbers and text.

The attached file has a sample small size of raw data that is in "Raw Data" spreadsheet. The "Report" spreadsheet is using the Subtotal functionality in Excel. I would like to speak with someone to show me how to make this report much more dynamic to accommodate a much larger set of raw data and be much more flexible.

Required features include:

1. Adding a drop down menu on top for "Material Group" and "Vendor ID" (currently in columns B and F in attached file). Once a selection is chosen in these filters, data in the report would get updated including all grand totals and subtotals.

2. Adding a dynamic weighted average on row 2 of the Report spreadsheet for columns K through Q, using column D for the weights. Note that Columns K through Q have some blanks while column D doesn't. This dynamic weighted average would get updated every time any of the filters for the other columns get changed.

The person I want to speak with will have to be experienced enough to show me how to do that via a web conferencing tool where we can share screens (Skype or any other readily available tool).

I am not satisfied with using the Subtotal functionality in Excel because. The Report I'm looking to for should be much cleaner and more flexible.

Interested bidders must send me a screenshot of how they would envision the report would look like.

Habilidades: Excel

Veja mais: we-top dynamic, we top dynamic, how to do a report, how excel works, what is a skype id, pivot tables, pivot table excel, excel PIVOT, excel pivot table, set 2010 excel pivot, excel text column, pivot report, excel pivot table raw data, excel drop, text table excel, excel combination, raw data report, excel pivot table data raw data, adding row excel, web reporting tool, pivot table excel 2010, excel row text file, share excel spreadsheet, raw material report, dynamic table

Acerca do Empregador:
( 6 comentários ) New York, United States

ID do Projeto: #6820020

Concedido a:


Hello, I'm an excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$50 USD em 3 dias
(9 Comentários)

4 freelancers estão ofertando em média $58 para esse trabalho


Hello, I am top freelancer on this forum with 200+ five star reviews and with a completion rate of 90%. I have understood your requirement and I am sure I can implement this. Check my past reviews for your reference. E Mais

$50 USD in 0 dias
(231 Comentários)

A proposal has not yet been provided

$30 USD em 1 dia
(0 Comentários)

It's doable, but it's not your everyday task, so I have to charge higher. I'll make it work and make you understand perfectly how it was done, though. Thanks! Felipe

$100 USD in 3 dias
(0 Comentários)