View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Kuba[_2_] Kuba[_2_] is offline
external usenet poster
 
Posts: 1
Default VBA Index / match type formula copying formulas, not values

Yes, I have two tables with almost the same row and column labels, which may be in different order. It is an input sheet for a financial model, which is connected to numerous sources. What I am after is not to link the new sheet to the old sheet, but to copy the formulas (i.e. links) of the old sheet into the respective places of the new sheet