View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tia Tia is offline
external usenet poster
 
Posts: 64
Default formula reference between worksheets

I have a workbook where Tab1 is a "reference" page, with each row of data
containing an associate record. In Tab2 - Tab50, I need to "plug in" the
same piece of information on a form copied from the prior tab. Currently I
will copy Tab2 to Tab3 and incrementally change the cell refence by 1. Rather
than change this manually, is there a formula or macro that can do this for
me?
--
Tia