Have a worksheet listing products and prices for numerous suppliers.
eg.:

Supplier--Product---Price
ABC-------apple-----1.00
ABC-------orange----1.20
XYZ-------brick-----3.40
XYZ-------cement----0.80

This worksheet will change often.

What I would like is to reference this information on other worksheets.
I would also split the info onto a worksheet for each supplier.
Therefore i will have a worksheet for ABC and for XYZ, and the info in
these worksheets will change as the main "index" worksheet changes.

eg.
Worksheet ABC contains:

Product---Price
apple-----1.00
orange----1.20

Worksheet XYZ contains:
Product---Price
brick-----3.40
cement----0.80

have looked at formulas, but this seems messy. Is there a VBA method
that could automate this task?

Any thoughts/suggestions appreciated.


--
mupps
------------------------------------------------------------------------
mupps's Profile: http://www.excelforum.com/member.php...o&userid=28454
View this thread: http://www.excelforum.com/showthread...hreadid=480564