Copying cell formulas to another workbook?

  • Thread starter Thread starter Ralph K
  • Start date Start date
R

Ralph K

I have a workbook with one sheet for basic product data & general
prices. A second sheet contains a list of all my customers with
customer-specific discounts and price incentives. Sheet #2 uses a UDF
to compute the "bottom line" quote for each customer and serves as a
source file for a Word mail merge.

Other than cloning this workbook and killing the customer data, is there
a way to copy and paste the formulas into a new workbook? All I'm
getting is a copy of the formula results, not the formulas themselves.
 
You could make a template if the sheets are to be the same.
You can copy the entire sheet
If you want the structure of a sheet with the formulas and with
the contants removed you can use a macro.
-- I think you excluded those though.

You might find Chip Pearson's posting of interest
http://google.com/groups?threadm=uiqh89AxAHA.1620@tkmsftngp05

he may have a web page perhaps search for context and formula
Chip's web pages are at http://www.cpearson.com/excel/topic.htm

or more links to additional material related to his original posting at my
Right-Click Context Menus in Excel
http://www.mvps.org/dmcritchie/excel/rightxl.htm
 
Back
Top