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

ExcelMacro 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.

...([accedi per visualizzare l'URL])
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
[accedi p...

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

I have an Excel file, which has some calculation in it. The Excel file has 4 cells (like A1, B1, C1and D1). The 4th Cell has a complicated calculation (D1). I need a Powerapps to connect the Excel file, the user enters 3 values (in A1,B1,C1) then Powerapps send the values to Excel file and return the result (D1)to Powerapps and show it to the user.

Looking for an expert excelmacro 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

...cell of the matrix there will be an image of an abstract 3d object.
• At the center of the matrix is the object that needs to be recreated (target object)
• In the surrounding cells there are the objects that can be used to recreate the target object
• The task of the test-taker is to choose minimum 2, maximum 4 objects that will exactly recreate the target

...can be accomplished with these instructions: [accedi per visualizzare l'URL]
I also need to set up conditional formatting that pulls from other cells in the workbook.
Pls check attached video and understand it. After that , pls give your proposal.
You must get solution to do this and show me its demo sample.
You must write

This is a r...from several excel sheet tabs into one single spreadsheet.
We estimate that this will take a couple of hours depending on how fast you can copy and paste.
Deliverables:
- Copy text from 33 different tabs
- Paste them on a single consolidated spreadsheet
- Format the cells
Requirements for the project:
- Experience with Microsoft Excel

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?

I have an excel spreadsheet that I need to add some Macro too ( code) . I have two buttons ( one for adding rows and one for deleting rows ) , when I click on button one I would like to have an code to add one column to bottom of sheet and the same for deleting row.
Next all the cells(yellow) that I need to add data I would like a pop up window to

...profits and outgoings. For now, we use excel files as databases, but we would like something more dynamic, professional and with the option of having a better view of our business. I've already created something in MS Access but I'm not experienced enough to make it work.
Note: The basic database tables cells we need can be found in Databas1.0_Backap

...basic macro 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 have it printed in quarter sheets.
Here's the VBA logic...
1. Users will have data populated in the "Data File" Excel fi...

...existing excel workbook :
Inside "Data" 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

...and the budget listed is for completing 10,000 rows.
Your job is to review each row to see if there's data listed in the cells of the following columns:
- Username;
- E-mail;
- Phone Number(s);
- Street Addresses
For the cells with that information, you will have to go back to the corresponding Instagram profile to validate that the information listed

... This takes the list above and separates the boxes and adds titles to the cells. Therefore, these labels can be cut and added to a pdf.
An example of the packing can be seen in excel sheet. The process of the tool will work as follows:
USER
1. FRONT SHEET: User enters ‘FILL AMOUNT’ how full they want the boxes. The boxes should not be filled with

I need a 10 second scientific 2d animation about a vesicle that penetrate skin squeezing between superficial cells intact reaching deep layers where it finally releases its content.
This is a part of a bigger project, hope to find a partner for future collaboration.

We have an excel sheet which contains the following summary sections -
1) New_Credit_Facility_Summary
2) Credit_Profile_Summary
3) Borrower_Summary
4) Additional_Status_Summary
These 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

...this project documents. The template will be delivered to you;
(4) The documents provided must be ORGANIZED IN AN EXCEL CHART, classifying them by author, title, and separating each paragraph of the .pdf file in different excelcells.
HIGHLY IMPORTANT! – READ CAUTIOUSLY WHAT IS REQUIRED, MORE DETAILED INFO ARE AVAILABLE ON PROJECT TO DOCUMENT

...e. Wk 14-Wk7), 6 (i.e. Wk20-Wk14)
For set 1, in the occurance table, the title row can be numbers from 1 to 35, left most column can be Occurance 1, Occurance 2 etc. The cells should be filled up as per the example given above.
A similar table should be created for Set 2 also.
There is no overlap between Set 1 & Set 2 at any stage. Please note

...this project documents. The template will be delivered to you;
(4) The documents provided must be ORGANIZED IN AN EXCEL CHART, classifying them by author, title, and separating each paragraph of the .pdf file in different excelcells.
HIGHLY IMPORTANT! – READ CAUTIOUSLY WHAT IS REQUIRED, MORE DETAILED INFO ARE AVAILABLE ON PROJECT TO DOCUMENT ANNEXED

We need a VBA developer that is experienced with Excel, VBA, and Jira. Need an Excelmacro 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.

I'm looking for someone to build a schematic using Phidget (or Arduino) load cells and controllers to accurately measure human weight distribution in real-time. Need the ability to measure the percentage of weight from front to back and left to right. Would be ideal to have force plate wireless (Bluetooth or similar) and battery operated. Also looking

We need a VBA developer that is experienced with Excel, VBA, and Jira. Need an Excelmacro 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.

...existing excel workbook :
Inside "Data" 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

We need a VBA developer that is experienced with Excel, VBA, and Jira. Need an Excelmacro 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 ExcelMacro 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, fo...

We need a VBA developer that is experienced with Excel, VBA, and Jira. Need an Excelmacro 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 Excelmacro 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 Excelmacro 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.