Need to find a specific row based on matching 3 columns

[Telperion]

I'm creating a userform to enter values in a table. The table has Date, OperationType, Operation, OperationMethod, and OperationQuantity. The user will open the form, select the date, and enter payment totals from 11 categories. The data layout is as follows, with quantities to be entered in column E:

Please Login or Register  to view this content.

I have code to do everything I need to do, except to locate the unique row for each combination of Date, Operation, and Method. here's the full code I have now, it doesn't work, and it's in a partial state of being converted to what I'm trying to do with it here. All of my ideas are complicated and I know there has to be an easier way.

Please Login or Register  to view this content.

[apo]

Hi..

Can you upload your Workbook...

Click the "Go Advanced" button to access the Attachment function..


Looks like you have a heap of superfluous code in there... might be easier to start from scratch using your Workbook layout as a guide....