Here is an example of one way to do it. On sheet 1 anything entered into column D is subject to validation. Upon cell selection, a form is launched with the selections. when you make the selection, the value is entered into the cell that called it.
Here is an example of one way to do it. On sheet 1 anything entered into column D is subject to validation. Upon cell selection, a form is launched with the selections. when you make the selection, the value is entered into the cell that called it.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks