Selecting a moving cell to copy into a static cell

rustybenson

Board Regular
Joined
Dec 14, 2002
Messages
104
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
 

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

Watch MrExcel Video

Forum statistics

Threads
1,129,588
Messages
5,637,275
Members
416,963
Latest member
samfuge

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top