I am looking for someone to write a macro that will automate my bank reconciliations by matching transactions exported from a bank account with transactions exported from an ERP.
The macro will review bank statements and ERP statements; compare them; match off same items and list out outstanding items (items that were left umatched).
In order to fully

Excel Macro to create TOC and loop through each page and collect data from cell.
please only offer if you are VBA expert.
There are existing code online to generate a table of contents but I'm looking for extensive updates to the code.
Job should only take 15 minutes for an VBA expert.

...([kirjaudu nähdäksesi URL:n])
A VB script macro is required to turn "on" the relay and another macro is required to turn "off" the relay.
The macro file (.m1s) is executed upon a g code command as the software runs.
The usb relay is on COM4.
I need someone to write the 2 macro files ("on" & "off")
Ref
[kirjaud...

ADVANCED EXCEL VBA PROJECT - Macro Experts Apply
REQUEST FOR YOUR PROPOSAL:
Introduction:
We are looking for an Expert Excel VBA automation specialist for our project.
Deadline:
We would like this entire project fully delivered and tested within the next 7-10 days MAX.
Our Project Requirements:
*** AFTER YOU REPLY TO OUR 13 Questions We Will

Looking for an expert excel macro coder
I want the user when he opens the excel sheet and click the run button which is in the sheet he will be asked several questions in a quiz format and after he finish the answers will be filled in the corresponding cells accordingly.
There will be more than one Run button. for Example Run 1 (set of question to

Looking for somebody to do a couple of calculations based on the attached sheet. It is based around goal times . I did have somebody hired who did the original work, but is no longer available.
I need a calculation for when a goal is scored after 84 minutes.
I need a calculation for when two goals are scored between 46-60 minutes. This can be more than two goals as long as the second goal is bef...

I have a Macro that I use and works well, it finds duplicate words in a cell and puts them in the next cell so I can edit
so if the cell had
big red dog with big collar ------ it would put ---- big big in next cell
but if it was
big, red dog with big collar
then it sees big, with the comma as a separate word
there may also be other characters

Please Provide List That Includes Following Criteria and amount :
- Years in Business 1 - 12 / Since 2007
- Cellular Phone Number
- Email
- Revenue
- Name, Business name
List needs to contain 50k names and up
csv or excel file only

I need to normalize treatment data points compared to the average of each individual's normal values. Please see column E in spreadsheet for th... Please see column E in spreadsheet for the example formulas. I would like the results to appear in sheet 2. I could do this for all columns, but there are over 400. Can a macro even be generated to do this?

*Only bid if you can complete the project by 1/19/19 6:00 PM Eastern Standard Time*
I'm looking for a developer to build a basicmacro to extract Excel data and place it into a Word document. If you think another output format would be better, I'm okay with discussing it. Perhaps having an output in Excel vs Word would be better, however I need to

...sheet tab:
1- Want to make macro assigned to checkbox1 that autosave the workbook every 15 minutes without any messages or prompts just save the file on intervals.
2- Want when uncheck the checkbox 1 that autosave the workbook every 15 minutes to stop the autosave macro
3-Want to print latest macro save timestamp on cell E18 on "Data" tab
4-Want to

...summary sections are created based on the data available in 'Account Details' sheet.
We need to build a macro which upon execution (some trigger like cell change etc.) will create hyperlinks for each of the values in these 4 summary sections - for each cell column 'E' onwards.
Once the respective hyperlink is clicked, it should navigate to the 'Ac...

We need a VBA developer that is experienced with Excel, VBA, and Jira. Need an Excel macro to connect to Jira query for Epics, stories, linked test cases, bugs found during testing. I have all of the JQL needed to find the issues in Jira.

We need a VBA developer that is experienced with Excel, VBA, and Jira. Need an Excel macro to connect to Jira query for Epics, stories, linked test cases, bugs found during testing. I have all of the JQL needed to find the issues in Jira.

...sheet tab:
1- Want to make macro assigned to checkbox1 that autosave the workbook every 15 minutes without any messages or prompts just save the file on intervals.
2- Want when uncheck the checkbox 1 that autosave the workbook every 15 minutes to stop the autosave macro
3-Want to print latest macro save timestamp on cell E18 on "Data" tab
4-Want to

We need a VBA developer that is experienced with Excel, VBA, and Jira. Need an Excel macro to connect to Jira query for Epics, stories, linked test cases, bugs found during testing. I have all of the JQL needed to find the issues in Jira.

Here's a deal. I've an Excel Macro written by a freelancer. It simply takes Excel Spreadsheet and converts data from Horizontal to Vertical (similar to Transpose). However, we added a couple of more columns in spreadsheet which changes the 'if loop' logic to a little bit (Changes STEP 7 to STEP 9 in Excel, changes title of Columns from B:Y to B:Z, for

We need a VBA developer that is experienced with Excel, VBA, and Jira. Need an Excel macro to connect to Jira query for Epics, stories, linked test cases, bugs found during testing. I have all of the JQL needed to find the issues in Jira.

We need a VBA developer that is experienced with Excel, VBA, and Jira. Need an Excel macro to connect to Jira query for Epics, stories, linked test cases, bugs found during testing. I have all of the JQL needed to find the issues in Jira.

We need a VBA developer that is experienced with Excel, VBA, and Jira. Need an Excel macro to connect to Jira query for Epics, stories, linked test cases, bugs found during testing. I have all of the JQL needed to find the issues in Jira.

Looking for an expert excel macro coder
I want the user when he opens the excel sheet and click the run button which is in the sheet he will be asked several questions in a quiz format and after he finish the answers will be filled in the corresponding cells accordingly.
There will be more than one Run button. for Example Run 1 (set of question to

Wholesale/e-commerce clothing business based in the Republic of Ireland
1. We download our orders off various websites into a excel file - each row is an order with details an individual header.
2. We would like to automatically created a new worksheet (template that we already use - formatted into a job sheet) from the individual rows of orders in the downloaded excel sheet.

We need a VBA developer that is experienced with Excel, VBA, and Jira. Need an Excel macro to connect to Jira query for Epics, stories, linked test cases, bugs found during testing. I have all of the JQL needed to find the issues in Jira.

We are trying to extract the data from a [kirjaudu nähdäksesi URL:n] DB format. No one here has windows and we need the format in a standard Fix delimiter or BAR format.
These are some of the files on the CD:
.ISM
.DAT
.MAS
They gave us [kirjaudu nähdäksesi URL:n] to access the file. These are the files in the dir:
[kirjaudu nähdäksesi URL:n]
[kirjaudu nähd&a...

I am trying to make a property inspection report that has 125 lines of questions and answers that have a pull down list. I have this done but I can not figu...report that has 125 lines of questions and answers that have a pull down list. I have this done but I can not figure out how to take a picture and have it place in a designated cell with notes.

Universal Talk Time Limited is a Zambian company operating in the telecommunication space.
The company would like to design and launch a mobile phone for sell in Africa and would like to design packaging box.
Example of product and pone is attached

See the sample file. I need that everytime I run macro, it creates an output excel file as follows:-
Each listing will be repated 11 times. What I need the in excel output is as follows:
1) From sample file Column B (Title) - Output File Column A (Title)
2) From sample file Column C (Description) - Output File Column B (Description)
3) From sample

We have images that are solid black PNG’s. We need a macro to run a batch of images Corel to convert the images to a solid solid white image.
Do be considered for this job please let me know what day of the week it is.

Looking for a LBS provider, who can provide us the LAC code and the cell id of a MSISDN using a HTTP API.
(You have to do perform a SS7 MAP Anytime interrogation query to get the LAC and cell ID from the VLR.)
We would pay a setup fee and a fee per query.
Please do not bid if you are not able to provide LBS services(HLR/VLR/MSC lookup)
Please provide

I need someone to help me better understand how my installation of these version control tools actually works, and I need to be able to see changes daily from my phone.
This person needs to have a strong command of the English language and good voice communication.
You will not have access, this needs to be instructed via communication only

We import data from our support tool and this data contians Technician Name, Date and Time, Duration of call. Also, it contains session details column with Email address, Organization name, Phone Number, Reason to connect all in same column. I need all this data to show in neat format. Also, I need auto report generated with following details
1. Average calls handled by agent per day/month/year
...

I have a macro that scrapes a website in Chrome - and while it still runs, the macro previously would keep clicking a button on the site until more data was displayed. This is no longer working, and it is not finishing cleanly, it seems to be stuck in some loop when it should have finished.
Small job, budget A$12

...complete this project. This project was previously posted and freelancer was unable to complete the work because of this.
The Project:
I am trying to find someone to build a macro within Outlook Customer Manager. When a custom button is clicked, I need it to create a series of tasks that are associated with that customers profile. I created two custom

I need a script making which will import a CSV into excel and then put the data into an easily readable, print format pick list in HTML.
Check the attached file and take a good look a the first sheet.
If you've actually looked at the document, read everything and have put a realistic, and informed bid, then start your proposal with the words 'No Placeholder'
I can supply a snippe...