Dear all,
In Sheet 1, A2 to A100 contains a list of numbers. I would like to do the following by creating a VBA:
1) Copy A2 to A100 from Sheet 1 to Sheet 2 at A2 to A100;
2) Add a text "DL" infront of the numbers in Sheet 2 after the above copying.
Appreciate for your expertise. Thank you.
Cheers,
YC
In Sheet 1, A2 to A100 contains a list of numbers. I would like to do the following by creating a VBA:
1) Copy A2 to A100 from Sheet 1 to Sheet 2 at A2 to A100;
2) Add a text "DL" infront of the numbers in Sheet 2 after the above copying.
Appreciate for your expertise. Thank you.
Cheers,
YC