Need to export to csv with a special condition

[jiggy2001]

Hi,
I am trying to export a sheet to csv. Data looks somewhat like below.

date 1/1/2010
name account d/c client amount
abc 123 c 12
def 456 d 23
ghi 789 c 4
jkl 908 d 54
mno 876 c 56
trailer 999999

I would like to export everything from the cell that states the date. (lets call it cell A1) down to the row that states trailer and over to the column that states amount.
I have a macro that puts trailer and 999999 after the last row of data.so in short i would like a macro that would select from A1 then look for trailer, go to that row that contains trailer and select all the way over to the amount column and export that block of data to csv. Iam attaching an example file. Would greatly appreciate some help.

i have used the following code but it does not work with my current requirement of changing last rows.

Please Login or Register  to view this content.