Lookup and transfer data from one excel sheet to another.
Hello All,
I am trying to create a unique form fillout system using two excel files. Lets call the form file form.xlxs, and the other file master.xlxs.
I would like to take a number, sequencially from a number column on the master.xlxs file to auto fill one cell on my form.xlxs sheet. Once a number is taken, I want it to be unavailable for use when the next form.xlxs file is created.
In addition to that. I want to take two cells information from my form.xlxs file and populate the two columns next to the associated number on my master.xlxs file.
Attached is a couple of crude exaples. Please let me know if I can provide any more details. I appreciate the help, this is my first post.
|