Related:
- Auto Transfer To New Cell
- Free fire transfer - Guide
- Grand theft auto 1 download - Download - Action and adventure
- How to stop facebook auto refresh - Guide
- Grand theft auto v free download no verification for pc - Download - Action and adventure
- Nvidia drivers auto detect - Guide
1 response
create a named range for your input cell and a named range for the beginning of your output, run the marcoeverytime you want data refreshed. can make fancier by setting to autorun every x minutes, and then create the graph after too
dim input as range, output as range,cells down as long
set input = range("input")
set output = range("output")
range("output").select
cellsdown = range(selection,selection.end(xldown)).countn
' won't work if inputs are strings, write a smartcount function if that is the case
output.offset(cellsdown, 0).value = input.value
dim input as range, output as range,cells down as long
set input = range("input")
set output = range("output")
range("output").select
cellsdown = range(selection,selection.end(xldown)).countn
' won't work if inputs are strings, write a smartcount function if that is the case
output.offset(cellsdown, 0).value = input.value
