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
|