Remember Me?

#1
March 28th 07, 12:53 AM posted to microsoft.public.excel.newusers
 external usenet poster First recorded activity by ExcelBanter: Mar 2007 Posts: 4
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
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
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
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
March 28th 07, 01:18 AM posted to microsoft.public.excel.newusers
 external usenet poster First recorded activity by ExcelBanter: Aug 2006 Posts: 18
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
March 28th 07, 01:56 AM posted to microsoft.public.excel.newusers
 external usenet poster First recorded activity by ExcelBanter: Mar 2007 Posts: 4
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
March 28th 07, 01:58 AM posted to microsoft.public.excel.newusers
 external usenet poster First recorded activity by ExcelBanter: Mar 2007 Posts: 4
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
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
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
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
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
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
Copy/Pasting formulas

yes, sorry for the mistake

lin is row in my excel in brazilian portuguese.

--
regards from Brazil
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
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
March 28th 07, 06:38 PM posted to microsoft.public.excel.newusers
 external usenet poster First recorded activity by ExcelBanter: Mar 2007 Posts: 4
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
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
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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post HowlingBlue Excel Worksheet Functions 1 March 17th 07 12:11 AM JZ Excel Discussion (Misc queries) 1 July 25th 06 04:31 AM jacob Excel Discussion (Misc queries) 8 May 1st 06 09:51 PM Kris Excel Discussion (Misc queries) 1 September 15th 05 06:32 AM Dan Excel Discussion (Misc queries) 3 March 27th 05 03:47 AM

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