Hi all,
this may sound really simple but i don't know how to do it so i hope somebody here does.
basically, i have a userform that places several columns of data into the first empty row.
i now need to produce a second userform that will find an entry, and place some more entries in the relevant row next to it.
the first userform makes 5 entries on a row, one of which is a silo number, this is the cell to be found by the second userform. the only problem is, there may be several entries for the same silo number, i need the second userform to find the last entry for any given silo number and place the rest of the details along that row in the correct columns.
I know how to create a userform, and how to get it to post the relevant data to the correct places on a sheet, what i dont know is how do i use the first entry on a userform to be the basis for a search and post the rest of the details when the last entry for that search is found!
i hope that makes sense!?
any help appreciated
this may sound really simple but i don't know how to do it so i hope somebody here does.
basically, i have a userform that places several columns of data into the first empty row.
i now need to produce a second userform that will find an entry, and place some more entries in the relevant row next to it.
the first userform makes 5 entries on a row, one of which is a silo number, this is the cell to be found by the second userform. the only problem is, there may be several entries for the same silo number, i need the second userform to find the last entry for any given silo number and place the rest of the details along that row in the correct columns.
I know how to create a userform, and how to get it to post the relevant data to the correct places on a sheet, what i dont know is how do i use the first entry on a userform to be the basis for a search and post the rest of the details when the last entry for that search is found!
i hope that makes sense!?
any help appreciated