Excel - Possible to create a sorted view of a column in one sheet on another sheet?
- by Cumbayah
Hi;
I'm trying, in Excel 2007, to populate a column in one sheet with the data contained in a column on another sheet, so that I may provide another sorting on the data, related to that sheet only.
I've tried to boil it down to being able to have a column on sheet2 automatically being populated with all rows from a column in sheet1, but I can't seem to do so.
Any suggestions? Thanks in advance.