Excel vba jobs

I want a database built to house all my property listing data for the backend of an app I am building. Previously I was using excel and VBA functions to manage all data, but our datasets are getting too large and too many updates, so now we are switching to PostgreSQL and pgAdmin. I am new to all of it and don't have the time to build and learn all of it. I would like to continue to be able to use pgAdmin as my gui since I have learned a little about it already. I attached a link to a chart below that has the basic functions and rules of what I need to happen. If you have questions please let me know. I need this done

I currently work with a personal excel workbook and I want to be able to share this file with certain colleagues but there is certain information that I don't want them to be able to see. I have a very simple macro that when executed asks for a password to hide certain sheets of my excel (3 sheets) while leaving the other ones open and protected, except 3 sheets that I want my colleagues to work on. This works fine. BUT I WANT TO ADD to this same code a macro to hide and protect all the rows that in column "F" contains "Repartos" and "Facturas" only in my sheet named "transacciones". The sheet "transacciones" is a very long database (currently working on row 33293 and counting, so I want this to be smooth when I run the m...

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'm looking for an excellent data extractor and organizer for a stamp/philately cataloging project. I have guides (brochures/informations for the stamps) that need to be extracted with an OCR platform, but they have to be checked as most OCRs mistake dots or smudges for letters, and don't scan folds as one document, so manually has to be adjusted. After extracting paragraphs of the English texts, I need the stamps to be organized in a folder with their respective stamps as well. Some of the stamps are already existing on our website, so you will need to check and skip the ones that are already done/uploaded as well. Once that is complete, I'll give you a Wordpress dashboard with a custom designed entry page which is super simple to use, I'll need the images and other ...

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

Hi Hira S., I noticed your profile and would like to offer you my project. We can discuss any details over chat.

I would like to get a python based software developed to auto login and mimic orders from one Zerodha account to another account. Basically the software will monitor the primary account continuously and whatever trades get triggered in the primary ...python based software developed to auto login and mimic orders from one Zerodha account to another account. Basically the software will monitor the primary account continuously and whatever trades get triggered in the primary account, it will copy those into secondary and all attached accounts. All the Auto Login can be done through selenium and Data like username/password/TOTP can be taken from excel sheet per user . Also a separate same Python based Dashboard to monitor all account activity. I have attached the file needed to get ba...

I need the Data Analysis to be done for a PHD Research project. I will share the data set in excel along with the instructions.

I would like to build a document that I can input client data and it populate the document. with the name carrying forward to all pages and it be formatted nicely. Ther is a couple of pie charts and tables , as well as 2 flowcharts. I .

I have an existing Access app which pulls in data from very large CSV files so that I can use the Access file to pull data into Excel. I have a new format for the CSV files with the columns rearranged from the initial iteration. I need the Access app updated so that it places the new CSV data in the correct columns in the Access table. Since I have the existing Access app, which works really well, it should be easy for someone proficient in VBA and Access.

i have XLSX(data) + XML(image links) used as template /source of data and i have XLAM with macros ....as a result im getting XML file with all data from XLSX and XML converted to XML in certain way. what need to be done : remove XML (image links) as source and all data take only from XLSX file where added image columns with links. formatting of result XML file must remain.

I have a one-time need to create financial forecast projections. Would like someone who has experience in creating a spreadsheet using the forecasting feature in Excel. Data provided will include year-end income numbers for the last ten years and year-end expense numbers for the same ten years (20 sets of data), projections should go out 5 years.

I am looking for someone to help with data entry into an Excel spreadsheet. The data that is needed to be entered is numerical and there will be less than 10 rows of data to be filled. I will provide instructions on the data that needs to be entered. Experience with data entry is a requirement, and a committed approach is an absolute must. I am looking for someone who is reliable and has a good attention to detail. If you are the right person for the job, please apply and let me know your availability.

Build me a simple shop with Excel VBA HTML and Java. I need specialist for the coding combination, I need very simple and clear code and simple and clear function. Pls give me your quote. Non-disclosure Agreement Agreement and Intellectual Property (IP) Agreement obligatory. BR

