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

  • Thread starter Thread starter Pivotrend
  • Start date Start date
P

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
 
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 ?
 
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?
 
Pivot

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

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

Gord Dibben Excel MVP
 
Back
Top