Transfer and Organise Data

[Sam J]

Hi,

I need some help. I have attached a document. I want to created a separate table on 'Sheet 2' which contains the same information but organises the 'Days Left' column into ascending order (obviously moving all row data together), and doesn't include the rows which have an entry in the 'Date Completed' column. I also want the Sheet 2 table to automatically continue to add information as more rows are entered on the Sheet 1 table. Can anyone help me?

[JBeaucaire]

1) Right click the sheet2 tab name and select VIEW CODE
2) Paste in the activation macro to the VBA module that appears:

Please Login or Register  to view this content.

3) Close the VBEditor and save your workbook.
4) Make some changes/additions to sheet1
5) Activate sheet2 and the table will appear automatically.

6) Go to sheet1 and fill in all the cells in D so there are no empty cells in the table
7) Activate sheet2 and you'll get a message that there are no outstanding items.