Visual Basic Jobs

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.

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

I need to deploy a simple form that allows a user to enter a designated prefix and select a two-letter suffix (from a dropdown list of country codes) and then through a script, generate random numbers (not from a database although I have an excel worksheet that will let me create 1500 random numbers at a time) and populate eight labels per sheet with two logos inside each barcoded label field plus the bar code itself and the human readable number - and surrounding fixed text in the margins of Avery label sheet Nr. 64501. The random number to be generated for each uniquely numbered bar code label needs to follow a designated algorithm noted in the file I've attached Once the script generates the numbers (no need to have a database of pre-prepared numbers - they should be created new ...

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 have a VB Script application that no longer ends. It basically takes a daily downloaded CSV file, dumps it into MySQL and then quickly updates a database with the values from the dumped CSV. This file use to have 400,000 entries and ran fine. Now that it is 600,000+ it doesn't stop unless I end it.

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

We are seeking a highly skilled and motivated individual to develop a protection system for our Excel tool to be distributed on licence agreement. The successful candidate will have sound knowledge of Excel features, VBA, and will be a problem solver in the IT environment. Responsibilities: • Develop a code to identify the computer where the Excel tool will be used and obtain the PC's serial number with the computer owner's agreement. • Create a VBA code that prevent tabs to be viewed without activation key. • Create or source a key creation tool to unlock the Excel document once pc’s serial number matches that obtained in step 1. • Write a macro or VBA into the Excel document that will validate the serial number on the computer trying to open the docume...

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

I am looking for a VBA developer to help me create poker hands for my project. It will be modeled after the game Texas Hold'em and will require the development of a suit class to help display the hand strength. On top of that, manual review will be used to analyze the hands, without relying on probability-based analysis or optimal strategy determination for this project. This project is time-sensitive, so the ideal candidate should have some experience with poker programming. I'm looking forward to working with you!

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'm looking for an experienced freelancer to help with an Excel VBA project. The project involves working with existing data, which I can provide. The desired output of this project is a macro enabled report. I'm looking for someone who is an expert in VBA programming and Excel, who is able to take the existing data and use it to create a macro enabled report that meets my specific needs and requirements. I require a professional, who has a good understanding of the VBA programming language and Microsoft Excel, and is able to complete tasks quickly and accurately. Experience with creating charts, tables and other visuals will be beneficial. I'm hoping to find a freelancer who has the right skills and experience to complete the project within the agreed upon time frame and...

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

*Job Description: Menginput dan memfilter data listing property *Skills: -Familiar dengan google maps -Mahir menggunakan excel dan spreadsheet -Komunikatif *Kualifikasi: -Minimal pendidikan D3 -Semua jurusan

I need some help for my excel file

Hi, I am working as Operation Head in a small machinery company. I would like to prepare a MS access based apps for managing my company operation. we have 6 machines are working my company, each machines are getting different type of jobs from different customers. I have to get following Datas to be entered to system and get some reports also. 1. Data entry of Jobs 2. Delivery status 3. Pending works of work to machines hours spend for work & employees

I own horses and want to monitor their progress …spelling …. Training…..racing result at different ages.. Want a database look for info entry. Something like horse name…DOB….Sire name ……Dam name….Sire and Dam Pedigree…race grade….distance…track…..track condition....weather….Finishing position….Race time…..First 3 horses to finish. Is that possible I can do in excel 365 iPad but not the fancy input stuff. Thanks

Need a simple Access UI to connect to the back end sql server databases using 1) ADO Connection 2) Ability to Save the connections in the Local Database 3) Data Select and DML operations 4) Pass Through Queries Execution

Database (via Excel) of the documentation related to our customers (Enquiry, maintenance, monitoring, generating reports, ...) here are some additional details and considerations but not all : 1- Main Sheet which gathering all data together This sheet should serve as the central hub for all of your customer documentation include all relevant details for each document, such as the customer name and number, document code, name, description, date, amount, and expiry date, status of the document (e.g., accepted, pending, rejected), the name of the employee who processed the document, and any notes or comments that are relevant. 2- Customer Sheet: This sheet should contain all of the details related to our customers, including their name, address, customer number, relationship manager, and s...

One of our clients has many Access 2003 databases which they have adjusted many times. They would like to make some changes to these 2003 Mdbs and after all of their 2003 Mdbs have been adjusted they would like to upgrade all of their difference Access database to Access 2007.

I need vba expert who will design my excl font page as my sample with data scraping from yahoo

Open my excel spreadsheet and picture. Example - 1. Mark “ B2 ” DIA as 25 but “PAP” is 32 x 25 ELB (THAT IS WRONG TYPING ) When I type incorrectly in the pap area, the "ELB" must appear in red. (like this “ 32 x 25 ELB “) Pipe DIA and ELB must have the same first letter; if the letter is not the same, it needs to be changed to red. (see my picture) Example - 2. Mark "B8" has a diameter of 25 but "PAP" has a size of 25 x 25 x 32 (WRONG TYPING ) When I type incorrectly in the pap area, "BULL TEE" should appear in red.. (like this “ 25 x 25 x 32 “) Pipe DIA and Bull Tee's Last Letter must be equal; if not, it must be red. (see my picture Can you do all rows in excel vba

I am looking for a VBA Expert who can help me with a project that requires coding macros. I have a specific goal in mind that needs to be achieved and I would need the expert to work on it for 1-3 days. The right candidate should be good at Excel and have experience with dashboard generation. The below is the sample project requirement. You will be interviewed based on your performance to provide resolution to below illustration. Whomsoever- want to apply create the macro in attached file ''compare data" two data and bring difference in other tab. It should be professional and can use dashboard or chart..

