Đã Đóng

Need help with a quick VBA project with Excel

Request details

Essentially here's what I am trying to get the code to do:

Examine a list of cells in Column A, Sheet1.

For each cell, cross reference the text string (has to match entire cell contents) with a huge list of data in Column B, Sheet2.

There will be anywhere from 0 to 5 duplicates found.

If 0 duplicates are found, write "X" in Column B, sheet1, in the same row as the cell being examined.

Now, if a duplicate found in column B (sheet2), concatenate the contents of columns C and D (in the same row), and put the resulting string one cell to the right of the original cell being referenced (sheet1).

For each additional duplicate, do the same thing, and put each subsequent concatenated string in the same row, one column to the right of the previous one.

I hope this explanation is clear. I will provide a sample of the data.


Vba code

Kĩ năng: Excel, Excel VBA

Xem nhiều hơn: wirting vba project excel, working vba project excel 2007, simple vba project excel, global vba project excel, accessing vba project excel, build vba project excel, make vba project excel, vba project excel codes working application calculator, vba project excel macro, writing standalone vba project excel, tuition vba project excel, need help financial business project, can master page vba project excel, need help continue asp project, password vba project excel, references vba project excel 2016, need help with capstone project

Về Bên Thuê:
( 0 nhận xét ) Toronto, Canada

ID dự án: #31001025

27 freelancer chào giá trung bình$26 cho công việc này

(1026 Nhận xét)
(372 Nhận xét)
(352 Nhận xét)
(305 Nhận xét)
(221 Nhận xét)

Greetings! Thanks for very clear explanation of requirements - I understand the same. I can develop a macro exactly as per requirements. Please share the file. Being a full time freelancer working exclusively on Exce Thêm

$20 CAD trong 1 ngày
(220 Nhận xét)
(87 Nhận xét)

Hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I understand the value of deadline and do not compromise on quality. I feel fit mysel Thêm

$20 CAD trong 1 ngày
(26 Nhận xét)

Hi there, I can write a code for you in Excel that will find the matches and get the appropriate data and populate the columns in sheet 1. I have several years of experience in vba codes and will deliver on time. Plea Thêm

$25 CAD trong 1 ngày
(21 Nhận xét)

Hi I am expert in excel having experiance in excel and work with 100% accuracy and quality.,,,,,,,,,,,,,,,,,,,,,,,,,,

$89 CAD trong 1 ngày
(19 Nhận xét)
(38 Nhận xét)

Hi, I have read your requirements and I am very interested in this project. I have 6 years of experience in this field so I can do this for you at reasonable price. Please feel free to contact me. Portfolio: [login to view URL] Thêm

$20 CAD trong 7 ngày
(21 Nhận xét)

Hi, Greetings! ✅Checked your project details: VBA project with Excel ✅Completed Time: 24 hours or your required deadline. Kindly, I work on many projects like your request, I can send you many samples of my work in E Thêm

$20 CAD trong 1 ngày
(6 Nhận xét)

I understood your requirment and can start now and will deliver solution fast. Hire only if your are satisfied with the demo of solution provided by me. I am professional Excel and VBA developer (6+ years of expeienc Thêm

$20 CAD trong 2 ngày
(2 Nhận xét)

Hi, I am highly experienced in excel and vba. Have worked on sheets like that. Provide excel to work with. Regards Eagle Eyes

$25 CAD trong 2 ngày
(0 Nhận xét)

Dear Sir/Madam, I would love to assist you as after reading the complete project description carefully! i found myself as the best match for your requirements. i’m EXCEL expert , having more than 5 years of experience Thêm

$12 CAD trong 3 ngày
(0 Nhận xét)

VBA developer experience over 4 years I can start working immediately. Let's discuss details in chat. Thanks

$20 CAD trong 2 ngày
(0 Nhận xét)

I am an expert in the Microsoft Excel environment with 10+ years of experience, using formulas and VBA to create innovative solutions is part of my day to day work.

$25 CAD trong 1 ngày
(0 Nhận xét)

Hi, Dear! I have a full experience of 7 years in Excel VBA. I have read your requirement carefully and I am interested in this project. If you`ll choose me, I am confident to provide you best solution that completely Thêm

$30 CAD trong 1 ngày
(1 Nhận xét)

Hello Your explanation is very clear and straightforward. Some simple questions: When you say huge list, do you mean how many rows? It would be ok if we put a nice button to trigger the execution of the task? Best r Thêm

$25 CAD trong 1 ngày
(0 Nhận xét)