Hi all,
At work we are trying to keep track of mistakes made when picking pallets for customers. We have a excel spreadsheet to hold the info and then weekly we want to pull of a pie chart with the info in. Problem is that there is only 2 of us that know anything about computers.
I would like it so that they can enter the cost of the mispicks for each week and then just select from a drop down menu which week they want the pie chart for, it then runs off and collects the information required and then builds the pie chart for them including labels.
Is this possible? VB code?
The spreadsheet has week 1 to week 52 down the left hand side, then the employees names across the top. We then enter the cost in mispicks for each person to the corresponding week. So the info in the spreadsheet will be the cost and the labels/legend will be their names.
Any help gratefully received
More importantly, i use openoffice at home and not excel, is it still possible to use VB code in OO as you would in excel?
At work we are trying to keep track of mistakes made when picking pallets for customers. We have a excel spreadsheet to hold the info and then weekly we want to pull of a pie chart with the info in. Problem is that there is only 2 of us that know anything about computers.
I would like it so that they can enter the cost of the mispicks for each week and then just select from a drop down menu which week they want the pie chart for, it then runs off and collects the information required and then builds the pie chart for them including labels.
Is this possible? VB code?
The spreadsheet has week 1 to week 52 down the left hand side, then the employees names across the top. We then enter the cost in mispicks for each person to the corresponding week. So the info in the spreadsheet will be the cost and the labels/legend will be their names.
Any help gratefully received
More importantly, i use openoffice at home and not excel, is it still possible to use VB code in OO as you would in excel?
Last edited:
