Dropdown menu cell connection help!

[BrendanO]

Hi everyone,

I have one worksheet that tracks data from other worksheets in excel. The first worksheet is used as a summary of what's going on in the other worksheets. I am trying to connect a cell in the first worksheet to a cell in another worksheet but the cell in the other worksheet contains a drop down list and an error message is coming up when I try to connect the first (main) worksheet cell to it. Anyone know how to help? Thanks!

 

[ArthriticPanda]

Hi BrendanO,

If the drop-down list is a validation list, then it should be a case of in your summary sheet, type in the cell you want to pull the data through:

=Sheet2!A1

This is where the drop-down in in cell A1 on sheet2

AP