Thread: Copying Formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Copying Formula

=INDIRECT("'"&ROW(A29)&"'!$H$39")
and copy down.
--
David Biddulph

"dorinn" wrote in message
...
i have an problem with formula

i am trying to copy formula down but it seems it is not working

='29'!$H$39 in row 47 and i need
='30'!$H$39 in row 48 and so on

thanks