Lookup and transfer data from one excel sheet to another.

Jbouss · #1 02-02-2024, 03:01 PM

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