I need a VBA expert for Microsoft Excel
- or -
Post a project like this2263
$$
- Posted:
- Proposals: 4
- Remote
- #1384199
- Awarded
Description
Experience Level: Intermediate
Description of excel work: Require someone to provide me with TWO VBA codes that will work in Microsoft excel 2016 (please don't bid if you use open office or other software).
First code would be to return multiple values for the vlookup function. So if I'm searching for 1 name, it will occur several times in the sheet, I want all matching values to be shown - not just one.
Second code is to sort data in a excel sheet. Data is jumbled up between 10-15 columns for eg. the same data will be in column a and column d and column e, I would need the code to be able to pick up the labels and sort all matching data into one column each.
I need both codes within the next day.
Thanks
First code would be to return multiple values for the vlookup function. So if I'm searching for 1 name, it will occur several times in the sheet, I want all matching values to be shown - not just one.
Second code is to sort data in a excel sheet. Data is jumbled up between 10-15 columns for eg. the same data will be in column a and column d and column e, I would need the code to be able to pick up the labels and sort all matching data into one column each.
I need both codes within the next day.
Thanks

Unicorn Byte
99% (70)Projects Completed
50
Freelancers worked with
42
Projects awarded
36%
Last project
31 Mar 2022
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Please, attach the excel file to be worked on. If the price of US$ 100 for the next 3 hours is good enough for you AND the job is possible for me, I will do it on the next 3 of hours after reviewing the xls file and after you accept the proposal formal via the system.
253897
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies