I have an Excel file for keeping track of Purchase orders, whose
fields get populated progressively by date. The workbook contents is
similar to the following

Date Bin No. Order no.

02-dec-08 SB3241 SS/432

05-dec-08 SC1157 SX/201

07-dec-08 SB0134 SS/456

...and so on and so forth.
There is another Excel workbook where I copy and paste the above
contents. There are other fields in the 2nd workbook, used for
analysing the full data.

Now everytime a new date/or new Purchase Order gets populated in the
first Excel file, I copy that corresponding row/rows and paste it at
the desired location, just a row below from previously copied data in
the 2nd Excel file. So everytime, I have to check whether there is a
new entry in the first book, and then copy row by row to the 2nd excel
book.

Is there any way, by the help of a macro, where the code will
understand the data range in the First workbook and then select and
copies it to the 2nd workbook. If there are no new entries, the
program exists.

Thks for the help

Shriil

Hi

Turn on the macro recorder, and copy the new date manually, then post
the code here for further help.

Will there be more than one entry per date ? How is Book1 updated ?

On 6 Feb., 05:10, shriil wrote:
I have an Excel file for keeping track of Purchase orders, whose
fields get populated progressively by date. The workbook contents is
similar to the following

Date * * * * * * *Bin No. * * * Order no.

02-dec-08 * * SB3241 * * * SS/432

05-dec-08 * * SC1157 * * * SX/201

07-dec-08 * * SB0134 * * * SS/456

..and so on and so forth.
There is another Excel workbook *where I copy and paste the above
contents. There are other fields in the 2nd workbook, used for
analysing the full data.

Now everytime a new date/or new Purchase Order gets populated in the
first Excel file, I copy that corresponding row/rows and paste it at
the desired location, just a row below from previously copied data in
the 2nd Excel file. So everytime, I have to check whether there is a
new entry in the first book, and then copy row by row to the 2nd excel
book.

Is there any way, by the help of a macro, where the code will
understand the data range in the First workbook and then select and
copies it to the 2nd workbook. If there are no new entries, the
program exists.

Thks for the help

Shriil

On Feb 6, 9:29*am, Per Jessen wrote:
Hi

Turn on the macro recorder, and copy the new date manually, then post
the code here for further help.

Will there be more than one entry per date ? How is Book1 updated ?

On 6 Feb., 05:10, shriil wrote:



I have an Excel file for keeping track of Purchase orders, whose
fields get populated progressively by date. The workbook contents is
similar to the following

Date * * * * * * *Bin No. * * * Order no.

02-dec-08 * * SB3241 * * * SS/432

05-dec-08 * * SC1157 * * * SX/201

07-dec-08 * * SB0134 * * * SS/456

..and so on and so forth.
There is another Excel workbook *where I copy and paste the above
contents. There are other fields in the 2nd workbook, used for
analysing the full data.

Now everytime a new date/or new Purchase Order gets populated in the
first Excel file, I copy that corresponding row/rows and paste it at
the desired location, just a row below from previously copied data in
the 2nd Excel file. So everytime, I have to check whether there is a
new entry in the first book, and then copy row by row to the 2nd excel
book.

Is there any way, by the help of a macro, where the code will
understand the data range in the First workbook and then select and
copies it to the 2nd workbook. If there are no new entries, the
program exists.

Thks for the help

Shriil- Hide quoted text -

- Show quoted text -

There can be more than one entry per date. I have tried with the macro
recorder, but then whenever there is a new entry, I have to include it
in the Range. Is there any way that the macro can automatically
identify the Range of cells having data, each time it runs