Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

share|improve this question

migrated from stackoverflow.com Dec 20 '13 at 19:02

This question came from our site for professional and enthusiast programmers.

    
You want to do it in one single entry. Can you show the code you used to make it in multiple entries? –  stenci Dec 19 '13 at 14:19

1 Answer 1

That is extremely basic excel functionality - The number of ways to accomplish this are too numerous to list - one of the ways you can accomplish what you are trying to do is with a VLOOKUP function. For future reference - this question probably belongs on superuser - you will get better responses there. I'm going to flag it as such. Example is below:

1

2

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.