I am trying to copy and paste as values for those cells with BBG formula.(Currently shown as #NAME? on the screenshot as we have yet to extract the value).
Once we refresh the excel, row 43 will be reflected as number values instead of #NAME?. However, it will still be a formula instead of value. Hence, Im using write and copy range activity to paste it as values.
It works but however, I have multiple sheets to work on and for every month, the row changes (next month it will be 44 instead of 43). It will not be feasible to change the range every month.
Is there a way the for the row value in write range activity to be derived from a cell?
Meaning, I can create a formula on cell A100 that returns “44”, as row 44 is the first row that gives me error.
Can the write range activity read cell A100 and start writing the copied data from row 44?
And for the next month, cell A100 = 45 and the write range activity read this cell and start writing the copied data from row 45.
Is this possible? Thanks!