I have got a excel sheet which is designed as follows:
1. Sr.
2. Start Time
3. Finish Time
4. Time Taken
5. Project
6. Description
7. Remarks
8. Total Hrs
Screen Shot Provided as:-
http://quick.holdthatpic.com/images/260981.jpg
The column 4 contains a formula for calculating the time taken between two intervals ( finish time - start time). Column 8 is
just to count the sum of Hours from the the time taken column.
Now i have multiple sheets added (one for each day) in one excel sheet. Taking this into consideration i want to write a
macro which would
1. First ask me if i want to calculate weekly or monthly progress.
2. In case of weekly sheet it would take account e.g # of hours spent on each project , the least amount of time on the
project etc
3. In case if the user selects month wise then user is asked for which month he wants to view the report (june,may etc). On
selecting the desired month it then do the same as specified in (2).
Problems:-
How could this be done? Is there any other solution other than using macro. Macro would just help me in automating my
tasks which is important. The report that I want to generate from the use of macro is Pie-chart representation ... which is governed on variables (e.g time take,total hrs and sr no of project). Its fairly simply to generate the report from one sheet but from multiple sheets it becomes a problem of correlation.
1. Sr.
2. Start Time
3. Finish Time
4. Time Taken
5. Project
6. Description
7. Remarks
8. Total Hrs
Screen Shot Provided as:-
http://quick.holdthatpic.com/images/260981.jpg
The column 4 contains a formula for calculating the time taken between two intervals ( finish time - start time). Column 8 is
just to count the sum of Hours from the the time taken column.
Now i have multiple sheets added (one for each day) in one excel sheet. Taking this into consideration i want to write a
macro which would
1. First ask me if i want to calculate weekly or monthly progress.
2. In case of weekly sheet it would take account e.g # of hours spent on each project , the least amount of time on the
project etc
3. In case if the user selects month wise then user is asked for which month he wants to view the report (june,may etc). On
selecting the desired month it then do the same as specified in (2).
Problems:-
How could this be done? Is there any other solution other than using macro. Macro would just help me in automating my
tasks which is important. The report that I want to generate from the use of macro is Pie-chart representation ... which is governed on variables (e.g time take,total hrs and sr no of project). Its fairly simply to generate the report from one sheet but from multiple sheets it becomes a problem of correlation.