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
Bookmarks