Get range on google sheet

how i can set data viewer list1 on sheet1 range A1:D5
and data viewer list2 on sheet 1 range A6:D7
thank you very much

You can’t map a DVL that way. So instead, set up your Google Sheet so that one sheet is copying the first range of cells from a main sheet and a different sheet is copying the second range of cells from the main sheet. Then, map the DVLs to each of the sheets with the copied ranges.

can i ask one more question, how can i set color for DVL when screen1 start, i can do it when DVL click, but i want to do it when screen1 start

There is a way but there is currently a bug preventing it from working: Can't change container background color manually in DVL

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.