To capture data from one worksheet to another in the same workbook you
might want to try a code range formula. This works when you can
identify several values that need to be captured, either in total or
individually from one page to another. However the more individual
numbers you have the more codes you need.
Your worksheet identifies individual costs associated with a project.
Project A
Labor hourly $35,000
Labor salary $25,000
Concrete $11,000
Wire $4,000
Next, in the next column,first label it "Code", then give each value a
code. Labor hourly code 1, Labor Salary code 2, Concrete code 3, wire
code 3. These codes can be associated with each cost center. Next
define the range for both Total and Code columns. You do this by going
to Insert->Name->Define. Enter the name you wish to define and click
the little icon in the refer to box. THis will identify the range to
search for your data.
On your next worksheet page you may want a total for each cost center.
In the first column you identify the code associated. Next column your
description. In you total column your formula would be
=ROUND(SUMIF(Code,$A8,1st worksheet total column),0), where $A8 is the
code on your current worksheet in the first column, "1st worksheet" is
whatever your worksheet data name is. You do not have to round. This is
a great way to automate.
C Craig
