This may be simpler than you think, or I am missing the point. Create the
master worksheet first, then the subsidiary worksheets within the same Excel
workbook. In each subsidiary, enter a cell reference to the master, such as
='Master'!B7. Then, when you enter new data in B7 of the master sheet, that
data will appear in the subsidiary sheet. Be sure to make the cell formats
the same in both sheets.

As to the batch numbers, you could create an IF instruction, such as: if the
batch number cell (in the Master) is not blank (or is greater than 0), enter
the data from Master B7 in a certain cell of the subsidiary worksheet.

"Frantic Excel-er" wrote in
message ...
Hi All...

I am wondering if (and how) this can be done.

I have several worksheets in one workbook that contains batch log
information. For each worksheet, it is categorized by country. I would
love
to have one master worksheet that I enter this data into, and then have
excel
populate the other worksheets with each respective data. This data is
updated continuously to make two billing cutoffs each month. I think it
would be super helpful to have this data all consolidated for filtering
and
subtotaling purposes....with that said, I would only want excel to
populate
the worksheets with line items that have the batch number attached....

Any suggestions???? If more detailed info is needed to solve this one let
me know....

Thanks,

Sara