Copy and paste

  • Thread starter Thread starter @Homeonthecouch
  • Start date Start date
@

@Homeonthecouch

Hi all,
I know this has got to be so easy I'm gonna kick myself when I see the answer but how do I copy a group of cells say
a1-a10 that have the following formula
A1=LEFT(H$293,J$293)
A2=LEFT(H$345,J$345)
A3=LEFT(H$153,J$153)
A4=LEFT(H$444,J$444)

Etc, etc....

I want to copy the formula so that I get the same results in c1-c10


Any help is appreciated.


Andrew
 
You need to have dollar symbols in front of the column identifiers (H
and J) so these do not change when you copy the formulae. Highlight
the cells A1:A10, then Edit | Replace (or CTRL-H):

Find what: H
Replace with: $H
Replace All

CTRL-H again:

Find what: J
Replace with: $J
Replace All

Then you can copy the cells to C1:C10.

Hope this helps.

Pete
 
Oh for goodness sake !!!!

Ever stared so much at something that it makes you completely forget the basics!! and the fact there's a 4 year old
terror in the house killing my vital brain cells :-), perhaps I should have asked her first :-) :-)
Thanks for that.

Andrew


You need to have dollar symbols in front of the column identifiers (H
and J) so these do not change when you copy the formulae. Highlight
the cells A1:A10, then Edit | Replace (or CTRL-H):

Find what: H
Replace with: $H
Replace All

CTRL-H again:

Find what: J
Replace with: $J
Replace All

Then you can copy the cells to C1:C10.

Hope this helps.

Pete
 
You're welcome, Andrew - glad to help.

Pete

Oh for goodness sake !!!!

Ever stared so much at something that it makes you completely forget the basics!! and the fact there's a 4 year old
terror in the house killing my vital brain cells :-), perhaps I should have asked her first :-) :-)
Thanks for that.

Andrew


You need to have dollar symbols in front of the column identifiers (H
and J) so these do not change when you copy the formulae. Highlight
the cells A1:A10, then Edit | Replace (or CTRL-H):

Find what:         H
Replace with:    $H
Replace All

CTRL-H again:

Find what:          J
Replace with:      $J
Replace All

Then you can copy the cells to C1:C10.

Hope this helps.

Pete







- Show quoted text -
Click to expand...
 
Back
Top