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

Kemahiran: Excel Macros, Excel VBA, Excel, Visual Basic

Lihat lagi: 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

Tentang Majikan:
( 39 ulasan ) London, United Kingdom

ID Projek: #28314761

Dianugerahkan kepada:


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 Lagi

$30 USD dalam sehari
(70 Ulasan)

10 pekerja bebas membida secara purata $32 untuk pekerjaan ini

(315 Ulasan)
(146 Ulasan)
(187 Ulasan)

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 dalam sehari
(152 Ulasan)

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 Lagi

$20 USD dalam sehari
(17 Ulasan)

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 Lagi

$20 USD dalam sehari
(16 Ulasan)

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 Lagi

$30 USD dalam sehari
(1 Ulasan)

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 Lagi

$20 USD dalam sehari
(2 Ulasan)

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 dalam sehari
(0 Ulasan)