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

On Dec 10, 4:19*pm, Mel <mel.pilg...@agr.gc.ca> wrote:
> 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."

On Dec 10, 5:12*pm, Don Guillett Excel MVP <dguille...@austin.rr.com>
wrote:
> On Dec 10, 4:19*pm, Mel <mel.pilg...@agr.gc.ca> wrote:
>
>
>
>
>
> > 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."- Hide quoted text -
>
> - Show quoted text -

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