View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Patti
 
Posts: n/a
Default Inserting rows, updating linked worksheet

Dear John,

Thank you so much for your very helpful reply.

I added a T function to the formula, and copied it down the sheet. It
worked beautifully!

=T(INDIRECT("Tracker!A"&ROW()))