I want to take data from one file (6800 records) and break them down into another file that
has formulas in the rows but are used when the data is populated into the file. Basically,
I am trying to prevent just copying and pasting the data (In Excel) from one file to another
and speed up the process. I have tried creating a job that would do this but get Java Heap error.
Probably due to the fact there are formulas in the cells that are to the right of where the data is.
(simple math calculations)
Solved! Go to Solution.
Great this issue has been fixed. Thanks for sharing your solution with us.