• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Copy from a worksheet and paste to another worksheet

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
 

Attachments

  • Strip.xlsb
    377.6 KB · Views: 13
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.
 
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.
 

Attachments

  • For Ashok RFI STRIP CHART IPC-31.xlsb
    974.1 KB · Views: 16
Back
Top