
Piece of VBA code as mark of Macro for Excel
- or -
Post a project like this1069
£20(approx. $27)
- Posted:
- Proposals: 18
- Remote
- #3693042
- Awarded
Digital Solutions|Designer & Developer|Shopify|WordPress|SEO|Data Scraping|Lead Generation|Animation

WordPress Expert✮Shopify Expert✮Graphic Designer✮AutoCAD 2D & 3D✮CV Writer & Designer✮Fullstack developer

Virtual Assistant, Excel programmer, Customer Support Agent, EN-GR/GR-EN Translator

351470562314838114786608173363657377488877582742144943347809874541150415912627754




Description
Experience Level: Entry
Hi,
I need to have a piece of VBA code written
There are two colums which will be made up of Stings
The columns are of a variable number of rows and likely each column will have a different number
Each column needs to be ordered
The code needs to compare the string in each column
If the string matches then the code needs to add the text "true" to the cell column C
If there is not a match then the code needs to check the boxes below (checking both variables from both columns A and B)
Where no match is found then insert the text "False) in column C
When a match is found, then insert empty cells so that the cells in columns A & B match
Repeat until all rows have been checked
I will provide a video example of doing it manually and sample data
I need to have a piece of VBA code written
There are two colums which will be made up of Stings
The columns are of a variable number of rows and likely each column will have a different number
Each column needs to be ordered
The code needs to compare the string in each column
If the string matches then the code needs to add the text "true" to the cell column C
If there is not a match then the code needs to check the boxes below (checking both variables from both columns A and B)
Where no match is found then insert the text "False) in column C
When a match is found, then insert empty cells so that the cells in columns A & B match
Repeat until all rows have been checked
I will provide a video example of doing it manually and sample data

Solomon D.
100% (4)Projects Completed
4
Freelancers worked with
4
Projects awarded
71%
Last project
20 Dec 2022
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Reading the description, I don't think VBA code is needed. A simple Excel formula may do the job. Could you share video example please?
1033296
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