Sorry title field too short: Take Device Extract CVS, copy needed fields via Macro to new document, then another macro to take data and only copy NEW events based on Receive time value.
So with this as my title some back ground.
I have a device that gives me a CSV extract of data, via a manual event. Due to this it goes back a varying date range. (Example file dataextract.cvs). Using this extract, I created an import doc that gets all the data I need via a macro (Example Log Export.xlsm) . This part works well.
What I need help with, is taking this data, looking at my Master doc, and coping only new lines over to it. The master document is where I have the pivot tables setup to give management the data they want, and do some basic analysis.
Thanks
Bookmarks