Visual Basic Jobs

I have two excel files in my sharepoint i need to match the data from another excel sheet in Sharepoint which has pivot table . so i need to match 17 worksheets from that excel data .I want some to fix by using formulas/VBA.

Hello, I'm looking for an Excel expert to help me with a report. I have an existing Excel document that needs to be completed and the report is relatively straightforward. I need someone with experience in financial models, data analysis and presentation to be able to effectively analyse the data and present it in a clear and coherent manner. The final report should be error free and help me make data driven decisions. If you think you have the necessary skills then please apply for this project and let me know why you are the best fit for the job.

I am doing a report where I need to find the new data and add the data in the master spreadsheet

Automate extracting data from new sheet created every day , do the math and give output Create data visuals for the data extracted via apis connect api to excel

I'm looking for someone to design an Excel Dashboard for data display, analysis and reporting, as well as task management. The project will start from a rough version of an existing Excel file, which needs to be customized both visually and with data manipulation. The successful candidate will have experience working with Excel dashboards, and be able to deliver a professional-looking end product. Please provide examples of your previous works with Excel.

Hello! I am using the following VB6 browser: (Edge-Chromium)/page8 I have posted a question there, and this is the reply that I got and why I am now looking for somebody who can do it: I'd ask the developer who has programmed the C# interaction (with CEF), to write a similar js-function for you... WebView2 is using chromium as well, but as said, the DOM-interfaces are not exposed to the VB/COM-side here. Therefore you have to use "preloaded js-functions" to interact with the Browser-DOM "on the inside" of WV2 - and communicate with the outside via JSON-strings. Such a C#->js-v8 porting should not be that hard for the developer, who originally wrote the C#-stuff. All I can do here from my end, is to show you the "principle". Code: Option Explicit ...

Hi, I'm looking for some Excel formula help. I'm a beginner when it comes to Excel functions, but I need both creating formulas and checking existing formulas. I'm using Excel 2010. If you have the knowledge to help me out, please let me know!

I am looking for a Freelancer to help me with a logic correction in my VBA Excel macro. The output results of the macro are incorrect and I have an idea of what I expect the output to look like. All related elements of the macro are functioning correctly, however I need help troubleshooting the logic to ensure that the output results are correct. I am open to hearing creative solutions to rectify the issue in the most efficient and timely manner possible.

Stock managment files with advanced features

This is simple task. You need to attach file and hit button to import. Create form with attach file option. Hit a button File is imported into data table Notification import is done. Need to time data stamp data. Don't allow duplicate entry if dispatch date is already imported. Example file and how it looks in access are attached.

Hi there! I am looking for an experienced freelancer to help me with a project that requires the creation of an Excel document. The type of file required is an XLSX. I need to be able to enter the data myself and I will be needing formulas included in the spreadsheet. The ideal freelancer for this job should be knowledgeable with Excel and be able to provide the assistance I need to get my project done. I look forward to working with someone who can provide a quality service and help me with my project. Thanks in advance for your help!

I am looking for someone to help me create an Excel Automailer. My goal is to be able to send out automated emails from an Excel sheet, using Outlook as the platform. I would also like to be able to use the Excel sheet to manage customer data and/or perform calculations or analysis. I am open to customising the emails, but whether that is necessary will depend on the specifics of the project. If you have experience with this type of automation and can help me achieve my goals, please reach out and let me know.

I'm looking for someone he can make Quotation dinamac excel sheet And purchase order excel sheet dainamic

I am in need of a script, excel VBA or some way I can update prices between two excel sheets. I will be using Office 365 for this project, and the prices will need to be updated manually. I have two excel sheets. A price list sheet and a product sheet. Both sheets have a column with a sku number. The sku needs to be searched for in the price sheet and have the price inserted into the product sheet. I'm looking for a way to do this myself so I need something I can use repeatedly. Accuracy is extremely important. Please let me know total of how much the project will cost.

I need a evaluation for shipping forwarder on a monthly base. I get around 30 Excel Files with Data from Forwarder 1 2-3 Files from Forwarder 2 1 File from Forwarder per Month. That have to be combine together with 4 other Excel Sheets. At the end there should be data out of this ones. Like for the forwarder / the Weight / the countries. The Evaluation is really complex. It should work, that i can fill the data monthly and it will update automatically.

