Excel VBA Jobs

Real Estate Auction Spreadsheet showing each parcel and total of all six parcels. Want a sheet of all parcels that changes with each individual parcel. Also show each bid amount by bidder number

This is for SIM sales, and Mobile Hand sets sales. It can be done either in VB or in Excel. It should give analysis for Region wise, Zone ?Wise, District wise, Agent wise, Daily Weekly and Monthly and Quarterly with charts.

I need a scrapper to copy data from an ecommerce auction website. Some of the data I need are listed below, also see further requirements on spreadsheet attached and screen images for examples. The output must be in Excel format. I think your code can be done by excel VBA, Python, Nodejs There is about 20pages (1000 products) to scrape through, and your code should be able to complete within 1-2hours Your code should allow me to specify the landing page where to scrape from, also the URL where to search product data fields below. To retrieve 3 of the data fields below (sold price, title, page views) your code needs to be able to search the website for the auction page based of the auction number provided off the feedback landing page. Please note that the ecommerce website has 2 format...

I need to build an analysis report of stocks based on NSE bhavcopy as per my requirement. I want to utilize PowerBI for analytics. When I am using calculated columns for my query it is getting crashed and telling "NOT ENOUGH MEMORY". I want someone who can build the analysis as per my requirement in PowerBI. The data varies from 1 million to 2 millions rows having more than 10 columns.

Hi, We would like to inform you that we have multi location and multi facility and to calculate the Attendance, Working hours of Employees on daily basis. 8 Different Format of Data are being downloaded from different systems like Server, VPN, Biometric, Google Form etc. 1) Local Server 4 Nos. 2) Login to Server via VPN 3) Bio-Metric 4 different Types The Main issue is that e.g. Person had entered office so he done following :- a) punched Biometric at the time of entry and exit say Entered office at 12.30 pm and left office 4.30 pm b) Gone to another Office i.e. godown Entered there at 5 pm and left at 7 pm c) Login to VPN 12.45 pm and logout 4 pm d) Login to Server 1 (login 12.45 pm logout 1 pm, login 1.05 pm logout 2 pm) e) Login to Server 2(login 1 pm logout 3.45 pm) f) Login to VPN...

We are creating two databases in Access 1. For the video shoots we have undertaken 2. For the talent employed. We need the two linking so that we can 1. select a shoot and see which talent attended and see their detail in ghe query and 2. Select talent and see which shoots they have done

I am looking for a VBA programmer who can work Mon to Sat 10-6 PM EST time. Your English should be good. And you need to be very good in VBA and excel automation. Its not a one time project, You will work for us ongoing on our all excel VBA projects. Only serious VBA programmers.

Full time VBA programmer who can work Mon to Sat, 10 AM EST to 6 PM EST. Your English should be good and you should be very good in VBA and excel automation. IF you can;t work in this timeframe, then dont bid. Only experienced person, no time wasters. Its not a one time project, You will work for our company as a full time Employ and we can pay weekly/Monthly. You need to work on different projects.

We are creating two databases in Access 1. For the video shoots we have undertaken 2. For the talent employed. We need the two linking so that we can 1. select a shoot and see which talent attended and see their detail in ghe query and 2. Select talent and see which shoots they have done

Please create design sheet with Excel referring to each service of AWS configurations. This is Excel task and you do not need AWS skills. You need your own AWS account and able to access and operational. The target is as below. VPC VPC Endpoint（GW型） Internet Gateway NAT Gateway Transit Gateway Site-to-Site VPN Security Group ELB Route 53 CloudFront EC2 EBS ECR ECS（EC2） Lambda S3 Backup RDS IAM AWS Certificate Manager（ACM） Key Management Service（KMS） GuardDuty AWS Shield (Advanced) Network Firewall Security Hub Cognito Inspector CloudWatch CloudWatch Logs "OpenSearch Service （旧Elasticsearch Service）" SNS SES Kinesis Data Firehose EventBridge CodePipeline CodeBuild CodeDeploy CloudTrail Config Systems Manager Cost Explorer Budgets Organizations ControlTower

