Hiya;

I'm not as well versed with excel as access, and have encountered a slight stumbling block i hope someone can help me with.

I have various bits of data all over a workbook (sheets 1 - 4) and I have the kew bits of data i need gathered from these other sheets on a master sheet (to hide) - This is sheet 6

What I am working on is sheet 5

in Col A - i have labels, col B has a drop down box that is linked to data in sheet 6

What I need are for the other fields C - K to auto-populate depending on what is selected in Col B

The data for the drop down, as i mentioned is stored in sheet 6, and the associted data is there also.


Eg:
===A====|===B====|====c===|====d====| ----->etc
Label |Drop Down|<--auto from B------------>

Any help would be great on this,

Dan

no need to reply now, i have done a lot of scouring the web today and found the solution... eventually.

looks what i needed was a vlookup formula...

dan