I need to write a macro which would copy a range of values from one keyfigure and to another.
The Macro will copy the horizon of a selected key figure or only highlighted cells, to another key figure. Highlighting the selected portion will function like a copy/paste, to bring the values from one key figure to another key figure.
Awaiting suggestions.
Regards,
Kunal