Solved

Pasting same range of datas

Posted on 2016-10-07
7
41 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
  • 4
7 Comments
 
LVL 32

Accepted Solution

by:
Rob Henson earned 500 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 32

Assisted Solution

by:Rob Henson
Rob Henson earned 500 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
Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

 
LVL 32

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 32

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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Suggested Solutions

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

785 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