Hello,

I tried to make I useful file for myself to work but I'm confused.
I would like created something dynamic with excel, but I don't knof if macro or data validation would be better?
I discovered data validation this week and is it preferable to be able to do this with excel functionality or using macro with vba...

I have a file with some data but I don't know how to manage it to do what i want!

First, I would like to add value from colums B into 3 differents columns (F,G,H) but the value from column A will decide which one (F,G or H).

Secondly, I would like with a drop down or combobox be able to see the data from the 3 differents columns (F,G,H from sheet scope) into a new sheet (version ...)

This is files with some comments : test1.xlsm

If anyone could give me an advice, for the best start?

Do not hesitate to ask me to have more explaination about what I would like to do.

Many thanks