I created a dropdown list using the data define range from sheet 1 column B to sheet 2 column B. However I would also like the data from several of the cells on that same row to transfer to sheet 2 on the same row.
for instance on sheet 1 I have tools listed in column B with cutting speeds on column C and material on column D. On sheet 2 I have jobs where I need to pick that tool and I would like to transfer the cutting speed and material from sheet 1 that goes with the tool.
On my drop down list I pick the tool.