|
|
#1
02-02-2024, 03:01 PM
|
|||
|
|||
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. 
|
|
| Thread Tools | |
| Display Modes | |
|
|
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 |
Windows 10 
Office 2021
Linear Mode
