Hi,

You could write a formula or use a macro. In the formula approach you are
not really copying the data you are connecting to it. Here is the formula
idea:

Suppose your data starts in A1 of the first workbook and in A5 of the second
workbook. Then open both files and tile the windows so you can see both.
Then in A5 type
=If(
and then click over to the other file and select cell A1
type
="","",
And then click in the second workbook on cell A1 again, press Enter.
Copy this formula down and over as far as desired.

The resulting formula will look something like this:

=IF('[Capactiy Tracking Formulas.xls]Supply Detail & Demand
Summary'!$A$1="","",'[Capactiy Tracking Formulas.xls]Supply Detail & Demand
Summary'!$A$1)

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"shriil" wrote:


Hi

I had posted my question in one of other Excel groups but haven't got
a solution yet. So am trying out here too.

I receive an Excel file from my Materials dept on a regular basis 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 function by which after I open the first Excel book,
Excel understands the range of cells in which data is there and copies
the particular range of cells for pasting it to the 2nd Excel file.
For eg. if the initial data was in A1:C3, Excel copies this particular
range. Say, after three days, there have been two more entries, and
thus the data range is now A1:C5. The function now copies Range
("A1:C5")..

Thks for the help

Shriil