Freelancer logo
How It Works
Browse Jobs
Log In
Sign Up
Post a Project
EXPLORE
Data Entry
Excel
SQL
Visual Basic
Visual Basic for Apps
You're now following .
Error following user.
This user does not allow users to follow them.
You are already following this user.
Your membership plan only allows 0 follows. Upgrade
here.
Successfully unfollowed user.
Error unfollowing user.
You have successfully recommended
Error recommending user.
Email successfully verified.
User Avatar
$20 USD / hour
Flag of INFlag of IN
darri,
india
$20 USD / hour
It's currently 3:57 PM here
Joined November 12, 2012
6 Recommendations

Virendra Singh B.

@vsprybhanu

monthly-level-three.svgpreferred-freelancer-v2.svg
4.8 (133 reviews)
4.8 (133 reviews)
6.1
6.1
$20 USD / hour
Flag of INFlag of IN
darri,
india
$20 USD / hour
96%
Jobs Completed
97%
On Budget
88%
On Time
15%
Repeat Hire Rate

Excel VBA Macro Developer, VB6 & VB.Net Programmer

Welcome to my profile. I provide world class Data Analysis Services with Excel VBA and Python. Excel has various functions and commands that can be customized with VBA programming (Macro). I can customize all functions of excel and make it very useful for your business. Some important features of Excel that can be automated- Split any large string into fields, Manipulate rows and columns, Data Exchange to Word, Access, SQL and MySQL server, Conditional formatting, Sorting, Find and Replace, Creating UserForms and much more. I can develop WrordPress websites with WooCommerce for Online Store, Real Estate, Blogging etc. I use Elementor, HTML, CSS and PHP to create websites. So, if you need Macro OR Web Development service then please give me a chance to prove my skill.
Freelancer
Visual Basic Developers
India

Contact Virendra Singh B. about your job

Log in to discuss any details over chat.

Portfolio Items

I created Excel VBA Program to search specific Barcode in excel file and print searched record as Label (width 65mm, height 29mm) with Barcode in Brother QL570 label printer.
Label Printing in Visual Basic
Client had Dashboard where all data was calculated with Formulas and she wants to replace all the Formulas with VBA Programming. So, she needs an Excel VBA Program that can replace all formulas and give correct result. I have created VBA Program to fulfill this requirement of my client and she is very satisfied with my work.
Dashboard with Excel VBA
This program will create custom mail merge with MySQL and Excel Database. It is MS Word VBA Macro in Add-Ins format. So, you can add it into your Word ribbon and use like a standard MS Word Command. I use Visual Basic program to create this Macro.
Mail Merge with MySQL and Excel
This program will create custom mail merge with MySQL and Excel Database. It is MS Word VBA Macro in Add-Ins format. So, you can add it into your Word ribbon and use like a standard MS Word Command. I use Visual Basic program to create this Macro.
Mail Merge with MySQL and Excel
Its a VBA Program for mathematical calculation of trading. All windows elements are used in this program. For example - Text boxes, Drop Down, Option, Command Buttons etc.
Mathematical Calculation
Client had requirement to apply formulas into various locations to automate the work, exchanging data between sheets, using drop down box, validation and conditional formatting. I have done all these things by Excel VBA programming.
Excel spreadsheet
Background:
I run a small retail business and I would like to better understand my sales performance and trends.  I am able to export a .csv file from my point-of-sale system which contains a portion of sales data.  The attached orders.csv file contains some data from January 2015 through mid-March 2015.  

Rquirements:
I would like to have an Excel spreadsheet which would allow me to import these .csv data files into a single “Sales” sheet on an occasional basis (likely once per month).  I would then like a “Summary” sheet which presents some key performance indicators in both data table and chart form. 

NOTE: While it would be neat to do so, I do not need to track Product Code; however, you will notice in the orders.csv file that there is often more than one row per order number (see row 3 and row 4).  This happens when a customer orders more than one product type.  For my purpose I need to combine those records into one and simply enter the total quantity sold amongst all products
Creating Dashboard in Excel VBA

Reviews

