Silver
05-13-2015, 10:33 AM
PART 1
Agents update their days work in Production sheet. Since the agents work on 10 categories
it becomes time consuming to scroll through the sheet to update their time and counts.
Came across a userform on the net.
Pretty much what I'm looking for, though needs few additions and changes.
A brief info of what it does -
Using data from combobox to find the cell on the worksheet
and write to a specific adjacent cell.
Worksheet name is Jan
ComboBox1 Name is cmbDate
ComboBox2 Name is cmbCat
TextBox name is txtAmount
CommandButton1
Using the date value from cmbDate, find this text in Row A of worksheet Jan
and write the Value of txtAmount in a cell adjacent to the date and under the cell
equal to the cmbCat value when the CommandButton1 is pressed.
Attached is the worksheet (Household Planner)
Have attached 2nd worksheet which is a copy of the original with few changes to it
(Production Sheet - where I need the changes)
What I'm looking for -
ComboBox1 Name is cmbDate
ComboBox2 Name is cmbCat
I need 2 textboxes - txtTime and txtCount
CommandButton1
When clicked on commandbutton1 it should do what is explained as above
(highlighted in Bold), except, the data entered in the 2 textboxes should reflect under the columns Time and Counts.
Also need a Goto button - with datas selected in cmbDate and cmbCat
when clicked on Goto button it should take me to the relevant cells.
Below is a snapshot
13363
cmbDate - 2
cmbCat - Alcohol/Cigaretes
with above selection made it should take me to the Time column under
Category Alcohol/Cigaretes of Date 2 (Date format may change to 02-May-15)
PART 2
Would like to know if a summary can be generated of all the categories the agents has worked on including Time and Counts, based on dates selected.
Agents update their days work in Production sheet. Since the agents work on 10 categories
it becomes time consuming to scroll through the sheet to update their time and counts.
Came across a userform on the net.
Pretty much what I'm looking for, though needs few additions and changes.
A brief info of what it does -
Using data from combobox to find the cell on the worksheet
and write to a specific adjacent cell.
Worksheet name is Jan
ComboBox1 Name is cmbDate
ComboBox2 Name is cmbCat
TextBox name is txtAmount
CommandButton1
Using the date value from cmbDate, find this text in Row A of worksheet Jan
and write the Value of txtAmount in a cell adjacent to the date and under the cell
equal to the cmbCat value when the CommandButton1 is pressed.
Attached is the worksheet (Household Planner)
Have attached 2nd worksheet which is a copy of the original with few changes to it
(Production Sheet - where I need the changes)
What I'm looking for -
ComboBox1 Name is cmbDate
ComboBox2 Name is cmbCat
I need 2 textboxes - txtTime and txtCount
CommandButton1
When clicked on commandbutton1 it should do what is explained as above
(highlighted in Bold), except, the data entered in the 2 textboxes should reflect under the columns Time and Counts.
Also need a Goto button - with datas selected in cmbDate and cmbCat
when clicked on Goto button it should take me to the relevant cells.
Below is a snapshot
13363
cmbDate - 2
cmbCat - Alcohol/Cigaretes
with above selection made it should take me to the Time column under
Category Alcohol/Cigaretes of Date 2 (Date format may change to 02-May-15)
PART 2
Would like to know if a summary can be generated of all the categories the agents has worked on including Time and Counts, based on dates selected.