Dear Modano Team,
How to paste multiple values at once in modano? If I use paste special command, I get this message:
I need to be able to copy hundreds of rows at once and it is very time consuming to copy and paste one row at a time.
Regards,
Ardi
Dear Modano Team,
How to paste multiple values at once in modano? If I use paste special command, I get this message:
I need to be able to copy hundreds of rows at once and it is very time consuming to copy and paste one row at a time.
Regards,
Ardi
Hi Ardi,
Modano does not prevent you from copying hundreds of rows within module components into the same or other module components, but it does not currently support pasting in multiple non-assumptions values and/or formulas from outside module components into module components. Is this the limitation to which you are referring?
The reason for this limitation is that everything within module components is done on a cell block and category block basis, whereas in static Excel files everything is done on a cell-by-cell basis. Hence, the process of automatically converting cell-by-cell data into cell block and category block-based data is very messy - a lot like the mess that is created when you use the macro recorder instead of properly writing VBA code.
Having said this, we're very aware that this is an annoying limitation, and we're working on expanding the scope of copy and paste to allow for scenarios such as this. We're aiming to have an improved copy and paste command released over the next couple of months.
Either way, we'd be interested to learn more about your specific copy/paste scenario so we know whether or list of improvements will address it.
Thanks, M.