Changes saved
Showing 1 - 5 out of 50+ reviews
Filter reviews by:
5.0
$45.00 USD
Great job, awesome.
Visual Basic
Data Processing
Excel
Visual Basic for Apps
VB.NET
C
Flag of KH Chanrith C. @Chanrith99
2 days ago
5.0
$80.00 USD
Good job on a complex XLS macro
Data Processing
Data Entry
Excel
Visual Basic for Apps
Excel Macros
User Avatar
Flag of US Monty M. @WebDesign27
1 month ago
5.0
£20.00 GBP
Again as usual Viren delivered with a high quality of programming and logical skills.
Visual Basic
Excel
Visual Basic for Apps
User Avatar
Flag of GB Thiruvilan A. @thirudesignguru
2 months ago
5.0
£40.00 GBP
Viren quickly understand the project requirement and communicates very well. He delivers work in time and with clarity. I will again hire him for my future requirement.
Visual Basic
Excel
Visual Basic for Apps
User Avatar
Flag of GB Thiruvilan A. @thirudesignguru
2 months ago
5.0
$9.68 USD
He did excellent work for us.
Data Processing
Excel
Excel VBA
Excel VB Capabilities
User Avatar
Flag of US Makroteks T. @makroteksllc
2 months ago

Experience

English to Hindi translation and Social Media Marketing

WENDS (UK)
Jul 2017 - Nov 2018 (1 year, 4 months)
I was working on this company as a translator. The company used to give me content in English and I used to translate it into Hindi. After the translation, I used to post the translated Hindi content in the company's Facebook and Twitter accounts.

Developing Work Management And Payroll System

UNICOAST (USA)
Sep 2015 - Sep 2016 (1 year)
I have developed a complete system to maintain work, employee and payroll system for a company UNICOAST. The system is developed by using Excel VBA Programming. I used all windows elements like Drop Down, Text Boxes, Command Buttons etc. to make the system user friendly. It has also ability to create pdf report and send Email through Outlook.

Education

MA

Guru Ghasidas University, India 2012 - 2013
(1 year)

Qualifications

The Fundamentals of Digital Marketing

Google Digital Garage
2020
The Fundamentals of Digital Marketing exam by Google Digital Garage.

Hardware and Networking

Govt.of India, Ministry of Small Scale Industries, Small Industries Development Organization, Raipur, Chhattisgarh, India
2004
I learned during this training - Computer Architecture, Computer Fundamentals, Various Basic and Peripheral parts of Computer, Trouble Shooting, Networking Concepts, TCP IP, Bus Networking, Star Networking, P2P Networking etc.

Business Professional Programmer

DOEACC Society, New Delhi India
2003
One year Computer Course from DOEACC Society New Delhi, India. In this Course I learned Advanced PC Software - MS-Word, Excel, PowerPoint, Access, Windows Operating System and Programming Languages - Visual Basic, FoxPro etc. DOEACC Society is an autonomous body of Department of Information Technology, Ministry of Communication and Information Technology, Govt of India for accreditation of Computer Courses under the AICTE-DIT Scheme.

Contact Virendra Singh B. about your job

Log in to discuss any details over chat.

Verifications

Preferred Freelancer
Identity Verified
Payment Verified
Phone Verified
Email Verified
Facebook Connected

Certifications

preferredfreelancer-1.png Preferred Freelancer Program SLA 1 89% numeracy_1.png Basic Numeracy 1 88% freelancer_orientation.png Freelancer Orientation 1 80% vb6-1.png VB6 Programming 1 80% vb1.png VB.NET 1 77%

Top Skills

Visual Basic
99
Excel
99
Data Entry
45
Visual Basic for Apps
36
SQL
15

Browse Similar Freelancers

Visual Basic Developers in India
Visual Basic Developers
Excel Experts
Data Entry Clerks

Browse Similar Showcases

Visual Basic
Excel
Data Entry
Visual Basic for Apps
Previous User
Next User
Invite sent successfully!
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2021 Freelancer Technology Pty Limited (ACN 142 189 759)
There is no internet connection