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.
Bookmarks