Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 28th 07, 12:53 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2007
Posts: 4
Default Copy/Pasting formulas

My formula is =PH1!A25 for one cell on my worksheet. I need the same formula
in the other cells in my column. When I do that I get the following in the
cells I pasted to....

=PH1!A26
=PH1!A27
=PH1!A28 and so on.

Is there a way to copy the formula and have it count like this....

=PH2!A25
=PH3!A25
=PH4!A25 and so on.

Any and all help is very much appreciated.
=PH1!A25

  #2   Report Post  
Old March 28th 07, 01:11 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 1,047
Default Copy/Pasting formulas

Hi Rizing,

I not sure, if I understand wath are you looking for, but try it:

=indirect("ph"&lin(a1)+1&!"&"$A$25")

copy it down

hth


--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Rizing" escreveu:

Thank you so much Kristin. That solved half of my problem. The PH1 part of
the formula refers to the name of the worksheet, which I assume you knew
already, but I would like to be able to paste and have that change.

Example: =PH1!$A$25 copied from cell A1 to A2 to A3.... will return the
following

=PH1!$A$25
=PH2!$A$25
=PH3!$A$25





"Kristin Broggi" wrote:

If you put a $ before the A and another before the 25 it will make that cell
an absolute reference - see below
=PH1!$A$25
Then copy it and you should be all set.

"Rizing" wrote:

My formula is =PH1!A25 for one cell on my worksheet. I need the same formula
in the other cells in my column. When I do that I get the following in the
cells I pasted to....

=PH1!A26
=PH1!A27
=PH1!A28 and so on.

Is there a way to copy the formula and have it count like this....

=PH2!A25
=PH3!A25
=PH4!A25 and so on.

Any and all help is very much appreciated.
=PH1!A25

  #3   Report Post  
Old March 28th 07, 01:18 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 18
Default Copy/Pasting formulas

If you put a $ before the A and another before the 25 it will make that cell
an absolute reference - see below
=PH1!$A$25
Then copy it and you should be all set.

"Rizing" wrote:

My formula is =PH1!A25 for one cell on my worksheet. I need the same formula
in the other cells in my column. When I do that I get the following in the
cells I pasted to....

=PH1!A26
=PH1!A27
=PH1!A28 and so on.

Is there a way to copy the formula and have it count like this....

=PH2!A25
=PH3!A25
=PH4!A25 and so on.

Any and all help is very much appreciated.
=PH1!A25

  #4   Report Post  
Old March 28th 07, 01:56 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2007
Posts: 4
Default Copy/Pasting formulas

Thank you so much Kristin. That solved half of my problem. The PH1 part of
the formula refers to the name of the worksheet, which I assume you knew
already, but I would like to be able to paste and have that change.

Example: =PH1!$A$25 copied from cell A1 to A2 to A3.... will return the
following

=PH1!$A$25
=PH2!$A$25
=PH3!$A$25





"Kristin Broggi" wrote:

If you put a $ before the A and another before the 25 it will make that cell
an absolute reference - see below
=PH1!$A$25
Then copy it and you should be all set.

"Rizing" wrote:

My formula is =PH1!A25 for one cell on my worksheet. I need the same formula
in the other cells in my column. When I do that I get the following in the
cells I pasted to....

=PH1!A26
=PH1!A27
=PH1!A28 and so on.

Is there a way to copy the formula and have it count like this....

=PH2!A25
=PH3!A25
=PH4!A25 and so on.

Any and all help is very much appreciated.
=PH1!A25

  #5   Report Post  
Old March 28th 07, 01:58 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2007
Posts: 4
Default Copy/Pasting formulas

Well Marcelo, I copied and pasted the formula you have below and that is
exactly what I see in the cell. Maybe I did something incorrect??

Thank you for your input though.

"Marcelo" wrote:

Hi Rizing,

I not sure, if I understand wath are you looking for, but try it:

=indirect("ph"&lin(a1)+1&!"&"$A$25")

copy it down

hth


--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Rizing" escreveu:

Thank you so much Kristin. That solved half of my problem. The PH1 part of
the formula refers to the name of the worksheet, which I assume you knew
already, but I would like to be able to paste and have that change.

Example: =PH1!$A$25 copied from cell A1 to A2 to A3.... will return the
following

=PH1!$A$25
=PH2!$A$25
=PH3!$A$25





"Kristin Broggi" wrote:

If you put a $ before the A and another before the 25 it will make that cell
an absolute reference - see below
=PH1!$A$25
Then copy it and you should be all set.

"Rizing" wrote:

My formula is =PH1!A25 for one cell on my worksheet. I need the same formula
in the other cells in my column. When I do that I get the following in the
cells I pasted to....

=PH1!A26
=PH1!A27
=PH1!A28 and so on.

Is there a way to copy the formula and have it count like this....

=PH2!A25
=PH3!A25
=PH4!A25 and so on.

Any and all help is very much appreciated.
=PH1!A25



  #6   Report Post  
Old March 28th 07, 05:04 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 3,718
Default Copy/Pasting formulas

Try this:

=INDIRECT("'"&"PH"&ROW(A2)&"'!$B$25")


"Rizing" wrote:

Well Marcelo, I copied and pasted the formula you have below and that is
exactly what I see in the cell. Maybe I did something incorrect??

Thank you for your input though.

"Marcelo" wrote:

Hi Rizing,

I not sure, if I understand wath are you looking for, but try it:

=indirect("ph"&lin(a1)+1&!"&"$A$25")

copy it down

hth


--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Rizing" escreveu:

Thank you so much Kristin. That solved half of my problem. The PH1 part of
the formula refers to the name of the worksheet, which I assume you knew
already, but I would like to be able to paste and have that change.

Example: =PH1!$A$25 copied from cell A1 to A2 to A3.... will return the
following

=PH1!$A$25
=PH2!$A$25
=PH3!$A$25





"Kristin Broggi" wrote:

If you put a $ before the A and another before the 25 it will make that cell
an absolute reference - see below
=PH1!$A$25
Then copy it and you should be all set.

"Rizing" wrote:

My formula is =PH1!A25 for one cell on my worksheet. I need the same formula
in the other cells in my column. When I do that I get the following in the
cells I pasted to....

=PH1!A26
=PH1!A27
=PH1!A28 and so on.

Is there a way to copy the formula and have it count like this....

=PH2!A25
=PH3!A25
=PH4!A25 and so on.

Any and all help is very much appreciated.
=PH1!A25

  #7   Report Post  
Old March 28th 07, 02:48 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 1,047
Default Copy/Pasting formulas

yes, sorry for the mistake

lin is row in my excel in brazilian portuguese.


--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Teethless mama" escreveu:

Try this:

=INDIRECT("'"&"PH"&ROW(A2)&"'!$B$25")


"Rizing" wrote:

Well Marcelo, I copied and pasted the formula you have below and that is
exactly what I see in the cell. Maybe I did something incorrect??

Thank you for your input though.

"Marcelo" wrote:

Hi Rizing,

I not sure, if I understand wath are you looking for, but try it:

=indirect("ph"&lin(a1)+1&!"&"$A$25")

copy it down

hth


--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Rizing" escreveu:

Thank you so much Kristin. That solved half of my problem. The PH1 part of
the formula refers to the name of the worksheet, which I assume you knew
already, but I would like to be able to paste and have that change.

Example: =PH1!$A$25 copied from cell A1 to A2 to A3.... will return the
following

=PH1!$A$25
=PH2!$A$25
=PH3!$A$25





"Kristin Broggi" wrote:

If you put a $ before the A and another before the 25 it will make that cell
an absolute reference - see below
=PH1!$A$25
Then copy it and you should be all set.

"Rizing" wrote:

My formula is =PH1!A25 for one cell on my worksheet. I need the same formula
in the other cells in my column. When I do that I get the following in the
cells I pasted to....

=PH1!A26
=PH1!A27
=PH1!A28 and so on.

Is there a way to copy the formula and have it count like this....

=PH2!A25
=PH3!A25
=PH4!A25 and so on.

Any and all help is very much appreciated.
=PH1!A25

  #8   Report Post  
Old March 28th 07, 06:38 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2007
Posts: 4
Default Copy/Pasting formulas

No worries Marcelo!

"Marcelo" wrote:

yes, sorry for the mistake

lin is row in my excel in brazilian portuguese.


--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Teethless mama" escreveu:

Try this:

=INDIRECT("'"&"PH"&ROW(A2)&"'!$B$25")


"Rizing" wrote:

Well Marcelo, I copied and pasted the formula you have below and that is
exactly what I see in the cell. Maybe I did something incorrect??

Thank you for your input though.

"Marcelo" wrote:

Hi Rizing,

I not sure, if I understand wath are you looking for, but try it:

=indirect("ph"&lin(a1)+1&!"&"$A$25")

copy it down

hth


--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Rizing" escreveu:

Thank you so much Kristin. That solved half of my problem. The PH1 part of
the formula refers to the name of the worksheet, which I assume you knew
already, but I would like to be able to paste and have that change.

Example: =PH1!$A$25 copied from cell A1 to A2 to A3.... will return the
following

=PH1!$A$25
=PH2!$A$25
=PH3!$A$25





"Kristin Broggi" wrote:

If you put a $ before the A and another before the 25 it will make that cell
an absolute reference - see below
=PH1!$A$25
Then copy it and you should be all set.

"Rizing" wrote:

My formula is =PH1!A25 for one cell on my worksheet. I need the same formula
in the other cells in my column. When I do that I get the following in the
cells I pasted to....

=PH1!A26
=PH1!A27
=PH1!A28 and so on.

Is there a way to copy the formula and have it count like this....

=PH2!A25
=PH3!A25
=PH4!A25 and so on.

Any and all help is very much appreciated.
=PH1!A25



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
automatically copy formulas down columns or copy formulas all the HowlingBlue Excel Worksheet Functions 1 March 17th 07 12:11 AM
Copy and Pasting JZ Excel Discussion (Misc queries) 1 July 25th 06 04:31 AM
Pasting Formulas jacob Excel Discussion (Misc queries) 8 May 1st 06 09:51 PM
Pasting formulas Kris Excel Discussion (Misc queries) 1 September 15th 05 06:32 AM
Pasting numbers and formulas without pasting format. Dan Excel Discussion (Misc queries) 3 March 27th 05 03:47 AM


All times are GMT +1. The time now is 01:48 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017