I'm looking for an experienced developer to help create an automated document filler for Pdf, Word and Excel documents. The application is to be incorporated to work seemliness with Sugar CRM. The system will be set up with specific data that I already have mapped out along with rules and conditions related to the data. I'm looking for an individual who has knowledge and experience working with these types of documents and is comfortable implementing this system. If selected, I would like to work closely with the developer to ensure the successful completion of this project. See Sample CRM data and PDF form.

I want to code an all in one document. I currently use an excel questionnaire which based on the clients answers creates a graph. I then copy and paste the graph onto a Powerpoint slide, add notes to this and send it to the client. This is very manual and is not very aesthetically pleasing. it needs custom coding I am looking for a way to have the questionnaire straight on the powerpoint document or similar which when completed automatically created the graph like the one on the attached PDF. If this is something that is possible I am happy to share the excel document showing the logic behind the calculations.

Quiero adquirir este script de codecanyon y quiero saber si se le puede agregar un complemento. Especificaciones Ver mensajes recibidos en un panel. Ejemplo: tengo 20 numeros que envian mensajes automáticamente y quiero ver mis mensajes recibidos en un panel y al hacer click a un mensaje recibido de un cliente pueda responderle sin salir del sistema en el mismo panel y con el mismo numero que recibio el mensaje

I'm looking for somebody to help me with sorting two lists that are stored in Excel. Specifically, I need one of the lists to be sorted in ascending order and the other in descending order - all based on a specific column of the spreadsheet. Additionally, I'd like the sorted list to be converted into a new format (e.g. spreadsheet, table, etc.). In order to complete this project, I need someone who is highly skilled with Excel VBA or Python based excel libraries and can accurately sort my data and write a CSV file based on that. Thank you in advance for your help!

For every batch we need to have a separate product calculation. We have big excel files that need to be adjusted. We will show you how to do it and you will replicate it. You should have a deep understanding about excel and product calculations to be able to double check if a result can be correct or if there is probably a mistake. We are a small German Start-up that is selling Healthcare products. We are working remote and our sales channels are Amazon Europe and soon , and an own online Shop. For these upcoming sales channels we will need your support to create exact product calculations. Your skills: - Very good German skills in speaking and writing - E-commerce experience - Very good economic knowledge (Bachelor of economics our similar) - Interest in Health and wellbeing - Ver...

I'm looking to hire an experienced Microsoft Excel expert who can provide an immediate start and a fast turnaround. I will provide the data, and the type of work that needs to be performed is presentation design. I need for the different excel worksheets to be re-designed into a cohesive look (color scheme, font choices, layout in print ready mode, etc.). This is not a project for someone who is a novice in Excel, but a true Expert that can work quickly. Ideally, I am looking for someone who has years of experience and is proficient in Excel, as well as other programs used to create presentations. The ideal candidate should possess strong problem-solving skills and be able to work independently, with little direction. Additionally, strong organizational skills and attention to det...

convert one click Excel workbook to web app

I'm looking for a freelancer to help me with an Excel automation project. Basically I need a developer that can write a small program which will take out of the email adress the excel which was sent, analyze specific data which I will explain deeper in conversation (for example it will show how many times specific letters are repeating and so on), and then in a small icon it will show how many times in a specific excel file it repeated, may be would be better even with alerts.

I'm looking for a Dotnet Developer having experience working with Billing Application with SQL Database. I have few costomization and I'm ready to pay for the work according to prior agreed terms.

I am looking for someone who can develop a PowerShell script that will generate text files based on their filenames. The script should be able to take the filename (minus the extension) and use that information as the content of the text files generated. I also need to add a string to the end of this first line that contains the filename. For example, if I had a file called “”, the script should generate a text file (with an extension of .rdy) with the content “sales-report|10000”. This |10000 will be static for each file. This project requires experience with PowerShell in order to properly develop the script. Text files should be the only type of files generated in this project.

