Tìm Công Việc Trên Freelancer

I need to automatize the execution of a XLS proyect.
I have 3 files, 01, 02 and 03.
In the ejecution of 02 I have to select an option to execute the calculation(I have 2 ways to make the calculate), the location file 01 by explorer, and the location file 03(give the route to the file).
I think in an solution (Doc N4) Who insert the route to the file 01 and 03 in a Cell, and the route of 02 in a...

I have one (1) Excel spreadsheet with contact data in a single column (column A). I need to convert both of them into multiple columns (NAME, TITLE, COMPANY, TENURE, LOCATION). There are approx. 6000 rows in the spreadsheet and approximately 400 total contacts.
The first two rows have been completed in the spreadsheet as an example. It's highlighted in green.
Single column needs to be conve...

I want someone to scrap data automatically from the given financial websites using EXCEL Macro. Then apply some formulas to calculate some desired output. The macro should be fast to bring the output. Use the graphs
Below are some websites for your reference
[login to view URL]
[login to view URL]
[login to view URL]

I have 296 test scripts i have to execute from 5/23 to 7/12. i need a burn down chart that i can report on daily. I also need help to update an existing excel sprint result sheet FRO EXAMPLE , so i need to add one more sprint 15. i have sprint 1 - 14 , so i need to add 15

I have a fIle that contains all my Sent Emails combined with Agenda.
The files tells also the 1st and Last action of the day that could be an Email or Agenda event
The goal was to define time worked every day starting with a sent Email or Meeting and ending the same way.
I would like to convert the file into a calendar compatible file with Google agenda or Outlook.
The fill will contain the whole ...

I have developed an excel file to help managers enter budgets then for it to upload into our system. There is some conditional formatting and some Macros that do this.
I want to make the file more efficient (Without losing too much functionality) to run faster and be smaller to email out.

Background: We have approximately 60 separate excel files that contain approximately 50 tabs each. Each tab contains the same columns but different row data. Some files contain similar row data but not identical. The data relates to retail locations and the price of a product on a given date. Each tab on the file is a different state within the USA.
The Desire/Intended Outcome:
• Have...

I have an excel macro that takes data from an excel workbook, and generates multiple outlook email messages from the data in the excel workbook. This code works right now in windows excel, but not with mac excel. I need to make this code compatible with mac excel.

I am looking for someone with extensive excel knowledge using macros and visual basics to build a custom workbook with a multipage user form for our local insurance agency. I expect this project to take 8-12 hours plus initial design discussions.

We have a environmental program that is based on an excel spread sheet. Its called an Environmental Management System which is a process including assessments, planning and checklists etc...
The tool is not about 5 years old and looks very dated and unprofessional.
We are looking for a talented innovative person to come to terms with how the process works and to improve the flow and efficien...

Review and analyze the following Department of Economic and Community Development – Business Assistance Portfolio data for the state of Connecticut. Identify key performance indicators within the data for industry growth opportunities.
About this data:
Department of Economic and Community Development's listing of active, direct financial assistance to businesses from Fiscal Year ...

Hi I want the person who is good in excel tutoring and make good videos for excel and VBA. Before awarding atleast one sample is required. More details in message
Only $2 per hour is the budget if you bid over than that you will not be selected
we need 100 or more than that videos need to be created.

We are a company that provide design, fit out, refurbishment and furniture services for businesses and schools. ([login to view URL]) We need someone to build our quotation template in Excel into a cleaner and faster tool that we can use for producing quotes as efficiently as possible. Our quotes are very varied and very complex in construction. I would like to discuss in much more detail with int...

I have an excel macro that takes data from an excel workbook, and generates multiple outlook email messages from the data in the excel workbook. This code works right now in windows excel, but not with mac excel. I need to make this code compatible with mac excel.

I want a macro that can be used to restrict each cell to only two lines of text and each line not exceeding a certain number of characters that can be specified for each selected group of cells. The macro should not allow the user to exceed those parameters during editing of the cell (as opposed to alerting the user after the fact).

I want a macro that can be used to restrict each cell to only two lines of text and each line not exceeding a certain number of characters that can be specified for each selected group of cells. The macro should not allow the user to exceed those parameters during editing of the cell (as opposed to alerting the user after the fact).

PC app on the easier language for microsoft OS
Process description:
Register by user of amount objective (ex.: 40)
Register number of lines that will contain numbers
Register tax percentage (by default 21%)
Register a line with fix value for calculus
Register a line with a fix value for calculus:
Step 3 multiplied by 21%
Register value for every line
A line for tax value, will contain t...

BOM = Bill of Materials. It is a document used that has details of all the raw materials that are needed in order to produce one unit of a finished good.
In the Macro, we need each BOM to be in a particular format in one sheet only. The Macro helps us to create a BOM in a separate sheet for any one of the Raw Materials present in a parent BOM by the click of a button.

A few years ago, a Freelancer made us a macro that would pull information from 2 different web sites. Over time, the websites changed and the macro code no longer matches the original fields. The result is that no information is pulled from either site.
I've attached the old macro (an EXE file). When it was working, the EXE file was located in a directory named "Import" that h...

I'm a small business owner (Residential Design Build)
Our Estimating and Contract development is on Excel. It needs fine tuning, changes etc. to be more effective. Between a busy work day, and lack of knowledge we do not have time to do this ourselves and are excited to see how a real expert could advance and improve our system.

I have the list with people - their photo, name or nickname and number of projects they backed on kickstarter.com. What I'd like to ask you is find their profiles on social media acconts or their emails. Are you willing to do that for me?

I have some interference analysis forensic models that I need to convert into R. I learn best by examples so I would like someone to convert 2 macros (BuildReport, batchtri) into R as a starting point. The other thing I would maybe need is an overview of the R environment, composing, debugging, etc.

Hi everyone, i would like to hire someone to make a vba module for sending token to Deathbycaptcha server and get the result from their recaptcha v2 by token api.
It should be enough easy for experts, they offers documentations but not for VBA (there is PHP, PYTHON, JAVA, C#.net, VB.NET and imacros) you can get all the documentation on their api page.
I need a module where i will put my DBC user...

I need a web app built that will link several (minimum 6) other tablets or PC’s to:
1) enter data into several sheets in excel over a 3 day period
2) transmit only selected sheets within the excel document data 1 at a time to my master sheets
3) tag identifiers on the data as it comes into my master so I can identify where it comes from.
4) constantly backs up all entered data on the oth...

Please find attached -
1. Samples of Raw Data (Usually Exported from Tally into Excel) that would be the input for the Macro
2. The required output from the Macro from the above sample is in the next sheet in the same workbook
3. Workbook (Macro Patterns and Format) - This Excel workbook contains a list of various data cleaning steps and validations/checks that are required to produce the desired...