Hi, I'm using MS Excel 2010. I would like to have a workbook with 2 Tabs (Tab1 and Tab2). Tab1 contains 10 columns. Tab2 only has column 1, 3 and 5 (the exact same data as in Tab1). I would also like to be able to add data to a cell of column1, 3 or 5 in Tab1 and have it update in Tab2.
Thus, if I added data to a new cell in (Tab1, Column3), I would like to see it available when I switch to Tab2.
How would I link my columns (i.e. column 1, 3 and 5) from Tab1 to Tab2?