[r0mmel]

Hi Everyone,

I hope this is not too much, but I badly need help on creating a VBScript for Excel that can:
1. Check if any excel file exists, if there are, open them one by one and do step 2 onwards; if none, do nothing.
2. Copy cells F8:Z8 of Sheet 1 all the way to the bottom where F8 is not null and Paste it to C1 to a new excel file.
3. Then copy the value from A2 and B2 then paste/reiterate it to A1 and B1 all the way to the bottom where F8 is not null of the new excel file.
4. Save the result to .csv.
5. Append all .csv results into one (there are multiple excel source files).

Here’s an illustration:

http://img855.imageshack.us/img855/8198/transform.jpg