Same formula Entry , Series Of Cells!!!!!!!

[Pivotrend]

Hello Pros

how do i enter one formula in a series of Cells
like =Portfolios!H12
in A1
when i Copy A1 & Paste it in A2 it turns to =Portfolios!H13

but i want it to be the same =Portfolios!H12 in A1 to A80 Sam
Information

 

[Niek Otten]

Use

=Portfolios!$H$13

instead

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Pivotrend]

that saved me alot of Work And Time

i should have known it alot earlier

me N00B

 

[Pivotrend]

hey guys i need something else

can i copy A1 into B1

& when i Copy B1 into B2 , B2 will get the Information in A74
& B3 in A147

i mean i need the Information Lower 73 Cells Each Time i paste in B
Cells

is that Possible ?

 

[JMay]

Another way...
In B2 Enter =indirect("A74")
In B3 =indirect("A147")

Or

In B2 Enter =OFFSET($B$2,72,-1)
In B3 =OFFSET($B$2,145,-1)

Will that work for you?

 

[Pivotrend]

it didn't
is there other way

 

[Gord Dibben]

Pivot

Try this one entered in B2 and dragged down column B.

=INDIRECT("A"&ROW(A1)*74)

Gord Dibben Excel MVP

 

[Pivotrend]

that Worked properly
thanx

*Pivot

Try this one entered in B2 and dragged down column B.

=INDIRECT("A"&ROW(A1)*74)

Gord Dibben Excel MVP

 

[Gord Dibben]

Thanks for the feedback.

Gord

that Worked properly
thanx