Find Jobs
Hire Freelancers

Excel VBA code

$50-100 USD

I përfunduar
Postuar about 5 years ago

$50-100 USD

Paguhet në dorëzim
I want an Excel VBA Code/ macro that will count all the active rows in a specific column within a number of closed workbooks (Sheet1) & text files (i.e. txt & csv). The file path will be as followed “C:\TestFolder”. This file path contains over 100 spreadsheets & text files so the code/ macro must be able to loop through each file. The macro/ code must be able to open up each file in the background & close the files automatically. The Macro must be able to loop through each file (data is kept in sheet1 for workbooks) and count the total number of active rows in a specific column (for example column A, B or C) & it must be able to print this value within a separate workbook ‘zMasterworkbook’. The code or macro must also be compatible with older versions of excel. The separate workbook ‘zMasterworkbook’ must contain and meet the following requirements: 1. Column A2- should have the ‘File Name’ field (file name of each file) 2. Column B2- should have ‘Total number of Active Rows” filed (total number of active rows for a specific column in each file).
ID e Projektit: 18735039

Rreth projektit

12 propozime
Projekt në distancë
Aktive 5 yrs ago

Po kërkoni të fitoni para?

Përfitimet e ofertës për Freelancer

Vendosni buxhetin dhe afatin tuaj
Paguhuni për punën tuaj
Përshkruani propozimin tuaj
Është falas të regjistrohesh dhe të bësh oferta për punë
I dhënë për:
Avatari i Përdoruesit
Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me. Roy
$65 USD në 1 ditë
4,9 (304 përshtypje)
6,7
6,7
12 freelancers are bidding on average $72 USD for this job
Avatari i Përdoruesit
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$120 USD në 2 ditë
4,9 (320 përshtypje)
7,8
7,8
Avatari i Përdoruesit
Dear Employer, I understand you need a macro code which will check all the excel files in a Test folder in C drive and will find the active cells in different columns and will give the values in Col A2 and B2. Please message me and give me an opportunity to work on your project. I understand it well and will do a perfect job for you. Thanks and Regards, Ash
$100 USD në 5 ditë
5,0 (157 përshtypje)
7,3
7,3
Avatari i Përdoruesit
I can do Excel VBA Code/ macro that will count all the active rows in a specific column within a number of closed workbooks (Sheet1) & text files (i.e. txt & csv). MOhsan
$75 USD në 1 ditë
5,0 (80 përshtypje)
6,2
6,2
Avatari i Përdoruesit
Hello, I am experienced excel expert. I can help with this task with quick turnaorund. Looking to hearing from you for further discussion. Kind regards Rina
$50 USD në 10 ditë
4,9 (81 përshtypje)
5,9
5,9
Avatari i Përdoruesit
Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest possible time and with the highest quality! From the Excel, of course, familiar. Give me a chance to show what I can do!
$50 USD në 1 ditë
5,0 (94 përshtypje)
6,0
6,0
Avatari i Përdoruesit
I am proficient with Microsoft Excel and marco/VBA development. I read your project descriptions carefully, I can write the marco to count row number of all files as requested. You’re welcome to checkout my reviews and project completion rate to have some idea about the quality of my previous works, Kindly get back to me if you wish to proceed, I am available to start your project immediately, looking forward to chat further and work on your project.
$80 USD në 2 ditë
4,9 (74 përshtypje)
5,6
5,6
Avatari i Përdoruesit
Hello. How are you? I am highly interested to work on the "Excel VBA code". I am a full stack Excel expert. I have more than 7 years experience in "Data Processing, Excel, Visual Basic, Visual Basic for Apps". I will make sure the best quality service. Let us work together. Best regards, Yang L.
$50 USD në 1 ditë
4,7 (42 përshtypje)
5,5
5,5
Avatari i Përdoruesit
Hi! Thank you for taking the time to read my proposal, My name is Uriel Baray I am a VBA Excel Expert with several years of experience on the field, if you are so kind to take a look to my portfolio, I have some samples for you there. Please send me a message so we can discuss further details of your project
$75 USD në 10 ditë
5,0 (24 përshtypje)
4,7
4,7
Avatari i Përdoruesit
Hi I have Read Your Requirements I am Excel VBA Expert Experianced in VBA Macros & Web Scraping Script... I can finish any kind of vba task in 1 day only pls see my previous projects for my vba experiance Thanks
$50 USD në 1 ditë
5,0 (29 përshtypje)
4,0
4,0
Avatari i Përdoruesit
Hi Sir, I see you need Macro Programming in excel to help you deal with the data in CSV, Excel and TXT files. I can help you with that. I've been desigining macros since long. for the confirmation, i need to see the TXT file and CSV format. CSV is same as Excel. Only thing to confirm is TXT file template. Let's discuss more about this in chat. I'm available and can start work on it right away. I'd like to see dummy data also to check the data arrangement in the sheet. Lets discuss this in chat.
$100 USD në 5 ditë
5,0 (3 përshtypje)
3,3
3,3
Avatari i Përdoruesit
Hello, Wish you a very good day. I have gone through your job post and come to know that you are looking for an Excel VBA Developer. As it is a passion of me working as an Excel Data Entry, I don’t want to lose the opportunity and therefore applying for the post. I have completed graduated in ICT and having 5+ years of experience In excel data entry work. I believe myself to be the most reliable person for your job. If I awarded then I will instantly start & give you complete project within 24 hours. I am working as a freelancer and as a Virtual Assistant for a long five years. It has made me many experts in my work. I work in such an environment and enjoy the variety of works the job brings each day. I can assure you that if you hire me, I will give you quality work & you will get a good staff for your any data entry project. Thanks a lot for taking time reviewing the letter. I hope to hear from you soon. Best Regards Monir
$50 USD në 1 ditë
5,0 (2 përshtypje)
2,5
2,5

Rreth klientit

Flamuri i UNITED KINGDOM
luton, United Kingdom
5,0
4
Mënyra e pagesës u verifikua
Anëtar që nga korr 20, 2015

Verifikimi i klientit

Faleminderit! Ne ju kemi dërguar me email një lidhje për të kërkuar kredinë tuaj falas.
Ndodhi një gabim gjatë dërgimit të email-it tuaj. Ju lutemi provoni përsëri.
Përdorues të regjistruar Punë të postuara
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Po ngarkohet shikimi paraprak
Leja u dha për Geolocation.
Seanca e hyrjes ka skaduar dhe ke dalë. Hyr sërish.