funcxtions should be used to write to other locations. Functions only get
data from other locations.

The best way to achieve your requirements is to us a worksheet_change macro.
The macro can be written such when you enter new information in one
spreadsheet it automatically writes the data in another location.

"dhunter43" wrote:

I have a worksheet (Input) that uses several drop down menus to make
selections that result in corresponding data showing up in the adjacent
column. i.e. (A1) process selected from list of 9 options then (B1) returns
production rate of process. (A2) process selected from list of 9 options then
(B2) returns production rate of process and so on until all required
processes are selected for project.
On another worksheet (OPS) I have columns for every process that I want to
use to create a dynamic schedule using a Gantt chart. I want to populate this
worksheet with the selected data from the "Input" worksheet.
I used the "Match" function to identify the selected process with the
appropriate column in the (OPS) worksheet but can't figure out how to
associate the selection and corresponding data in order to move it to the
first blank row of the "OPS" spreadsheet.

--
dhunter43
The Performance Advantage, LLC