Need a shortcut for copying formulas on a master sheet that gets .
 

Hello,
I am creating a workbook that will consist of over 100 sheets plus a master
sheet that will contain values carried over from these 100+ sheets. Each row
on the master represents data from the individual sheets. There are 8
columns of data in each row. The cell references are the same for all
sheets. I don't want to build over 800 formulas from scratch. Is there an
easy way to copy & paste the formulas in one row and have the system keep the
cell refereneces the same? and, in addition, is there an easy way to then
change the reference to the sheet name? The cell data being transferred is
an X or a blank (don't know if this matters.) Any ideas? Thanks. Maureen.

Need a shortcut for copying formulas on a master sheet that gets .
 

Try

http://www.rondebruin.nl/summary.htm
and
http://www.rondebruin.nl/summary2.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl



"mlatkovich" wrote in message ...
Hello,
I am creating a workbook that will consist of over 100 sheets plus a master
sheet that will contain values carried over from these 100+ sheets. Each row
on the master represents data from the individual sheets. There are 8
columns of data in each row. The cell references are the same for all
sheets. I don't want to build over 800 formulas from scratch. Is there an
easy way to copy & paste the formulas in one row and have the system keep the
cell refereneces the same? and, in addition, is there an easy way to then
change the reference to the sheet name? The cell data being transferred is
an X or a blank (don't know if this matters.) Any ideas? Thanks. Maureen.