Hi there,
I got a column of data from external source. Every 10 minutes the data were automatically updated, but the old data were replaced by the new data. I wanted to keep all data I collected. I tried macro and Filter Advanced function, they both worked, but I needed to do it manually. I want the data be automatically copied to another place when the sheet is refreshed. Thanks a lot!
harry
Bookmarks