Can I use a form to search and update data?

  • Thread starter Thread starter Mel
  • Start date Start date
M

Mel

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?

thx
 
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?

thx
Click to expand...

"If desired, send your file to dguillett @gmail.com I will only look
if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results."
 
"If desired, send your file to dguillett  @gmail.com I will only look
if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results."- Hide quoted text -

- Show quoted text -
Click to expand...

I will send you by email copy of my spreadsheet. thx
Mel
 
Back
Top