dlafrankie
New Member
- Joined
- Dec 5, 2005
- Messages
- 1
I have two spreadsheets. SHEET #1 is a table of information with approximately 400 rows and 10 columns (Lets call it THE DATABASE). The data is a listing of equipment numbers and specific associated equipment data on each row with the index being the equipment number in column A. The equipment numbers may or may not not be consecutive numbers and may not relate to the row number at all. I mean to say that equipment number 1 is not necessarily on row #1 in THE DATABASE.
My wish is to open Sheet #2 (Lets call it THE FORM) and enter an equipment number (index) in column A on any row and dynamically have the associated information for that equipment be filled into the same columns on THE FORM but be placed on the row in THE FORM where the Equipment number was entered. The data would be copied from THE DATABASE and placed into THE FORM on the row (in THE FORM) where I enter the EQUIPMENT number. I do not want to copy and paste. I want my entry of the equipment number into THE FORM bring the data from THE DATABASE and place into THE FORM on the row in the FORM where I enter the equipment number.
Your help is greatly appreciated. I hope I made this clear enough. If not please respond with further questions.
Thank You
Dave L
My wish is to open Sheet #2 (Lets call it THE FORM) and enter an equipment number (index) in column A on any row and dynamically have the associated information for that equipment be filled into the same columns on THE FORM but be placed on the row in THE FORM where the Equipment number was entered. The data would be copied from THE DATABASE and placed into THE FORM on the row (in THE FORM) where I enter the EQUIPMENT number. I do not want to copy and paste. I want my entry of the equipment number into THE FORM bring the data from THE DATABASE and place into THE FORM on the row in the FORM where I enter the equipment number.
Your help is greatly appreciated. I hope I made this clear enough. If not please respond with further questions.
Thank You
Dave L