Add data to row that already contains data

aileen - Feb 27, 2019 at 05:38 PM
 aileen - Mar 1, 2019 at 01:19 PM
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?

1 response

Blocked Profile
Feb 27, 2019 at 05:43 PM
WOw, you are re-inventing the database!

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.
Thanks! I guess this will be the route I'll ultimately go as there is a huge database already in place.
But thanks for your idea!