Excel 2010 Macro/VBA

The budget range for this job is negotiable, I have entered values as a guide only...

VB Macro for the extraction of raw (required data only) from bulk spreadsheets to be imported to csv files.

1. File Creation: A new blank .CSV file should be created and named as the contents of cell D1- [agency name – Code – Week Ending Date] e.g. (NL Group – 701055 – WE 13/01/2012)
2. Header Creation: The following column headers need to be created, with the titles exactly as in the spreadsheet:
a) Contractor Ref
b) Assignment ID
c) Last Name
d) Period End
e) 1.Desc
f) 1.Units
g) 1.Rate
h) 2.Desc
i) 2.Units
j) 2.Rate
k) 3.Desc
l) 3.Units
m) 3.Rate
n) 4.Desc
o) 4.Units
p) 4.Rate
q) 5.Desc
r) 5.Units
s) 5.Rate
t) Billable - Subs
u) Billable - Mileage
v) Billable - Travel
w) Billable - Accomm
x) Billable - Tel
y) Billable - Misc
z) Total Net
aa) VAT
bb) Total Gross
3. Row Selection: Starting at line A4 the macro needs to extract the data from cells listed in point 3 - 9 only if the following condition is met and placed into the new CSV file starting at cell A2 (under the respective headers).
a) Cell AX4 has a positive (+) or negative (-) figure (i.e. the line has some funds to process for the worker. (If there is a Zero (0) value the line is to be ignored and the macro should move onto the next row AX5)
b) A4 – B4 – E4 – F4
4. After F4, we need to do a second validation as to which rate description, rate and hours to pull in as although all fields may have a rate and description, we only want the ones with attributed hours next to them to be extracted.
5. Where there is a Positive (+) or Negative (-) figure in cell J4 extract this along with the values of cells I4 – J4 & K4 (in that order) and repeat.
6. Where there is a Positive (+) or Negative (-) figure in cell O4 extract this along with the values of cells N4 – O4 & P4 (in that order) and repeat..
7. Where there is a Positive (+) or Negative (-) figure in cell U4 extract this along with the values of cells S4 – T4 & U4 (in that order) and repeat..
8. Where there is a Positive (+) or Negative (-) figure in cell Z4 extract this along with the values of cells X4 – Y4 & Z4 (in that order) and repeat..
9. Where there is a Positive (+) or Negative (-) figure in cell AE4 extract this along with the values of cells AC4 – AD4 & AE4 (in that order) and repeat..
10. The contents of the following cells then needs to be populated in the proceeding cells in the CSV, if the cell is blank leave the destination cell blank and move onto the next columns cell:
a) AF4
b) AG4
c) AH4
d) AI4
e) AJ4
f) AK4
11. Finally extract (where values exist) and place in directly under the final 3 column headers:
a) Total Net
b) VAT
c) Total Gross
12. Then the macro can move onto Row 5 following the above steps… until the last Row with a value indicated in point 3.a.
13. All CSV’s should be then saved in a pre-determined place on the a drive to be determined