Copy from a worksheet and paste to another worksheet

[ashokkumarkolla]

Hi,

In work sheet named "bar chart" i have data in range C1:UFX4

I have to paste special the values in the above range to following ranges in worksheet named "Highway Strip Chart".

C6:BA9
C16:BA19
C26:BA29
C36:BA39
.....
upto...
C2826:BA2829

uploaded the sample file for your reference.

Request your support for vba macro to automate this part.

Thanks
Ashok

 

[AlanSidman]

Your range of data in your thread bears no resemblance to your worksheets. Please provide a worksheet example that shows a before and after scenario that matches your post requirements.

 

[ashokkumarkolla]

Hi,

Attached the file with data.

Thanks
Ashok

 

[ashokkumarkolla]

Hi,
May be i didn't explained clearly.

In work sheet named "bar chart" i have data in range C1:UFX4

I have to paste special the values in the above range to following ranges in worksheet named "Highway Strip Chart".
Brachart ----> Highway Strip Chart
C1:BA4 C6:BA9
BB1:CZ4 C16:BA19

like that.

steps i am following:
1. Select the cell C1 in "barchart"

2. Copy values in range "51 columns and 4 rows".

2. paste the values at cell C6 in "Highway Strip Chart"

3. Select the cell CZ1 in "barchart"

4. Copy values in range "51 columns and 4 rows".

5. paste the values at cell C16 in "Highway Strip Chart"

up to the end of range C1:UFX4 in "barchart"


Attached the modified file for your review.