スキル

言語

ジョブステータス

PHP Web designer
I currently have an outdated Smarty template running on my admin/CRM website. I would like to change it to a more modern template in bootstrap. There is currently I a lot of code embedded in the template; so, one will have to have the below skill sets to be able to successfully complete this project.
• PHP
• HTML5
• Web design
• CSS

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

...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 or other language) as

...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 or other language) as

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

...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 or other language) as

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 Excel VBA is welcome.
Candidate must be ready to share similar previous projects.

...the comma as a separate word
there may also be other characters causing issues but so far only seen comma, so provision for others would be required
this is the macro I am using now,
Sub FindDuplicates()
Dim i As Long
Dim j As Integer
Dim k As Integer
Dim WS As Worksheet
Dim WordArr As Variant
Dim DubStr As String
Dim WordCount

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

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

I am testing my web application and i need someone who is able to do a simple task.
The Task is:
- reload the page and keep clicking on a particular button
(IMPORTANT: You must reloadusing a different IP address) you can use some IP generation app or something.
I need you to do 150 repeated clicks daily for 6 days
Simple task which you can automate

...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. Existing rows will be locked for editing. When the employee, the "operator" adds a new row we want that row locked. For accountability

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

...send email WITHOUT ANY PROMPT TO SEND JUST SEND IN THE BACKGROUND WHEN button "Print end of day" in "balance1" tab pressed (add this function to this button after running its current running macro)
5- want the user to type the Emails to be sent to and CC in Fields B23 to B40 so that no apps or popups prompt the user to send emails( just send it in the background

...programmer. I want a programme that will open a specific 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

...EXCEL VBA 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 Using Excel

...business using Microsoft Access and Access VBA’s.
We are a customizable, healthy meal delivery company and I need a Microsoft Access expert 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

Looking an Excel & AccessVBA 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.

...send email WITHOUT ANY PROMPT TO SEND JUST SEND IN THE BACKGROUND WHEN button "Print end of day" in "balance1" tab pressed (add this function to this button after running its current running macro)
5- want the user to type the Emails to be sent to and CC in Fields B23 to B40 so that no apps or popups prompt the user to send emails( just send it in the background

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

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.

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.

...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 with the flexibility of Excel and VBA, coupled with the infrastructure that powers a trading

...ribbon [ログインしてURLを表示] because I think this is causing the performance issues in my excel file. Please add the similar icons also. Let me know if I need to do any changes in VBA.
For any testing please add the xml code to your blank excel file (for example via Custom UI editor). If you can recommend me better xml ribbon editor let me know.
Please do

...create and change events) happens then it should set to false and reload all xml files
//we need to need to set [ログインしてURLを表示] = false;
//call load xml files (reload all xml files from folder and again assign it to static dictonary)
//reload all xml files and assign it to satic dictanory
}

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

We currently have a working copy of one Word Document that uses 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

...calculate employee raises based on stores volume. The "Wage Reco" tab is connected to the VBA script that gives tiers to each volume for minimum, mid ans maximum salary. Right now there is four tiers and the new tiers (Copy of RGM wage and grade) has 14. Looks like the VBA script uses offset to calculate the item. Also, would need to make sure these changes

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.