Show data from one sheet to another if a condition is not true

**blazodragan** · 11-13-2012, 07:46 AM

Hi first I would like to thank you all, I've learned so much from this forum but for this problem I could not find what I was hoping for so here is my question .
I have a file where I keep all my task separated by project,what I need is for the tasks that are not completed from Sheet 2 / Column F (Progress not 100) to show up in Sheet1 starting from A2 , is it possible to do this with out using macros. If you ask yourself why I need this the file is used by several people for collaboration and we use skydrive to access it skydrive doesn't allow use of VB .

Thank you very much.

**Naveed Raza** · 11-13-2012, 10:17 AM

u need which is not completed progress till 100 that data need to copy to sheet 1 right and that data will not delete from sheet2 right.

**blazodragan** · 11-13-2012, 10:19 AM

Correct I just need the tasks that are not completed and yes I don't need the data deleted from sheet2

**Naveed Raza** · 11-13-2012, 10:25 AM

Hi Blazodragan,

ok and one more thing u need the project wise i mean to say project 1 data separate and project 2 data separate or else both should show in continuous way.

Thanks - Naveed.

**blazodragan** · 11-13-2012, 03:03 PM

Naveed Raza if they show up in a separate row it will be better but if that is not possible then I will be happy if they show continuously
Thank you for trying to solve this problem .

**Naveed Raza** · 11-14-2012, 04:53 AM

Hi,

Please have a review to this attached file and let me know if u have any question.

Thanks - Naveed.

**blazodragan** · 11-15-2012, 03:16 AM

Naveed Raza thank you for doing this it works perfectly it's still uses macro but we will edit the computer at the start of the day on one of our computers and then just move it to skydrive .
Thanks again for the work you put in to this project .

**Naveed Raza** · 11-15-2012, 05:59 AM

Hi,

Oh sorry I used Macro to get ur required data and i come back with ur solution without macro.

Please find the attached Updated Workbook and have a look and let me know if u any question.

Note: If u want to Insert rows then Copy the row & insert rows from middle ok otherwise u will not get accurate values.

Have a Nice Day ! :-)

Thanks - Naveed