Filling a cell with values from another worksheet

  • Thread starter Thread starter Jatherton
  • Start date Start date
J

Jatherton

I would like to have the ability to request a user (tab 1) to select a
value from a column of items on a seperate worksheet (tab 3) and then
fill a cell on worksheet 1 (tab 1) with that value.

Does that make any sense? I am guessing that I would need to use a
User Form to grab the choices and allow the user to select them?
 
You need to make a listbox and set the data range of this to equal your
range of values on tab3. Then in the change event just add the code to copy
the value n the box to the cell you want.
 
Back
Top