I have an excel spreadsheet set up using the RTD function to update a row of values every 2 seconds. How can I get excel to append a csv or xls file with the RTD values every time they change? Alternately, can some code make the RTD row be copied and pasted to a new row so that all of the incoming...
I need to read data from the spreadsheet into userform anyone can explain it to me? whenever i call the userform the cell stop from being updated/