Hi, Kistler,
Then based off the selection, it will copy the Totals cell into a different workbook which will be on a different computer but networked to the one being used.
Is that workbook opened in the instance of Excel or does it need to be opened just for the copying? Where shall that data be copied? Is it one sheet conitnuous with date/time stamp and values of CBs and Value total? Are there more sheets regarding the departments?
First thing in your Submit-Procedure for me would be to check if both Comboboxes show values:
I choose Exit Sub here but I would find it more informative to place a Message Box telling the user to make a choice in Department or Shift.
At the end (with the clearing of the ComboBoxes) I would reset the values for the ComboBoxes as well to None.
Ciao,
Holger
Bookmarks