|Subject:||Can I use a form to search and update data?|
|Posted by:||Mel (mel.pilgr…@agr.gc.ca)|
|Date:||Fri, 10 Dec 2010|
I have a spreadsheet with 3 tabs. Input, Comp-Activity, field
areas. On input, I have a user form that opens and the user can
complete info. That info is posted to the next empty row on comp
activity. The updating of info works great.
Now what I need to do is be able to update a row that a user has
updated. id. change status from 'beginning' to 'completed'.
I am thinking of copying the data from Comp-activty to comp activity 2
using past value (not sure if this is best way) then have a search box
open looking for a value ie. user name who input, date, etc. (I
would like to have it automatically copy data and paste values too
maybe using private sub)
Anyone have any idea best option?