Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formulas copying from sheet to sheet | Excel Worksheet Functions | |||
Copying (Master) column to another sheet to automatically update | Excel Worksheet Functions | |||
Shortcut for copying formulas referencing different worksheets | Excel Discussion (Misc queries) | |||
Copying a sheet, but preserving the formulas | Excel Programming | |||
Copying Sheet with Formulas | Excel Programming |