The current excel sheet and VBA code checks for column B and Column D. Whenever there is a value in Column B that does not exist in column D, the script removes that row of Column A/B and shifts the next (of those columns ONLY) rows up.
For example if D3 does not match B3, then we must delete C3,D3 and E3 and move C4,D4,E4 up. It also does the same

Build a completely new application – from scratch – using an existing Application which was created in Excel using ODBC connections to a PostgreSQL Database Accounting Application called Spire.
The objective is to build a new SPOKE application in Python 3.7.x.
This means you will need to build a UI interface from scratch (your choice of using Python

Build a completely new application – from scratch – using an existing Application which was created in Excel using ODBC connections to a PostgreSQL Database Accounting Application called Spire.
The objective is to build a new SPOKE application in Python 3.7.x.
This means you will need to build a UI interface from scratch (your choice of using Python

ADVANCED EXCELVBA PROJECT - Macro Experts Apply
REQUEST FOR YOUR PROPOSAL:
Introduction:
We are looking for an Expert ExcelVBA 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

Data need to be pulled from a factory PLC. Here are the main requirements:
PLC: Simatic S7-414...factory PLC. Here are the main requirements:
PLC: Simatic S7-414 6ES7414-3XJ00-0AB0
Communication protocol: Profinet
Communication interface: Ethernet
Any solution using ExcelVBA is welcome.
Candidate must be ready to share similar previous projects.

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 causing issues but so far only seen comma, so pro...

using a premade Form
Create a Formula that searches five Columns of a database by using "Command" buttons to chose a feature of the item you want. Then use a Text Box to enter a value of number of items required---go to the Column that matches the results of the five features that lined up. multiply the number in the text box with the---the results will be placed in text box at the end o...

I have data in excel files such as - date, time,symbol, buy/sell, qty, price.
i want vba codes to find first transaction of any day for particular symbol( buy or sell) and later for same symbol on same date - it should add/reduce qty from first transation qty
eg. first transaction is sell - it should display qty as "-" and later for same symbol it

I have data in excel files such as - date, time,symbol, buy/sell, qty, price.
i want vba codes to find first transaction of any day for particular symbol( buy or sell) and later for same symbol on same date - it should add/reduce qty from first transation qty
eg. first transaction is sell - it should display qty as "-" and later for same symbol it

Hi Oleksandr. This is my request for you to provide the Outlook VBA script modifications so it will also trigger "email to text" message sending like before, but now using different email format. I will be happy to write a 2nd great Freelancer review after you are done again. Thanks again. Jim in Toronto

...paper form, adding a row for each visit. We would like to replace the paper with entries directly into Excel. The employees will not be asked to learn the details of Excel, so we need to add some automation.
Each client site will have a separate Excel file (hosted on Dropbox or similar for shared access) and we need a template from which to create them

...I've added sample calculation to get "Result" worksheet. Since this is repetitive work and the dataset may contain hundreds of data, I was wondering if there any way to write VBA code to get "Result" worksheet from the "Data set".
What I did manually is: creating pivot table > copy filtered data to new worksheets > processing new worksheets > ...

I need two VBA subs written to automate certain portions of my workflow.
1. Write a sub that triggers when I receive an email from "______" sender with "_____" subject name. Sub is simple... open email attachment, copy contents, open file on desktop, paste contents, save desktop file, close desktop file, close email attachment.
2. Write a loop

Hello,
I want to make aproject that makes the follow to my 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

...website. It will download pdf files from it and then transfer content from those files to an excel (again programmed with VBA) to sort contents in columns.
The programme should also be able to open 2-3 more websites and download query results into the same excel and compare these results with the contents from the previously mentioned PDFs.
I thank you

Expert EXCELVBA Developer Needed ASAP - Work From Home
Want to Work from home on Various Exciting and Challenging Projects?
We are seeking to hire a Team member who has an EXPERT STATUS in ALL these following areas:
• Expert in VBA Application Development in Excel;
• Expert in All Excel Functions and Formulas;
• Expert in Process Automation Us...

...that can design database specific to my needs that will integrate fully with the online CRM that my company currently uses.
The CRM provides new orders as both emails and Excel reports thus This Access App needs to have the following major capabilities.
In take:
Order Intake (automatically taking the information from the email, and constructing a

Looking an Excel & Access VBA guy to work behalf of my company. I am looking for full time position, Not for just few months. I already have an excel guy but we have lots of projects. So looking to hire one more person. Its an ongoing position for right person, For couple of years.
I prefer someone from Venezuela and Peru.

Hello,
I want to make aproject that makes the follow to my 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

Want a simple yet super fast method to insert a list of data in array OR a Range to Azure SQL.
1. The method should be able to dynamically assign columns name.
2. The insert method must do a batch insert instead of one by one.
3. The method should be able to insert 10, 000 records within 20 seconds or faster.
4. Please don't use the ExportRangeToSQL method from the internet, I already ha...

I want a CRM created Using Excel and VBA.
Files Need to be copied from raw data sheet and a dashboard need to be created using the raw data and calculations and formulas.
Message to get full review of the project before you start.
Thank you

Wholesale/e-commerce clothing business based i... 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.

OpenAPI for Excel is an add-in that ports a broad range of OpenAPI functionality straight into Excel. I need a programmer well versed in VBA techniques and procedures to install, implement and setup an excel platform using procedures provided by the provider of the OpenAPI service using Microsoft Excel (2010 and later)
OpenAPI for Excel provides you

The Clear All button will
1, Uncheck all the checked CheckBoxes
2. Clear all contents in rows E6:E16
3. After 1 & 2 is complete, reps will then start checking the boxes in column AW for the reasons they want to display from column AW. These will then get listed starting in E6. After the reps completes checking the boxes, the data from column AW will display is column 3.
4. Blanks that app...

I want a CRM created Using Excel and VBA.
Files Need to be copied from raw data sheet and a dashboard need to be created using the raw data and calcualtions and formulas.
Message to get full review of the project before you start.
Thank you

...a form created with VBA that captures data in the form and exports to excel. We have three other documents that need to be duplicated using the same VBA code structure to create a form that is the same as the Word document, allow input to the form, the input to the form is saved back to the Word document and then exports to Excel. One added feature for

Hello there!
I have some ecxel spreadsheets where is a lot of information,
I want to make this ecxel sheets more informative...more informative,
and for this i want some worker who can add some tables da formulas there
to see statistic information and many more.
So i want person who know ecxel and vba in advance.
Please don't bid if you can't do it.

VBA Script in Excel to take information based on date ranges, from three different sheets, to produce batch documents with the same layout a template
NOTE "Outline formatting would not paste into Freelancer Table"
Need this weekend.
• Availability- Must be Immediate.
o We have to turn in documents for a job we completed by Sunday afternoon
• Overview

I want a CRM created Using Excel and VBA.
Files Need to be copied from raw data sheet and a dashboard need to be created using the raw data and calcualtions and formulas.
Message to get full review of the project before you start.
Thank you

I want a CRM created Using Excel and VBA.
Files Need to be copied from raw data sheet and a dashboard need to be created using the raw data and calcualtions and formulas.
Message to get full review of the project before you start.
Thank you

Hello,
I have a multiple changing values in multiple sheets what I want is to make a button that type all numbers that are connected to foumula to non formula cells for example:
Name: [login to view URL]
Views: 13
Size: 209.9 KB
I want a button that when pressed all values that resulted from formula in cells (C33:K33) to be typed to (C2:K2) with no formula and can be removed when needed also I...

*the budget is just a place holder, please quote what you think fair and will get excellent solution for b/m described tool
I am looking for a way to transfer my excel workbook that has VBA macros to be an online tool, it is a sheet that is used to create three reports automatically,
i want the users to be able to login, add/change information then

I want a CRM created Using Excel and VBA.
Files Need to be copied from raw data sheet and a dashboard need to be created using the raw data and calcualtions and formulas.
Message to get full review of the project before you start.
Thank you