Copy and Paste for Data

This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

  • Copy and Paste for Data

    Hi,

    If I copy and paste data in an Excel-Sheet then the normal PALO formulas would be overwritten with the copied formulas/values. Some times it would be nice to copy and paste the figures directly into the cube (w/o creating special setdata imports). I am thinking about a VBA routine which scans the formula in the target cell and instead of overwriting starting a setdata command using the parameters in the target cell.

    Did anybody create something like?
    Are there other ideas to create this functionallity?

    Thanks
    Dirk