Relational Database We are creating two databases in Access 1. For the video shoots we have undertaken 2. For the talent employed. We need the two linking so that we can 1. select a shoot and see which talent attended and see their detail in ghe query and 2. Select talent and see which shoots they have done

I would like to create a visual of real time from microcontroller and populate on excel

I’m trying to build a database that register patients’ vaccination in 3 vaccination spots. I thought that I was able to do that by myself but my access skills are gone. This is for a nonprofit purpose, only a college who wants to help to get rid of a mountain of paper. There are three vaccines that the patient has to agree. The vaccination procedure will start only after 4 weeks from the registration date

Hi. I have many Excel files that needs to be merged in one Excel file. One hour is allotted for turnover of the merged file after grant of project to selected freelancer as I need the output ASAP today. Please don't bid if you will just manually copy-paste and cannot deliver on time. I need someone who knows how to code or automate this task. Thank you.

i need an excel VBA developer and more details will be shared in chat. happy bidding.

I need help in creating an installer and licensing for an Excel add-in Looking for someone who has demonstrable experience with creating and licencing excel add-ins (.com and xlam) who can discuss with me via zoom or similar, the process steps required and software to use. Licensing of the product will be both trial and recurring payment. Estimate 2 hours initially. Must be fluent English speaker.

Customized accounting Software for Civil Engineering ( Builder) as per our requirements

The details are that the old person in my job created this excel macro that takes two sources of data crosses references them, removes duplicated and pushes them to a database so I use the data in tableau - however, a couple of the lines of vba code for the macro broke and I'm wondering if you can fix it - need it done asap. Thanks and looking forward to hearing back, Pete

I need a solution to upload orders into Aliexpress from an excel spreadsheet. This will contain names, address, product ID/url, product variant option. Your solution must allow me to check the orders first before they are actually created in aliexpress. It will need to retrieve the current product price, variant prices (if any), and shipping price and method before the orders are created and uploaded to aliexpress. I prefer integration direct to aliexpress API but open to using web service tools like Oberlo, shopmaster, alidropship etc.

I need a solution to upload orders into Aliexpress from an excel spreadsheet. This will contain names, address, product ID/url, product variant option. Your solution must allow me to check the orders first before they are actually created in aliexpress. It will need to retrieve the current product price, variant prices (if any), and shipping price and method before the orders are created and uploaded to aliexpress. I prefer integration direct to aliexpress API but open to using web service tools like Oberlo, shopmaster, alidropship etc.

I want to automate one of our frequent task. Basically I want to have a VBA enabled MS word file which would - 1 - Copy data from different files and paste it into a new word document with specified font and headings. 2. Embed different documents itni the word document.

Clean up our Neat Receipts Bills We need someone to log into our Neat Receipts Account and review and clean up our bills so our accounting software can run. You don't need to be familiar with Neat Receipts as you are basically looking at the image and filling in forms. But you do need to be a quick learner. 1. You need to check and enter the vendor (if it's there incorrectly you need to correct it). 2. You need to check and or enter the date 3. You need to check and or enter the amount. 4. You need to look at the type of expense and figure out what category it is (we'll explain it). 5. You need to save it and do the next item. Once this batch is done, you may have 3-4 hours a month of work. You have to be very careful that you do not corrupt the database.

Basic Education I want freelancers that are educated and experienced to write vividly on this topic

This is a very simple excel job. I need to examine all the phone numbers in a single column and print out all of the area codes. Please seem Loom video for clarification.

Looking for a Tableau or Power BI expert who will develop and maintain dashboards and reports for multiple clients that can be easily converted or integrated into billing reports and monthly summary reports in Word, Excel & PowerPoint. Needs to have an advanced understanding of Tableau, application optimization and performance, SQL, calculated fields, TABCMD, automation, etc. Needs to know how to deploy and efficiently manage multiple sites while standardizing on a desired format. Prefer to have someone who has worked with a Dynamics CRM database.

We are creating two databases in Access 1. For the video shoots we have undertaken 2. For the talent employed. We need the two linking so that we can 1. select a shoot and see which talent attended and see their detail in ghe query and 2. Select talent and see which shoots they have done

Details will be shared in chatbox

finding professional people to write a backtesting program with simple entry/exit trading rule for stock, automatically perform multiple tests using each of the possible optimization combinations (eSignal MetaStock Pro 10.1 is suggested or Trading View , Excel VBA, Python may be used) 1) with BUY, CLOSE BUY, SELL, CLOSE SELL 2) with entry time offset setting 3) output Test Report to excel file(or can be copied to excel file) to show required information(eg. total no. of 3 consecutive loss and win, total no. of set "1 win + 2 consecutive loss + 1 win" which in between each most recent set of "1 loss + 4 consecutive win + 1 loss" and "1 win + 4 consecutive loss + 1 win", etc.) no hidden code or password protected and all code have been commented and editable by...

