Replicate Userform transfer to Worksheet with selected values

[rakotonirinas]

Hello,

I have the following userform which has the purpose to transfer data from it to a workbook using the below macro, which is working fine.

EFH_4.PNG

Please Login or Register  to view this content.

Whilst this is working properly if, let's suppose, I have one entry at a time. However, I would like to prevent re-running the userform for more than 1 entry, which would be ultimately a very long process at the end.

Therefore I have added a combobox which will select how many row (entries/replications) from the same supplier I would like to have transferred (pasted) on the workbook (data) and this should not be more than 12 (the first entry included).

However, the first entry will always be the full transfer of the given data from the userform, that is, 10 different values from the userform pasted on the workbook. And when a number of replication is chosen, then only 7 userform values will be transferred onto the workbook from the subsequent transfer.

What should I do to execute this based on the number of selected replication (row)?

Here is an example of what I would like to achieve.

Thank you very much for your help and contribution. Much appreciated as always.

[rakotonirinas]

Anyone could give some indication of how I might do this? Much appreciated.

[rakotonirinas]

I was thinking, perhaps using the Do...Until loop may be a solution but not sure yet. Any help would be much appreciated. Thank you.

[sintek]

As the information passing to the sheet is a duplicate all you need to do is add a snippet of code that copies that entry which has just been passed - excluding certain columns - and pastes it filling down the no of selections less one...

No attachment so have nothing to work with...

[rakotonirinas]

Hi Sintek,

Oh yes, I like your suggestion and it does make more sense. How would I do the copy and paste by taking into consideration this code?

Please Login or Register  to view this content.

[sintek]

Upload a sample file...

[rakotonirinas]

A slim down version

[sintek]

Something like below...Also when making use of With always insert a point depicting...See red dots...Otherwise that code will refer to active sheet

Please Login or Register  to view this content.

[rakotonirinas]

Thanks Sintek, so do I have to add the syntax For ... Next for it to recognise how many time I would like it to be duplicated?

[sintek]

No...add the red part....

Please Login or Register  to view this content.

[rakotonirinas]

Hey Sintek,

Overall it is working but a slight issue: it is working when 2 and above is selected but then come back with error when it's 1 or nothing in the number of duplication (combobox 10).

Thank you

[sintek]

So....Make the selection only from 2-12 as 1 obviously defeats the purpose...
add red snippet...

Please Login or Register  to view this content.

[rakotonirinas]

I did the following which is working as well. Will test yours now as it's much shorter...

Please Login or Register  to view this content.

[rakotonirinas]

Dear Sintek,

Yours is much shorter and definitely better. Thank you ever so much for your help and contribution.

Best.

[sintek]

Pleasure...For future reference...
Tx for rep +

Please Login or Register  to view this content.

[rakotonirinas]

Brilliant ... Thanks