I think I need to explain a bit more. I give also the link to a copy of
my work to help.

ok allright, I've put online a copy of my Excel file. The source data
is in "PI". The form is in "Formulaire". It represents a building and
its apartments. So the logic is in the source sheet, column A
represents each building identification and column B is the apartment
number. So you understand that all the apartments in the same building
have the same building identification in column A. In the form in sheet
"Formulaire", when I extract data, I only show the building
identification in one cell in cell Y2 cause it's always the same. so
I've moved the data from one columns left. In the form, column A is the
apartments numbers. Now, I need to send the apartments info updated back
into the source sheet ("PI"). I need to use cell Y2 in "form" (building
ID) as the first corresponding value in colunm A and his apartment
number from column A in the form to colum B in the source sheet "PI".
And I must do it for each apartment numbers (a row in the form is for
an apartment) in other to update all the apartments in the building in
the source data.

Here's the link to my work :

http://agora.ulaval.ca/~jjdou/Loclis04sample.zip

If you need any more explanations, say it and I'll help you.

Regards,

Werner


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