You have chosen to sponsor your bid up to a maximum amount of .
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.