Can I use a form to search and update data?

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
 
D

Don Guillett Excel MVP

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

"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."
 
M

Mel

"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 -

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top