Show selected value from table in a seperate cell.

[martinp1]

Hi All,

Hopefully a simple one,

I have a table of deliveries from different suppliers, with varying columns. I select a specific supplier from the list (only ever one supplier at a time), then it shows all the products from this supplier, from 1 line to 20 lines for example.

I then have a different cell in the spreadsheet where I want to show the supplier selected. This is the part I'm struggling with! The supplier is always a number if this helps.

Thanks in advance!

Martin

 

[than_gold]

Could you please share with us one sample file?
Will help you on this.
Regards,
Thangavel D

 

[martinp1]

How can I upload a file? It tells me I don't have permission.

Thanks

 

[than_gold]

If its not allowing then you can try sharing the link of the sample file using google doc sharing?
Regards,
Thangavel D

 

[Joe4]

You cannot upload files to this site. But there are tools you can use to post screen images. They are listed in Section B of this link here: http://www.mrexcel.com/forum/board-a...forum-use.html.
Also, there is a Test Here forum on this board that you can use to test out these tools to make sure they are working correctly before using them in your question.