Inventory Sheet Updated Continuously By A UserForm

DISCUSSION

I have a spreadsheet that I have been creating for work. It involves a UserForm (FRM_TubingTransfer) and writing the data entered onto sheets (either the �MASTER SHEET� or �COMBOBOX DATA�) in the same workbook.

PROBLEM

I have (with your help and much trial and error) gotten the workbook to a reasonably working model. The only major thing left is the �AVAILABLE TUBING� sheet. This sheet is the most complicated, I think, because it isn�t just strictly writing the data.

First, any time there is a NEW PROPERTY / SUPERVISOR entered in the form onto the COMBOBOX DATA screen, the code needs to check the AVAILABLE TUBING sheet and check if that data has already been entered there (This is because there may be some instances where the PROPERTY NAME, and PROPERTY NUMBER are the same but have a different PROPERTY AFE. Aka, there may be two entries with �WELL 1� that have different AFE numbers but they are the same location and need to be treated as such.). Also, if a pipe yard (denoted by �-YARD-� in the Property number and AFE number column) is entered, do not enter it on the AVAILABLE TUBING SHEET.

Second, when a TUBINGTRANSFER is processed, the program needs to do several things;

For the FROM LOCATION (if a well and not a pipe yard)
Add Buried Joints to the buried cell
Add (E) to the damaged cell
Subtract (A), (B), and (C) from the total on location cell
For the TO LOCATION (if a well and not a pipe yard)
Add (A), (B), and (C) from the total on location cell