Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Disperse one worksheet into several...
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 |
#2
|
|||
|
|||
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" |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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. "Richard Neville" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to search for and display data in another worksheet | Excel Worksheet Functions | |||
Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
Indirect reference from one worksheet to another | Excel Worksheet Functions |