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