Excel Bring Data From Another Sheeting Using Drop Down.

[russdev]

I am creating a spreadsheet (see attached for sample of what doing). On the welcome sheet I need in c1 a drop down box with info from row one on sheet data.

 

If select c under drop downbox shows content of column c. If select b get data listed under B.

 

Russell

 

eg template.xlsx

[mac_shinobi]

So you have a drop down menu which contains :

 

| A |

| B |

 

When you click on A it refreshes with all the items in Column A and the same if you select option B it will refresh with the options in Column B, currently there is no drop down menu in that spreadsheet but I am using 2003 not 2010 or 2007.

 

Also once you have selected an option how are you going to make it go back to the original options that were in the drop down ie A, B, C etc ?

[russdev]

That is why asking hope someone had a great idea. The idea is want them to be able to compare what is in d with other data but give them an easy way to select one column at time so that they do not have to keep searching the full data.

 

Russell

[mac_shinobi]

That is why asking hope someone had a great idea. The idea is want them to be able to compare what is in d with other data but give them an easy way to select one column at time so that they do not have to keep searching the full data.

 

Russell

 

If its just comparing two columns why not make the 3rd column have an if statement or something similar that compares them and if there is a difference highlight the cell in a certain colour ie light blue or green or something ?

 

Otherwise it will be right click in ribbon / grey area --> control toolbox --> add combo box --> code in vba for the different events and for the control to do what you need it to.

[russdev]

If its just comparing two columns why not make the 3rd column have an if statement or something similar that compares them and if there is a difference highlight the cell in a certain colour ie light blue or green or something ?

 

Otherwise it will be right click in ribbon / grey area --> control toolbox --> add combo box --> code in vba for the different events and for the control to do what you need it to.

 

 

Thanks I will have a play later...

[mac_shinobi]

Thanks I will have a play later...

 

Will it always be columns A and B or could it be more ?

[andy_b]

I may have misunderstood, but something like this?

eg template.xlsx

[russdev]

Andy you a star that is exactly what I want ...

 

Russ

 

 

Edit

 

Ok need to work out where doing the proccess for drop down (being stupid on a monday morning). As added in new column called d, added it to the drop down but when select the drop down it gives a ref error?

 

eg template (1).xlsx

Edited May 16, 2011 by russdev

[russdev]

Thanks to pm from Andy worked out needed to give new column a name range of column_e.