Hi all,

I'm having a bit of trouble and I'm not sure if what I want to do can be done but any thoughts or help would be greatly appreciated.

I'm trying to shift data from one table in Excel 2007 to another on the same sheet based on a condition.

The main table is to keep track of company projects. It has the following columns: Project Name; Owner; Began; Due; % Complete; Completion Date; Time Taken.

As time goes on I expect this list to be pretty long and that most of the projects will be at 100% in the % Complete column.

What I'm trying to do is seperate the projects that aren't completed to a seperate table, bringing with them just the corresponding data for Project Name and Due. That way each person will have a list of all the projects that are outstanding, and there will be a full list of all the projects that are completed as well.

As I said above, I'm not sure if this can be done and I haven't had much luck looking at other threads to find an answer.

Thanks for any help.

Cheers

Pete