Hello together,
i have a question regarding the use and options of macros and would be very grateful for your help/feedback.
Let`s take an example for my problem:

As u can see: i have 2 years: 2012 (past) and 2013 (future).
Key Figure 1 (Sales Volume) is generated form former Sales Demand (Data is available from historical data).
Key Figure 2 (Forecast): Planned by Demand Planner (automatically generated)
Key Figure 3 (Period of the preceding year):
- Red arrow: should automatically take the (sales-history-)data from cell: (Key Figure 1 & Month 02 2012)
- Green arrow: should automatically take the (sales-history-)data from cell: (Key Figure 1 & Month 01 2012) AND DIVIDE it into Weeks instead of month.
My question is:
- Is it possible to create a macro which is getting the data from an existing datafield and generate it automatically in the right time-period-unit? (month is always the basis for the past-data)
Tanks in advance,
Holger