Windsinc
New Member
- Joined
- Feb 10, 2004
- Messages
- 15
Hello ALL!
Since I have learned validation thanks to the wonderful people here, I decided it was time to move up a step and automate some of my work. So here I go again. ray:
I have a main data wksheet that has about 40 columes(fields) each with its own name, 500 rows in each colume of main data of different types like names addresses, rates etc, in a workbook.I have another wksheet in the same wkbook which is laid out as a form type (called load info) entries top to bottom in columes, where I have the data validation which pulls from the list of data on the main data sheet. I have a unique id number for each shipper, broker,receiver. truck trailer and load. Can I use v lookup or h lookup to auto fill the information on the load info sheet since I have unique id numbers?The main data sheet information changes almost daily. There are formulas in the load info sheet as well as validation.
Trish
Excel Trainee soon to be crazy
Since I have learned validation thanks to the wonderful people here, I decided it was time to move up a step and automate some of my work. So here I go again. ray:
I have a main data wksheet that has about 40 columes(fields) each with its own name, 500 rows in each colume of main data of different types like names addresses, rates etc, in a workbook.I have another wksheet in the same wkbook which is laid out as a form type (called load info) entries top to bottom in columes, where I have the data validation which pulls from the list of data on the main data sheet. I have a unique id number for each shipper, broker,receiver. truck trailer and load. Can I use v lookup or h lookup to auto fill the information on the load info sheet since I have unique id numbers?The main data sheet information changes almost daily. There are formulas in the load info sheet as well as validation.
Trish
Excel Trainee soon to be crazy