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.
25 freelancer đang chào giá trung bình $39 cho công việc này
Hi, I am an Excel VBA expert with 10 years of experience. I have your macro ready for you. Please check your inbox for further details. Many thanks Joe
Hi, Visual Basic and Excel macros expert here! I understand, what you want even you changed E column to B in your description. I can do this job for you in 1 day. So let's start! Looking forwar for our cooperation.