Hi All
First thing can anyone please tell me "how to add attachment to this thread .
Second thing Question: When I enter start time,finish time,efficiency,category in userform and press enter then a new row should be inserted in the sheet and the data should appear in "staff requirement" sheet (Same way its happening through macros).
E.g if the category is "A" then "FTE required in time available" field value should pop up in 2nd chart corresponding to "Archiving". And if the category is "M" then the corresponding time available value should appear under "Mail" part in the 2nd chart.
The chart that shows FTE Time available based upon start time and finish time should pop up data automatically.
The data should appear in all the chart formats.
I hope you understand my problem.I have made first chart and 2nd chart working but need your help in populating data in others charts too.
ANy help would be much appreciated.
Thanks <!-- / message --><!-- attachments -->
First thing can anyone please tell me "how to add attachment to this thread .
Second thing Question: When I enter start time,finish time,efficiency,category in userform and press enter then a new row should be inserted in the sheet and the data should appear in "staff requirement" sheet (Same way its happening through macros).
E.g if the category is "A" then "FTE required in time available" field value should pop up in 2nd chart corresponding to "Archiving". And if the category is "M" then the corresponding time available value should appear under "Mail" part in the 2nd chart.
The chart that shows FTE Time available based upon start time and finish time should pop up data automatically.
The data should appear in all the chart formats.
I hope you understand my problem.I have made first chart and 2nd chart working but need your help in populating data in others charts too.
ANy help would be much appreciated.
Thanks <!-- / message --><!-- attachments -->
