Hi,
I have created a form which import data from another sheet for the
purpose of updating the data and sending it back updated where it was.
I need to create a search function to find and update the source sheet.
Here's more details :

Each row of the source list uses the two first columns to identify the
row (which is unique in the list by using those two variables as
combined identifiers). For example, collumn A = 114555 and the B = 104.
Those two columns are in columns A and B in the source sheet. When I
extract data, it place the value of column A in cell Y2 of the form
(cause it's the same value for all the form's rows) and column B from
the source becomes column A in the form. So, I need now to update the
source with a "find next function" (when you find and copied take the
next row in the form and search again) that uses the two identifiers
from the form as a combination to find the source identifiers that are
in the same row in the source sheet. Then, I want to copy cells A to AE
from the form's row matching the source to source sheet's row in columns
B to AF.

Maybe I gave a bit too much details, so if you are a bit confused, feel
free to ask all the questions that you have in mind. I'll answer as
quickly as I can.

Thx!

Werner


--
Werner
------------------------------------------------------------------------
Werner's Profile: http://www.excelforum.com/member.php...o&userid=24304
View this thread: http://www.excelforum.com/showthread...hreadid=386164