Share
ReportHello,
newbie here. I am trying to turn a data range into a dynamic range, and then create a table from that range. I have looked at a few other threads, but when I try them there is always something that does not work.
I have decided to take the path of using office scripts, and to create a range and then get the last row. My idea is then to use the row number together with 'Create a table' for Excel Online.
I have managed to create the result '17', which is the correct last row.
But I do not know how to proceed. I want to use the 'Create variable' but I do not get anything in the drop down for Name, and I cannot type anything.
How do I use the result from 'Run Script' to use it in the range input field of 'Create table'?
Categories:
I have the same question (0)
All responses (
Answers (
711
