How to copy and paste multiple values quickly

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.

Hi Ardi, 

That dialog box may come up when you try to paste into non-assumption cells. Try formatting the cell range you want to paste into as Assumptions -> Heading or Number then re-paste. If you have assumption cells you can often use the Import Assumptions wizard on the Modano ribbon. That then speeds up any future import you may do if the source data is updated.

I often have dialog boxes popup when the copy range doesn't match the paste range. For example, if the copy range has more columns or rows than the paste range. That dialog box has different text to the one you posted, but when I see it I can solve the problem by correcting the copy and paste ranges. 

The most time consuming copy/paste issue for me is on the Lookup worksheets. You can only seem to paste one cell at a time into an assumption category block on those worksheets. I guess the workaround there is to link the lookup assumption block to an assumption block on a blank or timeseries assumption block in the same module, then paste into that assumption block. 

I hope that helps,

James