Extract data to another sheet on daily basis from different sheets using macros

Hi,

I had attached two workbooks, one the source(Sample CBR) and another the destination(Sep...).

I want to extract the complete rows that contains the amount excess or shortage(i.e.>0) in the columns excess and shortage to the file Sep... and as per all columns in Sep..

The date is to be extracted from 1st sheet.and other data from 2nd sheet(C3R MIS).

The next day the source file will be another workbook with next day date and data but destination file remain the same and so on up to last date of the month.For next month the destination will be new file Oct...

Please help using macros.

Thanks in advance.

Hello,

I am waiting for reply.

Thanks and regards

Hi,

yet not replied.


Thanks and Regards


Mahesh

Hi,

I don't understand that why my thread is replied.


Thanks again.


Mahesh

Hi Fotis1991,

Thanks for your reply.

I only want to copy the rows containing excess or shortage amount(I.e. row 6 contain shortage amount of rs.500 and row 6 and 12 contain excess amount of rs.7000 and 100 respectively).

The data may contain more rows with excess or shortage amount which is to be copied.

There is no condition for date.But everyday a new sheet will be opened and everyday the next day date is to be copied.That means that i want to copy rows every day to the September sheet up to last date of the month.

Again Thanks and regards.

Hi Fotis1991,

Waiting for your reply.

Thanks.