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