SQL grab and Match

[dmxo]

OK so it is a bit of a long problem so I will go in steps:

I have a worksheet which pulls data from an SQL database, every 15 minutes (autorefresh is enabled), now what I want to do is:
Grab the data from one of the columns (Column C) of Sheet Z, and save it, on another sheet Y (Column D) (I have used VLookup at the moment).
Then after the next 15 minutes, when Sheet A is refreshed, I want to grab the data from the same column (Column C) of Sheet Z, and put it Sheet Y (Column E). Then I want the sheet Y to Match Column D and Column E, and check if there has been a change made. And I want the process to continue.

Problem I am facing:
I have used vlookup to transfer data from Sheet Z to Sheet Y, BUT, as soon as the sheet is refreshed, the data on Sheet Y changes too. HOW SHOULD I STOP THAT?
TIME ISSUE: I have no idea how to use timeframe (macro enabled or otherwise)

Help needed!

[event21]

Hi -

Show us your codes how you grab the data.

Regards,
Event

[dmxo]

Ok I solved it through a combo of Vlookup, IF Statements and some refreshments :P