Dynamic Form Entry...

Options

Hi there -

I'm curious if there's a way to have the data entered via a form added to a specified sheet that's selected from a field... All the sheets would be created from a template.

Example)

--Select Job#--

^(Drop-down menu that dynamically updates with all Sheet names contained inside a folder)

--Select Part#--

^(Drop-down menu that dynamically updates with selected Sheet's left-most column's contents)

--Modify Fields--

^(All fields w/ existing data are locked, blank fields are editable)

Tags:

Best Answer

Answers