Hi,

I need a solution to a problem, I can’t understand how do I do it.

Everyday, I get a summary sheet with more than 1000 entries, and I have to enter it into the system. Each time I feed the entry into the system, I enter the system generated no. in the 'Receipt No.' column which is otherwise blank for all entries.

So what I want is that, my sheet with all entries be copied into the second sheet automatically, and only the unaccounted entries i.e. the entries where I have not entered anything in the first original sheet be displayed in the second sheet.

It would be better if it could be done automatically, without using any command or running any macro everytime to get the results. Want the data to refresh automatically.

Any help would help. Pls help urgently.

A part of sheet attached for reference.

Thanks.

issue.xls