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