M
Metallo
Hi,
This is the follow up to a discussion that started two days ago, is there
anybody who can reply?
In my Consolidated WB I have 7 Charts and 1 database I have created as a
data source. In fact, in the DB, there are the formulas which get the data
from ten different WBs.
Let's try with an example.
The consolidated DB into the WB"Cons" has got 10 Companies into it, but to
simplify I'll put 5:
A B C D E
Company 1 3 1 2 0 0
Company 2 5 1 2 10 13
Company 3 4 2 3 5 6
Company 4 2 1 4 2 5
Company 5 1 1 1 3 6
--------------------------------------
Results 15 6 12 20 30
=========================
The above mentioned numbers are the sum or the comparison of the data of
the companies and from them I have created 7 different consolidated Charts.
Now, what I want to do is to go back to each WB of the single company, so,
Company 1, Company 2 etc... and copy the same charts and DB to get the same
type of chart but obviously with the numbers of the single company.
In the above mentione example:
WB Company 1 - New modified DB
A B C D E
Company 1 3 1 2 0 0
--------------------------------------
Results 3 1 2 0 0
=========================
WB Company 2 - New modified DB
Company 2 5 1 2 10 13
--------------------------------------
Results 5 1 2 10 13
=========================
WB Company 3 - New modified DB
Company 3 etc.
--------------------------------------
Results etc.
=========================
When I copy the Consolidated charts and DB to Company 1 (or any of the
others) the first thing I need to do is:
1) Take out the data of Company 2,3,4,5 from the DB
2) At this point, the Charts mess up because if the data of the consolidated
chart where coming from a ratio between, say, cell A1(Company1) and A6
(Results), cutting off the other companies A1 remains there but what was
before A6 goes up to A2 and therefore the chart does not work anymore.
Even worst when I do the same process for Company 2, in fact, A2 goes up to
A1 and A6 to A2, therefore, all is messed up again.
This is a very simple example, but in the reality the numbers are much more
complex and the sheets involved are more than 100!
Basically, I want to get the same charts for the single companies with their
individual numbers, I cannot think that I have to select again the source
data to the new positions of the DB, I think instead I should get to a
situation in which I just need to "update" the link.
To do this manually it would involve days and days of hard work, while I'm
sure you can help to simply to a few hours.
Hope this is clearer and gives you the chance to provide me with a solution.
Thank you!
Alex
This is the follow up to a discussion that started two days ago, is there
anybody who can reply?
In my Consolidated WB I have 7 Charts and 1 database I have created as a
data source. In fact, in the DB, there are the formulas which get the data
from ten different WBs.
Let's try with an example.
The consolidated DB into the WB"Cons" has got 10 Companies into it, but to
simplify I'll put 5:
A B C D E
Company 1 3 1 2 0 0
Company 2 5 1 2 10 13
Company 3 4 2 3 5 6
Company 4 2 1 4 2 5
Company 5 1 1 1 3 6
--------------------------------------
Results 15 6 12 20 30
=========================
The above mentioned numbers are the sum or the comparison of the data of
the companies and from them I have created 7 different consolidated Charts.
Now, what I want to do is to go back to each WB of the single company, so,
Company 1, Company 2 etc... and copy the same charts and DB to get the same
type of chart but obviously with the numbers of the single company.
In the above mentione example:
WB Company 1 - New modified DB
A B C D E
Company 1 3 1 2 0 0
--------------------------------------
Results 3 1 2 0 0
=========================
WB Company 2 - New modified DB
Company 2 5 1 2 10 13
--------------------------------------
Results 5 1 2 10 13
=========================
WB Company 3 - New modified DB
Company 3 etc.
--------------------------------------
Results etc.
=========================
When I copy the Consolidated charts and DB to Company 1 (or any of the
others) the first thing I need to do is:
1) Take out the data of Company 2,3,4,5 from the DB
2) At this point, the Charts mess up because if the data of the consolidated
chart where coming from a ratio between, say, cell A1(Company1) and A6
(Results), cutting off the other companies A1 remains there but what was
before A6 goes up to A2 and therefore the chart does not work anymore.
Even worst when I do the same process for Company 2, in fact, A2 goes up to
A1 and A6 to A2, therefore, all is messed up again.
This is a very simple example, but in the reality the numbers are much more
complex and the sheets involved are more than 100!
Basically, I want to get the same charts for the single companies with their
individual numbers, I cannot think that I have to select again the source
data to the new positions of the DB, I think instead I should get to a
situation in which I just need to "update" the link.
To do this manually it would involve days and days of hard work, while I'm
sure you can help to simply to a few hours.
Hope this is clearer and gives you the chance to provide me with a solution.
Thank you!
Alex