Basic VB Macro

IN PROGRESS
Bids
27
Avg Bid (USD)
$39
Project Budget (USD)
$30 - $250

Project Description:
I need an excel/vb macro that can be used to collate information from a MS Excel sheet column and place all the data into another predetermined cell, each separated by a semi-colon. I need the macro to be able to be manually used in multiple excel sheets.

For example (see attached excel file for references):

1) If cell B2 = J1 then copy cell B2 into cell J2
If cell B2 = K1 then copy cell B2 into cell K2
If cell B2 = L1 then add cell B2 into cell L2

If cell B3 = J1 then ADD cell B2 into cell J2 (ie add B3 to what is already in J2, separated by a semi-colon)
If cell B4 = K1 then ADD cell B2 into cell K2 (ie add B3 to what is already in K2, separated by a semi-colon)
If cell B4 = L1 then ADD cell B2 into cell L2 (ie add B3 to what is already in L2, separated by a semi-colon)

And so on for all cells with data in column B.

Attached is an excel file with a data extract. Tab1 shows the data with the highlighted parts representing the format I would like the data to look after the macro outputs the data requirement.

Skills required:
Data Processing, Excel, Visual Basic
Additional Files: Freelancer2011dataexample.xls
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 30
in 0 days
$ 40
in 1 days
$ 45
in 0 days
$ 80
in 3 days
Hire mrbrave
$ 70
in 1 days
$ 55
in 5 days
Hire nagybatonyi
$ 40
in 2 days
$ 60
in 1 days
Hire MohammadAmiry
$ 40
in 0 days
Hire northwolves
$ 30
in 1 days