#1
|
|||
|
|||
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. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel, transfer data from Master Sheet to sub sheets, using key word from column | anvqui | Excel Programming | 9 | 06-16-2015 01:35 PM |
Data Transfer From Excel | spc94 | Word VBA | 1 | 06-03-2015 09:56 PM |
Transfer Data between Excel and Word | s_samira_21 | Excel | 0 | 01-19-2015 05:21 AM |
Is it possible to take a row on sheet 1 and transfer the info to sheet 2 by rows on conditions. | rogcar75 | Excel | 3 | 08-28-2014 05:21 PM |
Newbie to excel for starters, needing to transfer info from sheet2 to universe sheet. | rogcar75 | Excel | 0 | 08-12-2014 07:21 AM |