Hi,
i'm newbie on vba excel
I would like to copy some range on selected sheet to another sheet, and defined the range with value from another sheet
i'll give the illustration below :
SheetA
<tbody>
</tbody>
SheetB
<tbody>
</tbody>
I want to copy selected range from SheetA to new Worksheet SheetC,
with specific value of Range that has been define at SheetB
So what i have to do ?
thank you
i'm newbie on vba excel
I would like to copy some range on selected sheet to another sheet, and defined the range with value from another sheet
i'll give the illustration below :
SheetA
A | B | C | D | E | |
1 | 100 | 400 | 700 | 1000 | 1300 |
2 | 200 | 500 | 800 | 1100 | 1400 |
3 | 300 | 600 | 900 | 1200 | 1500 |
<tbody>
</tbody>
SheetB
A | B | |
1 | A1 | |
2 | D2 |
<tbody>
</tbody>
I want to copy selected range from SheetA to new Worksheet SheetC,
with specific value of Range that has been define at SheetB
So what i have to do ?
thank you