I am working on creating a historian of manually collected process data, in excel. This data is collected from the field, on a PDA, and downloaded to a computer as a .csv or .xlsx file, about 9 times a day. What i am hoping to do is create a macro, or something of the like, that will import the data from the new date file and have the data added to a list and not overwrite the provious records, possibly with a command button. I wish to make the compiling step as simple as possible. we would porbably run this macro each time the data is collected (so ~9 times a day) is this possible? any help would be greatly appriciated.
Thanks