Disperse one worksheet into several...

[Guest]

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

 

[DNA]

Yes it can. In Excel, bring up Help and type the following in for your
search criteria:

"Create a link to another cell, workbook, or program"

 

[Richard Neville]

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.

 

[Guest]

I would like for this to be an automatic thing....such as have a macro that
will do this for me....I don't want to have to verify that each time I do my
spreadsheet the formulas are copied into each cell. Also, it isn't as
simple as it seems because I have several columns of data pertaining to one
batch that I need copied from the master to the subsidairies.