Hello Very urgently need small VBA project to be done through got repository. Please apply ASAP if you can get it done urgently today ie 13th Jan Thanks

Hi, I've developed a macro where I have to "check-out" an excel file from One drive share point, make some changes and "check-in" back. This macro works fine with most of my clients but not with few where I'm getting stuck when the macro tries to "Check-out" the excel file, it throws False error. I've tried few solutions suggested online but nothing helped. Not sure what is causing this issue for the set of people. I need an expert advise and suggestions from you and I'll be trying those from my end. I'm happy to pay you if you can crack this and make it work. Thanks in advance... The code I'm using is: (Filename:=Thefilenamewithsharepointlocation)

I need a freelancer with good knowledge of excel to scrape soccer stats from multiple soccer leagues and distribute the data into excel in a nice table using VBA. The data will need to include: Country, league, home team, away team, home goals away goals, the final result of the match and the odds etc. I have a table in excel that has all the leagues that I need to be scraped and the scraper needs to be able to adapt according to the table as the table expands or contracts. The macro will also need to be able to apply some counting formulas and the ability to add the data to my database with all the historical soccer stats. The macro will also need to check for duplicates. You may have to remote into my computer to adjust any settings to enable the macro to work and fully test the macro an...

I want to make Excel price list explain how it works when I create a one product price list in Excel it's automatically create price list as I mention profit it saved on Google with different right list percentage for example I create one product price list and mention percent 10% 50% 5% now in Google specific location it will create this three price list which I can send to my customer as I mention profit in party criteria

Looking for a VBA programmer to work on excel based projects from 10 AM to 6 PM EST time. You need to be available all time in this timeframe all days, Mon to Sat. Also you need to be very good in English. Also I am looking for a smart guy who understands project details very quickly and work in smart way. Its a full time job, And ongoing work, Not just for few months. Good luck,. Quote your Monthly salary.

Necesito una macro en excel VBA que me permita tener diseños de publicaciones para grupos de venta en Facebook, que me permita programar las publicaciones y hacerlas de manera automática en los grupos de venta donde este unido con mi cuenta. que yo solo seleccione los grupos y se publique de manera automática.

транспортная фирма, приезжают машины фиксируются неисправности отмечается до когда действительны основные документы, и с какой прицеп притянул какой тягач в Excel потом раcпределяются работы по различный сервисам в зависимости от специфики работы, в процессе работы добавляются ещё разные сервисы и разная свазанная с ремонтом информация информацию вводят различные люди которые одновременно подсоединены к рабочей книге Excel. цель работы такая чтобы можно быстро, мониторить ситуацию какая машина или прицеп где находятся, какой производится ремонт, закончился ремонт или нет: что надо сделать : лист для ввода информации (информацию могут вводить одновременно несколько пользоватей ) лист : общая база данных, куда будет по...

Hisse senedi, emtia ve yatırım fonu alım satımlarım için grafikler ile kar zararı gösterebilecek güncel fiyat bilgilerini internet üzerinden 15 saniye de bir çekip güncelleye bilecek excel tablosu istiyorum.