Save Cell Value to New Cell when Cell's Value has changed (Price Tracker Spreadsheet)

[b_60]

So I'm trying to make a price tracking spreadsheet that will feed me the current best price on a product along with worst price and average price.

I am receiving data from http://www.pricepinx.com drawing prices from several websites for each product being followed.

As it stands now my spreadsheet can simply give me the current best price on my items.

What I need to make this spreadsheet do is to record price history. Every time I refresh the data and a price has changed I want that new price and the current date/time to be added to a list on a separate page. If the price has not changed then I don't want the spreadsheet to do anything.
I can use this data to make graphs of price fluctuations over time.
---How can I make this happen?
What I have now: =IF($B3<>'Live Feeds'!$M$50,'Live Feeds'!$M$50,"")
$B3=baseline price from day 1
$B4+=price from the last time the price changed
--
'Live Feeds'!$M$50=current product price from web

As I'm sure you've already noticed, this formula causes every other cell to populate.


Please help me! I'm obviously no excel whiz.

[b_60]

I've also tried:
=IF('Live Feeds'!$Q$50="SAME","",IF('Live Feeds'!$M$50=DATA!$B3,"",'Live Feeds'!$M$50))

$Q$50=SAME is another cell that determines whether the data obtained from the latest refresh is different than the data stored the last time that the macro was run

The macro simply copies cell "values" from the cells refreshed from the web to new cells to save the last price before the data is refreshed.
So after every time I refresh the data, I run the macro and it saves the current price to compare it against the next refresh so I can easily see what's changed.



I can't think of any way to use a formula to make this work. That certainly doesn't mean it can't be done since my knowledge is very limited.


To me it seems that the best/simplest/easiest way to get this done is with a macro. But I think that it would need to be a macro with "conditions". Is that even possible in excel, if so how?


If I can somehow create a macro that will copy the contents from a cell and paste them to say, the first blank cell in a specific row I think that would work.---Any Suggestions?