userform help needed

tuggers

Board Regular
Joined
Nov 10, 2005
Messages
145
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
 

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

Forum statistics

Threads
1,144,522
Messages
5,724,830
Members
422,581
Latest member
samiak

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top