I have a basket of stocks defined in an Excel workbook on Google Drive on Sheet 1. This is a Yahoo Finance API job. It is not screen scraping. Excel or Google sheets. Python. I want a Python script to go to the Yahoo Finance APIs and pull the 50-day average for the stock and use the API to pull the data to calculate the 20-day average for the same stock and return it to the Excel file at the bottom of Sheet 2. Columns: Date symbol displayName fiftyDayAverage fiftyDayAverageChange, fiftyDayAverageChangePercent regularMarketPrice regularMarketDayHigh regularMarketDayRange regularMarketDayLow regularMarketVolume Then sort by: Date, symbol The delete all rows where date <> today's Date Save workbook I should be able to run this script from Visual Studio c...

I need to know how to paste a list (column full of values) from an unfiltered spreadsheet into a spreadsheet with filtered out rows (a table that has rows filtered out/hidden). Pasting or filling in a formula using "visible only" does not work.

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.

I have 9 forms in excel. I need to change to Excel user forms

I have some excel documents that need to change format, so that all are in the same format.

We have an excel sheet that has a column of data that is formatted the following way: Ideally they will work for us on a need-by-need basis, but right now we have a large import we need to clean up. I am attaching a sample sheet for you to review. This grouping will be on Category CPU, Server, Laptop. Review Column H I need this done in the next 20 hours. It is approximately 15K line items of inventory. Sub Type: Server / Form Factor: 2U / Processor Manufacturer: Intel / Processor Family: Core Xeon / Processor Model: E5-2650 v3 / Processor Gen. (i-Series Only): Not Applicable / Speed: 2.30GHz / Core Count: 10 / Processor Manufacturer: Intel / Processor Family: Core Xeon / Processor Model: E5-2650 v3 / Processor Gen. (i-Series Only): Not Applicable / Speed: 2.30GHz / Core...

I have some excel documents that need to change format, so that all are in the same format.

hi there what I would like is the data in Columns A and B on the 1st sheet (population count, by sex for 30-79 year olds, for each country) completed with data from the 2nd sheet I have been doing this for a few with filtering - by changing the selection in column B in the 2nd sheet and summing separately for men and women, then pasting values over. There may be a quicker way

I have done your work. Please have a look. Thanks

i have laravel admin panel. i want bulk upload excel to be field for multiple data entry but the multiple choice field should be come in drop down in Colum

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!

We have developed a series of VBA routines that convert data in excel to a PowerPoint presentation. However, the VBA code needs to be "industrialised" and made cross-platform to be used on mac or windows. The initial work is urgent, but there will likely be follow-on work as we refine or add requirements.

I am looking for a freelancer to work on a data entry project where product specifications for a computer are compared against comparable products of competitors. The data is easily found online. The output should be in Clickup format (this is very easy, just like excel). There are around 300 competitor computers that need comparisons. This project is ongoing and will take around 30 hours per week. It needs to be started immediately once approval is given. An understanding of IT hardware is helpful but not essential. Attention to detail and accuracy are a must. The end result should be a clean and organized Clickup document with organized and accurate product specifications, feature highlights and pricing information.

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.

This is a super easy project for someone that is not me. I can do things simply like calcs, sort, filters, builds, but nothing that requires me to read about how to in excel. I just need it to be created and then I can use it to then decide on project 2 and 3, I am visual so once I see how this first part lays out I can think about the next part. I have an inventory sheet with quantities come to me daily with 1731 lines of products and their parts. However, I only need maybe 300-400 of those lines pulled out with their data on that line and put into another sheet for me to use to then have divided (part 2) into groupings that I need. Obviously my eyes cannot handle searching 1731 lines and going for what I want out of there (by product sku) so I believe the word I am looking for ...

ineed to automate adata entry from an excel sheet to Website

I have a PDF i need converted into an excel spreadsheet with the relevant fields arranged accordingly.

...custom code to work with Excel files. Here are my requirements: 1. From WordPress Admin, client uploads a single Excel file. 2. This excel file contains 200 sheets/tabs. Once the Excel file is uploaded, the custom code must generate a PDF for each 200 sheets in the Excel file. Each PDF will be named by the name of the sheet (client ID) + Month and Year as entered by client. 3. Write the codeword "green" at beginning of your bid, so I know you have read the requirements. 4. Each user of this website is assigned a client ID. On the front end, the user will search by Month and Year, and it must present to them only the one PDF that matches their client ID. Most of my requirements I know are possible, however, the only part that is uncertai...

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

Hello there! I'm looking for a skilled freelancer who can help me out with my project. My project requires someone to carry out data entry in Microsoft word, Excel etc., and specifically focuses on text data. I will be using Excel for this work, and do not need help with formatting the data as I am confident that I can handle that myself. If you have experience with data entry and using Microsoft tools such as Word, Excel and Powerpoint, then I'd love to hear from you. Please reach out if you have any questions.

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