I need help with a MS access database that has already been created. the data base is about product suppliers and products. Some products are suplied by many suppliers and one supplier will have many products. the goal is for me to easily compare the price of single product from various suppliers so that i can select the supplier. i have already created this database but want a professional to have a look at this and provide the following improvements. I want to enter data about new products from the products table. From the products table, if i need to enter a new supplier information, i should be able to do it from this table also. i have uploaded a relationship diagramme. the data base will be send to the selected freelancer

I am looking for an expert to assist me in automating a variety of data tasks through Excel and Visual Basic. Specifically, I need to use the 2016 version of Excel and both Visual Basic 6 and VB.net. A variety of data import/export tasks need to be completed. As such, I am looking for a freelancer experienced in using these programs to help me. The successful bidder will have knowledge regarding the aforementioned programs, as well as experience with automating data import/export tasks. I look forward to your bids.

I am looking for someone with experience in Excel data entry to help me with a project. The data entry I need done involves simple addition and subtraction. I also require the data to be sorted after entry. The complexity of this project should be relatively simple.

Greetings, I am looking for an experienced editor to work on my Fortnite project. The project involves transitions/editing, and I have decided to set a duration for the project of 1 week. I have no required references for this project, however I am open to any ideas you may have. This edit will require a great deal of skill and creativity from the freelancer. I'm looking for someone with at least 1 year of experience in transitions/editing, so I know that the job will be completed to the highest standards. I'm excited to work with you to bring my Fortnite project to life!

I’m looking for a freelancer to help me create a Visual Basic for Applications (VBA) code for a game of poker that can recognize flushes and all. My goal is to have an output that would code the playing results, which would include a final table for the winner and a summary report of the game. To do this, I would like the freelancer to use a data structure of linked lists and stacks, and I would like the results to be able to be saved after the game. I’m looking for someone who is experienced in coding and with VBA coding in particular and who can produce a code that will meet my needs and requirements.

I am looking to hire an Excel expert to help me with a project. Specifically, I need someone to assist me with Data Entry and I need the data to consist of numeric values only. In addition, I also need visuals and charts created - so creativity is essential. The ideal candidate should have experience working with formulas, cell formatting and pivot tables in Excel. This is an exciting opportunity for someone who is looking for a long-term arrangement and who has a proven track record with Excel. If you are that person, then I would love to hear from you.

Necesito optimizar mi gestor de correo electrónico Outlook 2010 y necesito que me desarrollen un par de Macros que agilicen el trabajo de envió y respuesta de emails. mas detalles en el momento que elija el desarrollador que lo pueda hacer.

We require a Chrome Based Excel Macro for a repetitive task , it should import / pick data from Excel and use it on Macro - Open a webpage , link provided in Excel - Fill the credentials using the data from Excel - Follow the page flow and place order with some basic checks on every page - On successful order capture the order details in excel Its a one time task , if a suitable freelancer is found we can award more projects INDIAN FREELANCERS PREFFERED

I am looking for an experienced VBA Excel programmer to help me with a project that requires data entry automation. The project is of an intermediate complexity, but I need the programmer to incorporate user interaction and feedback into the task. The project must be completed in a quality and efficient manner. Depending on the programmer's skillset and abilities, additional tasks may be added to the project. If you are interested in tackling this project, please contact me for more details. Thanks for your time!

Hello to everyone. I am looking to create a contact list excel file to be able to enter a person's name with all the necessary information so that name is placed in alphabetical order. The Excel file should be able to open fast, not a huge size of the file. Also, the file should be able to open through dropbox using a smartphone. Thank you.

I need it to where when someone inputs an item number, the corresponding product number will auto-populate

We are looking for an experienced Excel VBA developper to create a Cutting stock optimisation Macro in excel. The goal of the project is to develop an efficient algorithm that sorts and maximizes the uses of our stock based on parts required. The objective is to take in data on Line 10. Sort the parts in order to maximize the bars (220) Output data on line 17 to 47. There are special parts that need to be marked as special after the output. The algorithm should handle up to 30 full bars or up to 150 parts. I want the code to run on one click of a button. The idea is similar to this: Thank you

