I am having some difficulty creating a formular to copy a cell value t
another only if a certain condition is met.
I am working on a wine cellar program and want to look at wines b
type, variety and calculate values.
I have produced a worksheet that links to another sheet used as a mai
database. I have used auto filter in this new worksheet to seperate th
types of wines I want to look at (red, white etc)
Now that I'm able to seperate the wines by type I want to know th
total value ot that type. I need a formular that saids
' If the type is red copy the value in cell X to cell Y. If the type i
white copy the cell X to cell Z.
Any help would be appreciated.
Thank

--
Message posted from http://www.ExcelForum.com