Pastespecial for different cases

[Vladi108mb]

Namaste Gurus of VBA macro excel.
I am using this code:

Please Login or Register  to view this content.

To copy data from one sheet to another.
1) But cases are more than 50.
2) C51, E31 don't change for all these 50 cases.
3) But Q04 change... for case "1" correspond Q04, for case "2" correspond Q05
and in this way... 3 ----- Q06, 4 --- Q07...

There is maybe a "Magic Code" that can use for no write 50 times the same structure?

Thanks for your help.

[mjr veverka]

Ad 1. IF "C51, E31 don't change for all these 50 cases" AND "cases are more then 50" THEN when do the values of C51, E31 change ?
Ad 2. Attach some sample xls file

[Vladi108mb]

oH! Sorry for no clear explanation.
When I said that C51 31 doesn't change I am talking about Structure, but the data inside of these cells can change.
Different situation with the Range Copy Q06, Q07, Q08... etc

Attachment 710709

You can see the button and cell for change case 1 to more than 50
I am attaching the excel file from my google drive because the attach option is not working well here.

https://drive.google.com/file/d/1Uiv...ew?usp=sharing

You can see that I must copy data from a list of users for generating INVOICE

Thanks for your help.

[mjr veverka]

... because the attach option is not working well here ...

It works fine when you follow the description in the yellow bar (named "HOW TO ATTACH YOUR SAMPLE WORKBOOK:") between ["Forum => Microsoft Office Application Help - Excel Help forum => Excel Programming/VBA/Macros => Pastespecial for different cases"] and ["Post New Thread/Reply To Thread"] at the top of the www page ...

[mjr veverka]

Try - maybe I understood correctly ... maybe:
Without the "Select Case"

Please Login or Register  to view this content.