In this spreadsheet test1 I have 5 worksheets. I want in the Master
worksheet to be the destination worksheet for the data in the other
worksheets. the data for the 3 columns MULT Contract Price.Point comes
from Type, Sales 01, Sales 02 & Pointer.
so in the master worksheet, the value of cell D1 should be from the CL
in cell C2 compared to the CUST CLASS column in worksheet TYPE. AND
worksheet SALES01 . I would like the CONTRACT AND PRICE POINT values in
the MASTER worksheet to come from SALES01. what do I need to do to
correct the formula that is in cell D2 and what do i need in cell E2 &
F2?
+-------------------------------------------------------------------+
|Filename: test1.zip |
|Download:
http://www.excelforum.com/attachment.php?postid=4653 |
+-------------------------------------------------------------------+
--
nander
------------------------------------------------------------------------
nander's Profile:
http://www.excelforum.com/member.php...fo&userid=6156
View this thread:
http://www.excelforum.com/showthread...hreadid=533891