Having said that there must be a way to copy data into an existing form with a single entry, i.e. if there are a number of employees with recurring training information set in a spread sheet it should be possible to copy that info into an existing form.
I understand that cells are identified by an alpha and numerical number A1, what I want to do is simply enter the number which identifies the line to the employee and have the fields on the form sheet auto populate. The formulas within the form sheet are written with the alpha portion of the applicable cell.
What I want to do is simply enter a number that corresponds with an employees line of data and it populates all areas of the form with a single entry to ease the repetition of filling out numerous forms manually.