build data in Column A,b,c,d from two dropdown

[mazan2010]

i would like to build data in Column A,b,c,d in qualif sheet according to two dropdown menu
in my example when i select value in dropdown in H2 they put this selection in column A and complete Column B from Column K then allow to select more data from Column H without delete previous
i would like to know if can done by formula or vb code
then transfer the data from column A,B,C,D in Qualif sheet to result sheet in my example of attached file
best regards

[Bernie Deitrick]

I replied with this, to your other post:

1) Copy this code.
2) Right-Click the sheet tab 'qualif'
3) Select "View Code"
4) Paste the code into the window that appears.
5) Save the file as a macro-enabled .xlsm file.

When there is a value in M2, then when H2 changes the table will be extended and the data will be transferred to the result sheet. I just wasn't sure how the date was determined, so I just used the current date.

Please Login or Register  to view this content.

[alansidman]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.