Selecting a moving cell to copy into a static cell

[rustybenson]

Hi
I have an excel spread sheet that records daily fuel prices. As this suggests the price changes daily so it is recorded accross the spread sheet under the product headings. Each day I populate the next row of cells with the new price.
I have to impoty this into a new software program that invoices our customers based on these daily prices. This is imported via a csv file. The csv file remains static so i will have to import it daily. How do i get the daily pricing (that drops down a row each day to populate the csv file ready to import. I could copy it daily however that will take avery long time as I have many sites (areas) and would have to link each one individually each day
Price changes daily
Day ULP PULP Diese E10 B100
1/07/2010 123.5 126.9 127 8 126.4
2/07/2010 123.7 125.8 126.9 7.9 126.5
3/07/2010 123.1 126.8 125.7 6 125.6
4/07/2010 124.1 125.8 125.7 5.5 127.1
5/07/2010 123.7 126.1 125.8 5.9 126.9
6/07/2010 123.7 126.1 125.8 5.9 126.9
7/07/2010 123.7 126.1 125.8 5.9 126.9
8/07/2010 123.7 126.1 125.8 5.9 126.9






Static Information
Day ULP PULP Diesel E10 B100
8/07/2010 123.7 126.1 125.8 5.9 126.9

This is similar to what I use.
If i can set this up I will incorporate it into a macro that sends it to the import file bay. As always any help would be appreciated.
Regards
Rusty