Unanswered: Linking data from another sheet to a drop down list...
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.
Label |Drop Down|<--auto from B------------>
Any help would be great on this,
sometimes simple is best.... and i'm just a simple fellow.