I am doing a spreadsheet that has twenty tabs and one master (where I collect
all the data from the info entered into each tab). I need to copy the first
formula on the master down the column to reflect the data in each tab. I
have set up the formula that keeps the cell constant, but can't get the tab
number to change when copied. i.e., Tab1, c12; Tab 2, C12, Tab 3, C12, etc.
Every time I copy the link down the column, tab 1 stays as tab 1. What to
do?
--
JDF