Visual Basic Jobs

convert one click Excel workbook to web app

I need to create an excel workbook that allows me to keep track of tasks for my clients as well as daily and monthly productivity. There should be 5 worksheets in the work book titled Summary, Phone Calls, Personal, Business, Investment. Phone Calls sheet- Needs only two columns: Date, # of Calls Completed - This page should take the data and put it into a monthly calendar to show days with 10 calls or less as red, 11-17 as yellow, and 18+ as green - also needs to show total calls completed for the month. Personal, Business, Investment sheets - First row should be frozen and should have headings reading: First name, Client#, Start Date, Notes, DN, ST, Date completed. Personal sheet - will have one extra heading after ST, Ref, then Date completed. It will also need to add up total REF...

I have attached a similar project that I am wanting. The example I have is outdated and from another school. I want to create something similar for my school's context and attempted to do this on my own. I would like to hyperlink our school's documents into the project as well as to the NCCD website and their documents. I like the video elements as well. I want it to look professional and want it to be user-friendly for all staff. The links are also really clunky and not completely able to read the content either. I want our data capture to be accessible form every year level as well (Prep-Year 6). I am not sure how this might work or whether this is realistically possible (one can only hope!). I am able to supply all the documents and information I am requiring but it would be s...

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.

Hi 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. Budget 600 INR

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

We’re looking develop formulas and a macro to reformat a document for our regular data import process. We receive a report from a partner organization on a daily basis and regularly need to reformat and upload the ticket data into our system. These are the basic requirements to make the sheet ready for our import: • Partitioning the Name field provided into First, Last, First 2, Last 2 columns • Partitioning the Csz column into separate city, state and postal code columns • Removing foreign country zip codes • Adjusting zip codes that start with 0 (the file does not include the 0 if it’s the leading number) • Removing extraneous columns • Removing rows with missing seats/seat locations • Partitioning the Seat Location column into Secti...

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

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

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

*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 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)