I have an excel spread sheet which has multiple columns in the first Worksheet. One of the columns in that sheet is the Date ‘column’. There is data in the other columns which is there for that particular date. This first worksheet has all the data which has been captured and the data in some columns have been calculated using the appropriate formula.
I also have the second worksheet which has some of the columns based on the data from the first worksheet. Basically, all the data in the columns in this second worksheet have been derived from the data in the first worksheet. I have put all the formulas in the columns needed to populate the data in all these columns. The third worksheet displays some pie and bar charts based on the data from this second worksheet.
I would like to create the pie/bar charts based on the input data from a selected date range of first sheet. So all the necessary calculations in the second worksheet can only be done on this data for a particular date range (which has been captured in the first worksheet). The charts in the third sheet would be created accordingly. So, in a nutshell it is quite simple: Pick up data for the date range specified by the user from the first worksheet, apply the necessary formulas and populate the columns of second sheet, and finally create charts from this data. I think you would need a macro for this to ask user for the date range and then work only on this data in date range. Not more than 1 hour job for an excel wizard, as I have all the formulas and data.
Let me know ASAP as I have limited time and also the timeframe to do it. Thanks
Bu iş için 37 freelancer ortalamada $53 teklif veriyor
I have done a lot in excel using macros, and willing to start working. If you are interested in some examples of my work, send PM, regards.
I am a computer programmer looking for some extra money on the side. I have Excel 2007 at home and I have developed a complex workbook to keep track of our family budget. In addition, I am very familiar with Visual B Daha Fazla
Dear Sir, We are very much pleased to join in your project by participating in the bid. We are a 7 member team working together in online jobs for round the clock to establish ourselves as good, accurate prompt and ho Daha Fazla
hello sir i have done many of MBA project doing in my MBA.i have done this excel work in my project so i am sure i can complete it easily.
Hello This is supriyo [login to view URL] grad looking for job. I am very serious and dedicated for job, looking forward to business with you. Regards supriyo
I.m ready to this project.... i need the detailed description abt this