I want to enter data for the same product but it needs to be done on different days, with two different entry forms, so the row will already contain data points and I will have to pick the row and add more data in the following cells of the same row (not a new one)
on day 1 I enter: on day 2 I add on to the same row
Day Product Weekday processing date amount operator
Is there any way that vb can find the row with the product I need and then just add data into the same row with a second entry form?
Why not have a DB with an entry form, for entering. Then another form for management of already entered parts? If you have no experience with a DB, the learning curve is way less sharp as with VB. Besides, a DB can scale!
If you decide to go down this route, I will help with design. Otherwise, wait around, and more than likely someone else will author you a script to cut and paste.