We are using access to capture data and then use a form to print out the data and present it to our customers. We would like to update our access system and freshen up the form so it looks more in-brand and also we would like to easily add individual images to the form.

I'm looking for an experienced freelancer to design a custom software or spreadsheet for our Profit and Loss, sales and management meetings. The project timeline is 1 to 2 month, with existing plans needing some alterations as opposed to a new design from scratch. It should be built in Google Sheets, forms or something else. for maximum efficacy and convenience. We have 2 software which will feed us information in cvs format or api. 1st is a accounting software will will feel all p & L info we need all sales , profit and lose. And expenses into a graph format and week, months , quarter, half yearly and yearly formate for every thing for comparison. Sales and job tickets software which will give us feed for every day sales and jobs and staff info, same format in graph 3rd is m...

I am in need of a VBA developer with webscraping skills to create a VBA macro for a project. The VBA developer should have intermediate level expertise and be proficient in MS Excel VBA. The project involves building an automated VBA macro that can scrape data from the web, extract it and store it in a suitable format. The macro should be able to pull data from multiple webpages and process them efficiently. Additionally, the macro should also be able to parse HTML documents, identify useful data and process them accordingly. The desired outcome is a program that can be used to robustly scrape data from the web in an automated way, and store it in the desired format. The project requires the developer to apply their skills to create a customised product with an adequate user interface ...

Hi, I have created a macro in i am unable to schedule the flow through power automate browser version. The flow that I require is: at a particular time excel file is opened, the macro is ran the macro execution is complete, the excel is closed . (please note:cannot use the power automate desktop flow for the above)

I have details and files.i need excel VBA is simple make within vba code. deadline Tomorrow max budget 10-30

HELLO, We need to do visualisation of our future project. 3 houses from outside and inside. Plus shot video from above like complete

I'm looking to have the first phase of a series of MS Power Automate Desktop (PAD) Flows to be created. Scope of Phase 1 - a small project to current data from a specific website. A) retrieve the property address from an Excel worksheet; B) extract the 1-3 values estimate for that property; C) write values back to the Excel file; and repeat to the end of property addresses provided. Flow shall be complete with error handling. Deliverables: Completed PAD Flow delivered in the form of a .txt file which can be imported into our PAD system. Phase 1 is the first of several PAD Flows and advanced Excel automation needed.

retreiving data from the internet and populate the relative field in ana excel sheet the data are financial data, ratios and information rewgarding companies and stocks. The excel sheet has to be like a one - stop page where the same information are shown of any ticker that will be selected

I need an excel Gantt chart that updates from a table that has recurring tasks. I need the chart to be a visual aid to interpret the data from the table. I record dates of start and finish in the table via App sheet and then. Ideally if it could also overlay a forecast i create too. its for management of a grazing cattle farm, there will be 16 paddocks ( which would be like tasks on a normal gantt chart) There is also approximately 7 mobs of cattle. attached is a copy of the data and a rough layout of the gantt chart. The different colours on the chart represent different mobs of cattle. The numbers on the chart are to help me analize how many days since the cattle left the paddock. The date out column in the data needs to automatically update to represent when that mob moves to a new padd...

Inventory and sales purchase sheet which automatically allocates the details into each client's sheet

I'm looking for an experienced Excel developer to help create an exciting new project. This project is an Excel based numerology system that will be used on a desktop platform. I need help adding multiple pages with specific features such as spreadsheet automation, data filtering and pivot table creation. The end result should be an efficient, user-friendly application to aid individuals in unlocking the power of numerology. I'm looking for professionals who have experience in Excel development and can provide me with the highest quality project. The ideal candidate would understand the complexity of this project and have the necessary skillset to turn my vision into reality. If you have the expertise and are excited to work on an interesting project like this, then I'd lo...

Hi, We have Power Point plugin developed into VB.Net VSTO We need some enhancement on it kindly ready the below changes. 1 - When we are clicking the search button it is fetching the JSON from Image website. 2 - Now we have to show the fetched image link into pan (Pan is already showing in plugin). 3 - also need to some UI design, it should look fancy. Note : Plugin should be look like attached SS

I want editor for you tube fast