Update Web Query Without deleting old data, just update new ones.

Hi ,
I have created a Web query in Excel I put it to refresh every 10 minutes and all the old data is removed with the new data .
This is the website in question

http://www.dmxmusic.com/guide/whats_...channel_id=100

I would like excel to update with the new songs played without deleting the songs that played before, in other words I want to get a list of all songs played in a day.

Thank you very much in advance.

Hi, welcome to the forum
see attached file
Try this:

This sub calls itself every 10 minutes

Sub CopyList()
'set variables
    Dim wsD As Worksheet, wsH As Worksheet, rngD As Range, rngH As Range
    Set wsD = Sheets("Download"): Set wsH = Sheets("DownloadHistory")
'ranges to copy and paste
    Set rngD = wsD.Range("A1").CurrentRegion.Offset(2)
    Set rngD = rngD.Resize(rngD.Rows.Count - 2)
    Set rngH = wsH.Range("A" & Cells.Rows.Count).End(xlUp).Offset(1)
'copy and paste the data
    rngD.Copy rngH
'remove duplicates
    Set rngH = rngH.CurrentRegion
    rngH.RemoveDuplicates Columns:=Array(1, 2, 3, 4), Header:=xlYes
'repeat after 10 minutes
    Application.OnTime Now + TimeValue("00:10:00"), "CopyList"
End Sub

Do you want the sub to run automatically when the file is opened? Add this to the ThisWorkbook module

Private Sub Workbook_Open()
    Call CopyList
End Sub

The link worked for me. But perhaps you could try removing it and recreating on your Mac - there may be some difference in the way Excel for Mac does the linking

Excel 2003 - create a file with the 2 worksheets named as per my download, add the data import link etc and place the VBA in a general module. (Hopefully it will work - the VBA is basic)

Glad it worked for you 😀
Please mark thread as solved - see thread tools at top of thread