copy/paste value from a dropdownlist

[trekkeur50]

Hello,

I would like to copy/paste each values from a file from a dropdown list in a new file.
The name of each sheet would be the name of the value of the dropdown list

Actual file : board with a dropdown list
Final file : New file with sheets for each value from dropdown list

I hope i was clear enough to be understand

Thanks for your help

[PCI]

Reviewing your file, in fact you want to pepare a new file with a sheet for each "Magasin" from sheet "base de données" and for each of these sheets to have the corresponding values from sheet "Magasin" like autofilter do , is not it ?

[PCI]

Just to start ... macro will come later see file attached with Pivot Table

[trekkeur50]

Exactly right
Congratulation for understanging me

[PCI]

Do you need a macro or is it good enough ??

[trekkeur50]

PCI I need a macro

[trekkeur50]

PCI it will be difficult to use Power pivot.My example is very simple but in reality my file is more complex (a lot of formulas) and my level with power pivot is very low.If you have an idea with a macro, it will be great

[PCI]

See file attached.
Adjust to your needs

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[PCI]

(a lot of formulas)

Is there formula in sheet "base de données" ?????

[trekkeur50]

Great.Thanks a lot

[trekkeur50]

Formulas are in sheet

[PCI]

Formulas are in sheet

Which one ??

[trekkeur50]

sheet "synthese"

[PCI]

sheet "synthese"
Okay, so the copy paste from sheet "base de données" is working properly.
Still keep in mind the use of Pivot Table, it is really more flexible and dynamic that formulas ...!

[trekkeur50]

i try to learn power query , power pivot but i have some difficulties to create some formulas in power table after.
I like your message at the end of the macro

[PCI]

To finish the job, here a macro to sort data, to have the same display for each Magasin

Please Login or Register  to view this content.