Is this possible?

[Desu Nota from Columbus]

I need to know if this is possible, and then if you can, how to do it.

I will attach a sample of the data I am using at the bottom for reference.

I need to have a form/button/search field to bring up a row based on the SERIAL NO. Once I search and find the serial no, I want to update the other information (such as date, location and condition)

How would this be done? I have been messing around with userforms for the last two days and have made zero advancements. I would rate my technical level as novice-but capable (novice due to lack of exposure).

Any help would be fantastic.






<table border="0" cellpadding="0" cellspacing="0" width="435"><col style="mso-width-source:userset;mso-width-alt:2816;width:58pt" width="77"> <col style="mso-width-source:userset;mso-width-alt:4242;width:87pt" width="116"> <col style="mso-width-source:userset;mso-width-alt:3547;width:73pt" width="97"> <col style="mso-width-source:userset;mso-width-alt:5302;width:109pt" width="145"> <tbody><tr style="height:12.75pt" height="17"> <td style="height:12.75pt;width:58pt" height="17" width="77">SERIAL NO</td> <td style="width:87pt" width="116">MODEL</td> <td style="width:73pt" width="97">DATE MOVED</td> <td style="width:109pt" width="145">LOCATION</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">412-017</td> <td>007 Brush</td> <td>
</td> <td>1C-15</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">412-018</td> <td>007 Brush</td> <td>
</td> <td>LINE 9</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">412-064</td> <td>007 Brush</td> <td>
</td> <td>LINE 1</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">412-069</td> <td>007 Brush</td> <td>
</td> <td>LINE 10</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">412-080</td> <td>007 Brush</td> <td>
</td> <td>LINE 4</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">412-110</td> <td>Woodgrain</td> <td>
</td> <td>AT VENDOR</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">412-156</td> <td>010 Brush</td> <td>
</td> <td>LINE 8</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">412-164</td> <td>010 Brush</td> <td>
</td> <td>LINE 8</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">412-166</td> <td>Truemill</td> <td>
</td> <td>1D-03</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">412-171</td> <td>Truemill</td> <td>
</td> <td>NP STORAGE RACK</td> </tr> </tbody></table>

 

[venkat1926]

suppose your data is in sheet 1 from A1 to D11.

suppose in sheet 2 in row 1 same column heading from A1 to D1
suppose in A2 you input a serial number e.g. 412-110

in B2 copy this formula

=VLOOKUP($A2,Sheet1!$A$1:$D$100,COLUMN(B1),0)

copy B2 to c2 and D2

In sheet 2 if you have more inputs in column A you have to just copy the range B2 to D2 down

even if you have more rows (upto 100) in sheet 1 this will work.

you can have more columns in sheest 1 . correspondingly you have to copy the formula beyond D2 in sheet 2.

if it is more change the 100 in the formula.

TRY THIS AND GIVE FEEDBACK

this will be easier than a macro

 

[Desu Nota from Columbus]

I have already tinkered with this, but vlookup doesn't allow me to edit the source data. I need to be able to search and then update/rewrite the data.

Thanks for the consideration though

 

[venkat1926]

not clear. vlookup does not disturb source data and it only takes information from source.

some more clarification with examples would be helpful

 

[Desu Nota from Columbus]

What I said,
"vlookup doesn't allow me to edit the source data"

what you said,
"vlookup does not disturb source data and it only takes information from source"

These statements are saying exactly the same thing.

From earlier:

"I need to have a form/button/search field to bring up a row based on the SERIAL NO. Once I search and find the serial no, I want to update the other information (such as date, location and condition)"

I want to have a search box/cell where I type in a serial number, it brings up all the attached data and allows me to edit it (the source data). As said previously, with vlookup, i can only pull up the source data; the changes I make don't effect the source data.

I don't see where the confusion is coming from.