Link to combo box selection

[PhilSM]

Is it possible to link between two workbooks so the selected value from the combo box in one is then displayed in another workbook ?

[royUK]

You would need to specify which workbook & sheet to write to. Can you xpnd your question with some more detail?

[PhilSM]

Sorry probably didn't make what I'm trying to do very clear.

In worksheet A the user will type lots or product data into various cells. They will also use a couple of combo boxes to make a selection.

In another worksheet B I link to the cells I need to summarise the full data in A but also need to pull across what they selected in the combo box.
Pulling data from a cell is obviously very easy but I cannot figure how to get the combo info.

Thanks

[royUK]

This is more confusing is one workbook or two?

Attach an example

[PhilSM]

Sorry two workbooks.