No formulas?

"Allocate"?

Sorry, Cheer-Phil-ly, you speak in mysteries

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Cheer-Phil-ly" wrote in message
...
| Each row has information for an auto dealer such as current monthly volume,
| outstandings, etc along with the region (territory) where the dealer does
| business. Each month I update the info in each row and then have to allocate
| (spread) that dealers information to a worksheet for that particular region,
| so my managers can see only their volumne, outstandings, etc.
|
|
| "Niek Otten" wrote:
|
| Difficult to say without any formulas.
| What does "spreads it to regional sheets " mean?
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
| "Cheer-Phil-ly" wrote in message
| ...
| |I have a workbook (using Excel 2002) that takes the data on the worksheet
| | "AllDealers" (960 rows x 112 cols) and spreads it to regional sheets (16 in
| | all). This process (on my machine usually takes about 4-6 minutes.
| |
| | Then I added another 91 columns with historical data and now the same
| | calculation takes approximately 1 hour and 15 minutes. What a difference?
| | Can anyone explain why?
| |
| | If I were to put this historical data in another worksheet, how can I tie
| | the two sheet together?
| |
| | Any help will be appreciated.
|
|
|