You might to try this sample from my free archives for some relevant ideas:

http://savefile.com/files/1267592
Auto-Ordering to Diff Vendors.xls

It's a pure formulas driven play which dishes the order lines out
automatically from a mastersheet to various vendor sheets
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,500 Files:358 Subscribers:55
xdemechanik
---
"Jesse" wrote:
Can you give an example of a nested if formula that would work?