Copy a range of data and stop at 1st blank - to new template file VBA script XLS attached

Hi,

so always from the active worksheet or always from Sheet1 ?
And you can trash the actual code …

Originally Posted by Marc L

Hi,

so always from the active worksheet or always from Sheet1 ?
And you can trash the actual code …

Hi Marc,

Always from active worksheet would work great

So from the active worksheet that means the workbook can contain several worksheets, right ?
But in this case how the user should launch the VBA procedure ?

Originally Posted by Marc L

So from the active worksheet that means the workbook can contain several worksheets, right ?
But in this case how the user should launch the VBA procedure ?

Yes workbook contains several worksheets, I will launch similar to provided attachment. It will be launch by clicking on button.

So does that mean each worksheet has its own button ?

Originally Posted by Marc L

So does that mean each worksheet has its own button ?

Button only on sheet where data is

So the 'template' is only the worksheet where this button stands ?

Originally Posted by Marc L

So the 'template' is only the worksheet where this button stands ?

Yes, just that worksheet will have the button as in the attachment in 1st post

Here is an option for you. Since there is no filtering by row, we can do a straight copy and paste to a new workbook. If there is some data selection process, I can update the code. Let me know.

Please Login or Register  to view this content.

maniacb,

Works like a charm. I appreciate your help.