Excel Macro to Process a Text File & Count Items

We’re looking for an expert VBA coder to write an quick and easy to use macro for Excel 2016 for a simple text processing exercise.

Goal: we’re looking for social media users to vote for one of several performances in a streamed video by using the comments functionality. Each performance can only be scored during a specific period of time. We will encourage them to post a comment with a flame emoji to cast their vote at the right time. But we will only allow them to vote once, so will need to only register their first comment that contains a flame emoji and ignore any further posts from that.

Please see the attached sample chat export text file Also a proposed UI for entering time segments and receiving results (we’re open to anything that works)

I’d expect the process to work something like this...

* Filter list for only comments that include flame emoji

* De-dupe rows based on Username, retaining only the first comment for each user

* Count the rows within the given time range and present back

Would be good to be able to see workings eg. sheets showing interim stages

Skills: Excel Macros, Excel VBA, Excel, Visual Basic

See more: excel macro read text file, excel macro chinese text, excel macro parse text file, excel macro format text, excel macro check text format, excel macro edit text file macro, excel macro clean text, excel macro convert text file excel, excel macro convert text number, excel macro find text word file, excel macro generate text file excel, excel macro insert text internet explorer, excel macro search text word doc lines, excel macro write text file, excel macro compare text, excel macro import text file into specific sheet, excel macro import text file delimited, excel macro delimited text file

About the Employer:
( 39 reviews ) London, United Kingdom

Project ID: #28314761

Awarded to:


Hello. I have more than enough experience to prepare this project for you. I've even prepared most of it while just playing with the txt file in VBA. Message me for a quick and precise solution. Best regards. Here is More

$30 USD in 1 day
(70 Reviews)

10 freelancers are bidding on average $32 for this job

(315 Reviews)
(146 Reviews)
(187 Reviews)

Hi Sir, I went through the files. I can complete this job within hour or two. Please ping back to get started right away. Please check my past reviews. I have 10+ years of experience. Thank You Regards Rishi

$30 USD in 1 day
(152 Reviews)

Hi, Greetings! ✅checked your project details: Excel Macro to Process a Text File & Count Items ✅Attachments : Seen ✅Completed Time: 24 hours or your requirement deadline . I have 5 + years of the experience in same ki More

$20 USD in 1 day
(17 Reviews)

Hi . This is Yesu ,I am Working as VBA/Python developer for 5 years I work on automations of [login to view URL] [login to view URL] [login to view URL] [login to view URL] Point [login to view URL] [login to view URL](limited) We use Macros,VBScripts,API's,Selenium, for process I can More

$20 USD in 1 day
(16 Reviews)

Hi, bro! I have read your requirement and I noticed that I am appropriate to this project. I have rich experience with file processing using Excel macro. Everyone call me a "Prince of Excel". I promise I will finish th More

$30 USD in 1 day
(1 Review)

Hi, appreciate if you took the time to review my proposal. New to this platform but I am very familiar with MS Excel and have experienced completing few projects. I am used with Excel VBA, Macros, Userform and other f More

$20 USD in 1 day
(2 Reviews)

Hello, I am a professional data entry operator. I can do your work in 1 day. contact me for more details. Yhank you.

$15 USD in 1 day
(0 Reviews)