I am looking for an expert in VBA coding and Excel that can help me automate a project. In particular, I am looking for someone to help me code a project that has an intermediate level of complexity. I do have a rough idea of what I would like to achieve but I am open to suggestions to make the project as efficient and effective as possible. Prior experience with Macros, Custom Formulas, and VBA automation is required. Please complete the attached sample project for further interviewing process. To compare two data in which - The SSID is unique in both table and you need to generate difference of result in separate tab. You can create dashboard also of it to make more interactive.

I want to login into website and extract some info and send it to whatsapp automatically

I need to have a VB program to to simplify interacting with site The Requirement: The application consists of a dashboard and four modules to build a simple interface to buy, sell, check price and check wallet to interact with Binance site GetPrice() SellCrypto() BuyCrypto() GetWallet() - MS Visual Basic program - Native Programing - Delivering Source Code - account credentials will be provided when project testing started - The required dashboard is attached as Ms Access program - Application database should be ms Access

I am looking to create a proforma Excel spreadsheet which will contain sales figures, with just one single worksheet required. This spreadsheet will need to be updated regularly, and I'm looking for a freelancer to help create it. The spreadsheet needs to be tailored to my data, so experience in creating an Excel spreadsheet is a must. I'm looking for a freelancer who can help create an effective and efficient spreadsheet so that my sales figures can be analysed quickly and effectively.

Dear coder, I have a little project in mind, but I am willing to pay good money if you can deliver. I need a visual representation of a specific options chain beeing bought and sold. The data is provided via the ibkr (interactive broker) api. For example: I want to analyze the spx option chain. The current strike price of spx is 4000, collect the data of the nearest strikes (100pts, 10 points steps, in this case 4000, 4010, 4020; 3990, 3980.. and so on). Now the cumulative amount of buying and selling of each strike as well as an combined set needs to be plotted on a simple diagram (x: time, y: cumulative amount). The diagrams need to be potting live, IBKR allows 50 refreshes per minute. If you are seriously interested in this project do not hesitate and contact me! sincerely...

I have 200 excel files.. where I want duplicate data to be merged together.. but they have categories which are unique .. i want them to be comma separated.. if its possible please check the attached file and do let me know..

I am looking for a freelancer to create a VBA code to create charts and do complex math calculations. This project is for personal use, and I require an advanced level of complexity for the code. The project must be done in VBA and no other programming language. If you think you are the right person for this job, I'd love for you to apply.

first page complete with the ability to add stocks. I provide the template. You have one sheet stock symbol graph. I asked for a separate tab or many tabs. When you add a stock new tab of monthly, yearly 1,5,10 years of data. Look at my example file attached.

I have some excel base assignment, for which solution videos to be made (each video for 3 to 5 mints)

I'm looking to create an Excel spreadsheet that will streamline my cryptocurrency arbitrage trading. The spreadsheet will be connected to the Live API's of crypto exchanges, along with tracking data from multiple exchanges (approx. 10 exchanges initially). Specifically, the spreadsheet will focus on tracking the price of different cryptocurrencies. In addition, the spreadsheet will feature basic formula calculations. Ultimately, this spreadsheet will provide me the opportunity to more closely track the cryptocurrency market which will allow me to make more informed and efficient trades. It may need the buy and sell price added somehow to the spreadsheet also of crypto token pairs to become more accurate however this can be discussed during the creation of the spreadsheet. The m...

I am having a old client server project that was developed in Visual Basic 6. It connects to windows server via winsock to receive live OHCL quotes . It uses asp.net to receive historical data from server stored in Ms sql server. The tables of the sql server were deleted . We need help to run the project and make it working. No new code to be done. Only the old running condition to be established. Sample code of the form having winsock and historical data calling is attached along with the aspx file that used to fetch the historical data from server

You have one sheet stock symbol graph. I asked for separate tab or many tabs. When you add stock new tab of monthly, yearly 1,5,10 years of data. This is the error I am facing when I click on get data server link failed A1 cell have symbol which you desire to see data down cell have start and end date down cell have daily, weekly and monthly data adjestment and code is source with these cells now issue is when first time to making code it shows the data in front of you but then you change the symbol or date it tells connection failed to server main page similar page I added.

I am looking for someone to customize an excel spreadsheet for my business. I need it to include sales data, and I would like to add in some Excel formulas to make it easier to read and analyze. I do not need any calculations, however, I might consider adding in some graphs and charts with conditional formatting on them if it helps. All in all, I need the spreadsheet to be customized for the type of data I'm working with and formatted for easy readability. Can you help me with this?

I am looking for an experienced Excel Expert who can understand and transfer data from one format to another. The data set is large, with more than 10 columns. The format of the data can be either tabular or non-tabular. I also need the data to be partially analyzed and interpreted. The successful freelancer must have extensive experience in making sense of large data sets, be detail oriented and have advanced Excel skills. We have a software where customers are bringing in Data from multiple sources but they want to import the data into our System. We have data imports via spreadsheet for Customer, Job Sites, Work Orders and Units. I would like someone who is experienced in excel, who can understand the data that is provided by the customer and is able to translate that data accurately...

We have an old Visual Basic 6 code that used to work some years ago. The project is a client server model. We need someone who can read the code of (Mainly 2 forms of the project ) and explain us what are the function and how the code works. Need an Indian developer only ready to explain over skype or phone via remote access. We have pay at an hourly rate . Sample file attached.

As a client I am in need of a Freelancer who can assist me with editing an existing GTS Excel Spreadsheet. I do not have an existing spreadsheet that needs to be updated nor do I need any new formulas or calculations to be included in the spreadsheet. Additionally, I do not need the spreadsheet to be integrated with other applications. I am simply looking for someone who can take my existing GTS spreadsheet and make changes and edits based on my requirements.

I NEED TO CREATE A REGISTRATION FORM, TO CREATE BOMS USING A DATABASE.