?
Solved

Pasting same range of datas

Posted on 2016-10-07
7
Medium Priority
?
55 Views
Last Modified: 2016-10-26
i need the data in range A2:C10 to be pasted in to A11:C19 and again A20:C28 upto several hundred rows in this way? Can anyone help me?
0
Comment
Question by:Anu G
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
7 Comments
 
LVL 33

Accepted Solution

by:
Rob Henson earned 2000 total points
ID: 41833196
In A11 type formula:  

=A2

Copy across columns B & C. With A2 to C2 still selected highlight down to the last row you need populated and press Ctr + D. This will copy the formula down. Then you can press Ctrl + C top copy to clipboard. Then use Paste Special - Values to replace formulas with values.

Thanks
Rob H
0
 
LVL 33

Assisted Solution

by:Rob Henson
Rob Henson earned 2000 total points
ID: 41833217
And that is what that will do, assuming he fills down in groups of 9 rows.

A11:A19 becomes same as A2:A10
A20:A28 becomes same as A11:A19 which is same as A2:A10

etc etc
0
 

Author Comment

by:Anu G
ID: 41833219
thank you so much
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 33

Expert Comment

by:Rob Henson
ID: 41833220
@Koen - I see you deleted your comment.
0
 
LVL 8

Expert Comment

by:Koen
ID: 41833255
yeah, i was too quick... ;-)
0
 
LVL 33

Expert Comment

by:Rob Henson
ID: 41833395
If you are happy with the solution and have no further questions, please do not forget to close the question.

Thanks
Rob H
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question