Should be easy but I haven't found any answer to this.
Column A of Sheet1 is a list of product names. The rest of the columns in Sheet1 have information about the product.
I want to have an inventory in Sheet2 of all products contained in Column A of Sheet1.
How can I link Column A of Sheet 2 with Column A of Sheet 1 so that if I insert a new product in Sheet1 that row will automatically appear in Sheet 2?
Thanks!
Bookmarks