Hi
I may be going about this the wrong way, but not sure as i'm not too advanced on excel. I'm using data validation for three drop down menus, and within these are the named ranges. But the named ranges i want to use all have the same headers and so i cannot give the ranges the same name. If you have a look at the attachment, you should understand better. I need to be able to select one of the peachy coloured headers and in turn one of the green headers and then one of the sizes in white.
i need to input this data within cells A20 - A22 but the info is from column E onwards. Info is just on sheet 1, ignore the others.
Help would be appreciated!
Thanks
Pete
Bookmarks