Hello,
I have multiple vendors that sell a list of products.
I send each vendor a spreadsheet to update their list of products on a weekly basis (fields are product#, price, quantity). The vendors might add, delete or modify rows.
I would like a master spreadsheets that lists all products from multiple vendors. Can I link multiple vendor spreadsheets to one spreadsheet to give me one comprehensive list (without copying and pasting each week)?
Thanks
Bookmarks