Đang Thực Hiện

Basic VB Macro

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.

Kỹ năng: Xử lí dữ liệu, Excel, Visual Basic

Xem thêm: sheets add, l2, what is macro in excel, macro, macro excel, macro + excel, k2, j1, B3, b2, excel macro add, add references excel visual basic, sheet excel visual basic, excel format cell, excel cell format, excel macro parts, excel macro data extract, format cell, add excel macro, example visual basic, excel multiple sheets copy sheet macro, extract macro excel, excel copy sheet multiple sheets, copy cell cell excel macro, extract data excel macro

Về Bên Thuê:
( 3 nhận xét ) Philadelphia, United States

Mã Dự Án: #1602465

Đã trao cho:

nagybatonyi

Such jobs are my daily practice. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of b Thêm

$40 USD trong 2 ngày
(61 Đánh Giá)
5.7

25 freelancer đang chào giá trung bình $39 cho công việc này

mrbrave

Hi,I am expert in excel/VBA....Please see my reviews...I can provide you macro within a day..Thanks

$70 USD trong 1 ngày
(207 Đánh Giá)
6.5
danielgpratidya

The macro is ready, and you can pick it up in your pmb.

$30 USD trong 0 ngày
(189 Đánh Giá)
6.5
koolsidz

Excel Whiz here. Your macro is ready :)

$45 USD trong 0 ngày
(173 Đánh Giá)
6.6
srinichal

I look forward to discuss further

$80 USD trong 3 ngày
(57 Đánh Giá)
6.1
vserv

Pls see your messages. Thanks

$40 USD trong 1 ngày
(65 Đánh Giá)
5.9
Krusche

Hello. Macro(Excel/Access) experts. Please check your inbox for examples.

$60 USD trong 1 ngày
(30 Đánh Giá)
5.6
MuhrizRashid

Hello, I see you require an Excel macro for your task. I have sent you a private message about my skills and previous experience in similar projects. I rest-assure that I will complete the work on time and deliver you Thêm

$55 USD trong 5 ngày
(50 Đánh Giá)
5.7
northwolves

Ready to [url removed, login to view] forward to working with you

$30 USD trong 1 ngày
(66 Đánh Giá)
5.3
Nhcuong

Hi, i can do it! will send working demo soon!

$30 USD trong 0 ngày
(32 Đánh Giá)
5.0
microk

**************Expert here.. Please check PM..**************

$30 USD trong 1 ngày
(33 Đánh Giá)
4.5
manishadk

This is VERY EASY JOB for us. Please check PMB for details.

$30 USD trong 1 ngày
(18 Đánh Giá)
4.2
muthumuni

hi, demo is ready here. contact me soon. regard muthumuni

$30 USD trong 0 ngày
(12 Đánh Giá)
4.1
Lotusdeveloper

Hi , I can do this project in 1 hour and so. LD

$30 USD trong 0 ngày
(14 Đánh Giá)
3.3
JoeGreen1982

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

$30 USD trong 0 ngày
(8 Đánh Giá)
3.3
mhtkhan

Hi, we have already done part of your project. please have a look at the attached file. Thank you.

$30 USD trong 1 ngày
(3 Đánh Giá)
3.3
Centuri

Good Day Sir, I am interested in submitting a proposal for this project. I am highly experienced with Excel and VBA and am more than capable of completing this project for you. Please review PMB for further detai Thêm

$50 USD trong 1 ngày
(3 Đánh Giá)
1.8
amaldavid16

I have 10 + years in macro and see my details

$30 USD trong 1 ngày
(1 Đánh Giá)
1.0
Faraoon

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.

$30 USD trong 0 ngày
(0 Đánh Giá)
0.0
vbexcelguru

I have earlier done such [url removed, login to view] my early work it was required to arrange a table data into Presentable format and then prepare one Power poiint Presentation from the Excel it [url removed, login to view] My macro was arranging data and t Thêm

$30 USD trong 2 ngày
(0 Đánh Giá)
0.0
trisha2k12

It can be done !

$30 USD trong 1 ngày
(0 Đánh Giá)
0.0