When I do a "go to" search for cells within a column that have formulas in them and then choose copy, when I paste the data, it comes up in a column of data starting in the first cell I choose to paste into. I want the formulas to past into the SAME rows as they were in the original column. How do I do this?
I find the description confusing:So far, so good. That sounds like exactly what is supposed to happen. The stuff you copied is pasted into the cell you select for paste.Originally Posted by Santana20
Before doing the paste, select the cell in the destination column that is in the same row as the start of the copied selection. But that answer sounds so obvious, that I may not be understanding the question. There is nothing fundamentally different about selecting a range for copy using Go To vs. using any other method.I want the formulas to past into the SAME rows as they were in the original column. How do I do this?
Last edited by 6StringJazzer; 03-09-2010 at 02:04 PM.
Making the world a better place one fret at a time
||||||
If someone helped you, please click on the star icon at the bottom of their post
If your problem is solved, please update the first post:
EDIT, Go Advanced button, set Prefix to SOLVED
[code]
' Enclose code in tags like this
[/code]
Don't attach a screenshot--just attach your Excel file! It's easier and will let us experiment with your data, formulas, and code.
Let me clarify: I use go to to find the cells in a long column that i want to copy. When I paste them into a new column, they past one after another in consecutive rows (ie: A1,A2,A3,A4,A5,etc.). I want them to show up in the same rows that they were in originally (maybe A1,A100,A115,A189, and so on) leaving the other cells alone. How do I do this?
Last edited by shg; 03-09-2010 at 04:16 PM. Reason: deleted spurious quote
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks