I was hoping this would be easy (and maybe it is) but I’m struggling with it. Does anyone have any advice for a way to use a trigger to copy the contents of one Excel cell to another for multiple rows?
For example…
With a single trigger I want to copy the contents of C1 to E1, C2 to E2, C3 to E3, etc. where the number of rows may vary based on filters or different sheets.
I know how to use a simple counter with a global variable to “set value” a cell’s contents across multiple rows of a single spreadsheet, but this works on only one value and typically to the same value (eg, a button could trigger an action to set the set all the cells in C1, C2, C3 to “1”)
I also know how to embed a button trigger in each displayed row of an excel data spread that can be used to copy the contents of one cell to another in a single row, but I can’t seem to figure out a way to use a button or toggle outside the data spread to trigger/action that will read the value in a given cell and copy it to another cell in the same row…but do that for multiple rows at once.
Any ideas?? Hopefully I’m missing something obvious.