I just need this finished by tuesday at the latest

We use excel for our timesheets and need to be able to enter two zip codes and calculate the distance/time between the two zip codes. We pay employees travel pay for anything outside of 60 mile radius of 46217. We would want this formula to subtract the initial 60 miles that the employee does not get paid. The excel sheets run inside office 365. Let me know your fixed price for this task :)

I am in need of a report writer to help me generate a report using data from an existing Excel spreadsheet. The report should be an analysis of the data and I will need the final document in Word format. I am looking for someone who has experience creating financial, sales analysis and data visualisation reports. If you think you can help, please get in touch.

I am looking for an expert with experience in creating interactive charts in Microsoft Excel. I have a PDF which needs to be converted in Excel. The main thing is to create charts according to the data present. The selected freelancer will just have to create charts. There are about 25 pages. My budget is between 25-30 USD. I need it next 5-6 hours. Attention to detail is a must; so I am looking for someone who can help me create an accurate chart. Please start your bid with "Charts" so that I can see you have read the project details completely.

We have a requirement to copy data from MS Word to Excel. Looking for a quick turnaround time (24 hours).

We receive lots of emails that have PDF attachments into our Gmail inbox. We need to extract some data from the PDF attachments and port it into either an excel sheet or google sheets. Ideally the porting of the info would happen automatically. I have attached a few examples of the PDF attachements and an excel spreadsheet (which could be a google sheet if easier).

I have an old 25 page PDF file with charts that I need to convert back to MS Excel as the original MS Excel file was trashed. I need to recreate the MS Excel sheet (1 tab per page) so I can update the data. The fields are the same for each page, only the data is different along with the graphs generated. My time frame is 12 hours and my budget is $100.00. If you are good with MS Excel, you could probably finish isn a few hours. I am old and slow so easier to let someone else regenerate the data for me. Please provide link to samples of your work if you bid on this job. Thank You

I have a list of 20.000 Ips .... etc I have an api that can geolacted any Ips this api, returns the following data info {"ip":"","country_code":"ES","country_name":"Spain","region_name":"Andalucia","city_name":"Sevilla","latitude":37.38241,"longitude":-5.97613,"zip_code":"41500","time_zone":"+01:00","asn":"202767","as":"Futura Service Provider S.A.","is_proxy":false} I want to have the info in an excell worksheet, so the next time a have another list of IPs, i can check them easily i attach a sample output for the job i am open to other options

I'm looking for someone to code a project in Visual Basic for Applications (VBA) that will open URLs using Excel, and save the PDFs that come from the URLs to a certain location. The project needs to be fully automated, and open one URL at a time. I need to have the file in a way so that I can edit any of the parameters myself without needing any additional coding. The project also needs to be able to save the PDFs that come from the URLs for later viewing. This is an important project to me, and I'm looking for someone with the right skills and experience to complete it. Project needs to be completed within the next 4th of April 2023.

I need to extract data from a website and put it into excel with product name, description, urls images, brand, model code, categories and subcategories

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

The destination name is YYYY <code> where YYYY is the year of the accounting movements (always the same) and <code> is taken from the configuration file. ATTACHMENTS - BankToXls specs: project specifications - BankToXls Implementation Guide: in deep step by step implementation guide, with all the (simple) algorithms to be implemented. - A VB project with the right Interop Excel library and the form with all the needed controls. - Bank transactions : the destination prototype. - A sample DEF file-. - A set of source files example, enough to cover the test operations

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

I am looking for Word, Excel, PowerPoint, R, and/or Python project, its an urgent project I need in the next 2 hours

1. I have about 11,000 emails from 2021 that i need to extract to an Excel Sheet 2. here is the example screenshot of what the emails look like. They all look the same 3. Here are the example fields that i need per email in an excel sheet Name : Sophia Man Placed Order : Dec 19, 2021 Time: 8:40 PM Order Number : #25475 Item Name : Microcurrent Attachment Price: $189 Quantity: 1 SKU: NV-Head Subtotal: $189 Shipping: $0 Total : $189.00 Payment processing method: Shopify_payment Delivery Method: Free Shipping Shipping Address: Sophia Man _______________ Street Portland, Oregon 97217 United States 4. All of the emails are already saved in a folder in my gmail and there should be around 10-11K emails. from 2021