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!
Put this in cell A1 of sheet2 =Sheet1!A:A then copy down to all needed cells.
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
Thanks, but if I do that, I have to drag the formula in Sheet2 with extra cells in case I add new rows in Sheet 1, because if I don't and I only drag the amount in the Sheet1, 20 rows for example, when I add a row in Sheet1, the last row in Sheet2 will dissappear.
Sorry, didn't notice that would happen and haven't figured out how to resolve it.
I got it! Put this formula in Sheet2 A1 =(Sheet1!A:A) then highlight column A on sheet2 and paste. This will add the formula to all the cells in column A. You may have to use CF to get rid of the 0's on sheet 2
Last edited by gmr4evr1; 02-03-2015 at 08:31 PM. Reason: Added CF sentence
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks