Excel VBA projects — HireLancer archive

ID / Date Listing

HL-35141708

Remove Excel file protection

I want to remove password of a excel file

HL-35139228

Help med excel formula - very easy task

Will be discussed in private message

HL-35138883

Customfilter function in Excel

Custom Function should behave like filter function in Excel with one unique condition Ex. 1) let say I have table consist of fruit column, city column and Date...

HL-35136496

Build macros and format an excel model

Hello, for the project we would like to make an excel template more user friendly and not complicated for someone who doesn’t have an excel background specifica...

HL-35136251

Custom user function in Excel -- 2

Custom Function should behave like filter function in Excel with one unique condition Ex. 1) let say I have table consist of fruit column, city column and Date...

HL-35129558

Script Needed

I need one script for my business work.

HL-35129529

Google app script (Copy from one sheet to another)

Hello. I am looking for some who could start right away and already worked on Google app scripts. I need to see you past work so that we don't waste time. A) Th...

HL-35129472

Google sheet notification setup

need to setup up push notification on mobile device when column is updated with specific keyword

HL-35128296

Google app script (Copy from one sheet to another)

Hello. I am looking for some who could start right away and already worked on Google app scripts. I need to see you past work so that we don't waste time. A) Th...

HL-35127504

Excel formula or Macro for Stock Count

Hi, I am looking macro/script for below needs. I have inventory system which export products and we call it raw data. we looking to stock take time to time and...

HL-35127132

SCHOOL RESULT MANAGEMENT SYSTEM

I WANT CLASS WISE RESULT MANAGEEMNT SYSTEM, I'M ATTACHING MARKSHEET TEMPLATE ACCORDING TO MARKSHEET YOU TO ADD ROW OR COLUMN , 2 MAKRSHEET HAVING DIFFERNT( NUR-...

HL-35125614

Generate Analysis using Python Automation

Need to Manipulate Data and get in required format of excel file using Python Automation.

HL-35121974

Simple Excel Macro/VBA

I have an Excel sheet that I add Monthly tabs to. I need some VBA/Macro to update the Consolidated tab cells if tabs are added or removed.

HL-35120469

Automate Excel Task - Update Master Worksheet from Other Sheets 'Electric' and 'Bank'.

I have a workbook with 3 sheets Electric, Bank, Master and I want to update entries from Bank and electric Automatically to Master sheet as per condition. I hav...

HL-35118996

Google sheets 1 row breaks into 2

I have set of data in a Google worksheet. Each row is a set of data relevant to 1 transaction. Each row must be formulated to break into 2 rows, and will remain...

HL-35116717

VBA Help for simple project less than 1 hour

Create a script that loops through all the stocks for one year and outputs the following information: The ticker symbol - Completed Yearly change from the openi...

HL-35116304

Entering customer and account data from source documents within time limits. Compiling, verifying ac

Entering customer and account data from source documents within time limits. Compiling, verifying accuracy and sorting information to prepare source data for co...

HL-35115382

VBA Project URGENT

VBA Projects needs to be completed on an urgent basis. Majority is completed need to transfer over the automation to an updated file. Need to speak to an expert...

HL-35115214

Add and change some vba commands in a prepared file

Add and change some vba commands in a prepared file 1. When I click the edit button. I want the editor to open for me in a new window 2. Adding an edit button o...

HL-35112937

Revising VBA to work on MAC - MUST HAVE MACBOOK

Hi, I have an excel VBA that works on windows and i want it to be revised to work on MAC, very simple and should take couple of minutes for a person who knows t...

HL-35112576

Revising Excel VBA for MAC

Hi, I have an excel VBA that works on windows and i want it to be revised to work on MAC, very simple and should take couple of minutes for a person who knows t...

HL-35105052

Build a calculator in Excel.

I have a web based calculator that depending on the answers to the questions, the calculator gives you a certain answer. I would like this same function of this...

HL-35104488

Create an Agile program management dashboard in excel

Need someone who can create a program management dashboard for tracking of projects(multiple), resource wise allocation/mapping , milestones, timelines along wi...

HL-35104198

Labor Report

Automating hours sheet ,Abstract sheet and invoice for monthly billing

HL-35103619

EXCEL FOrmula/Macro/Coding

I want to look up a value in a column ( multiple values exist) and look up to match (another series of values) in another column and then add up all the values...

HL-35102978

Excel file to pull data from MySQL

We need help with the following: Excel file will have a field (key) input Your VBA code to create connection to MYSQL Query to be run in MySQL based on Key Outp...

HL-35096170

Proficiency in Excel, 6 questions

Looking for someone proficient in Excel, this test will take no more than 10 mins. 6 questions to complete Its very simple and im offering $10 cad for the indiv...

HL-35095123

School Yearbook WORD update 3

need a macro button solution to automatically make an image that is dragged to a Word page Go to Back, Behind Text and Fill the Entire Page (one page in a multi...

HL-35094587

Excel & Google Sheet Macros to Reconcile Bank vs GL

Need to run a macros to match exact amount from one tab to the other based on date. Also can be potentially multiple amount and to look at date range to reconci...

HL-35094283

VBA Script

I have one script downloaded from internet. Need to do some small modifications in it. Thanks

HL-35085676

SRS and UML task

I have 2 tasks regarding excel (SRS AND UML) to be completed withing 20 hrs. Need quality work attaching the work required. Deadline is very important. I have a...

HL-35085062

VBA - create script to retrieve data that meets criteria and create csv file with values that meet indicated criteria

This is the first step of a 3 to 4 step project. Utilizing VBA, create script and single button that with retrieve indicated data from csv file and create a csv...

HL-35074495

Data Science Trainer

We are looking for a professional trainer in PowerBI, SQL, Python, Machine Learning or Advance Excel. If you have expertise in either of the mentioned subject t...

HL-35073456

extract data from web site

extract handicap odds from https://www.oddsportal.com/soccer/australia/a-league/melbourne-victory-newcastle-jets-rVAWOFLt/#ah;2 into excel sheet and refresh the...

HL-35068601