auto copy and past
 

All,

In Sheet1 I keep historic record of the price of a stock,
listing data and price horizontally. In Sheet2 I have a
web query that shows the end of day price. How could I
have a macro that would copy and past the price of the
web query into the last non blank cells of a cell
range?

Your help is much appreciated!