Excel macros jobs

Please Sign Up or Login to see details.

I am looking for a freelancer to help build a web interface of 40000 excel entries in an existing CRM with the option to download the data in a specific report format. The entries should be further editable in the Web Interface. Basic Option of Search , Filter, Export data , Import Data must be there. The software needed to build in the existing CRM (). The freelancer should have experience in woking with databases and web development in order to understand and build the required tasks. I need help building this web interface which should be able to accurately store 40000 entries and make them available to view and download via web. The report format needed should be PDF so that the output file is easily readable. Having a Web Based Interface is important so that it can

Problem Statement: We have data in excel filed currently with standard format. The data is spread across multiple millions of rows and 25 columns. Right now we maintain this data in multiple excel files which become very slow due to heavy data. Solution we are looking for: We want to build a small internal application where we can upload all the date from various excel filed. The app should allow features to search in the database as per our requirements (just like the feature of filters in excel). We will need the following functionality: 1) Accessibility from anywhere in India 2) Feature to upload more data by uploading an excel. 3) Feature to download desired result after applying our search criteria. 4) Feature to provide access to team members wit...

Need some assistance with excel to show unique texts/values between one multiselect cell and a range of cells

see attached excel spread sheet all calculations must work the same. It will be awesome if yo have Spreadsheet Converter software, then it's one click to convert Please let me know

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.

Excel angle calculator as per sketch

500 Emails via outlook. ,

I have 2 excel sheets, each with about 4000-5000 customers. However each file has about 30,000 rows because all the customer info is in column A. I need column A which contains all the data to be pivot tabled into rows and columns so I have name, address, phone, email, etc in separate columns. I attached a subset of the data so you can see what kind of data cleanup is needed.

متوفر البنود في ملف excel مبني رءيسي ٢٠ الف متر موزع على ٤ ادور ميكنيك كهربا تشطيب اعمال مدنية

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

...------- .Advertisers can create POPUNDERs or PUSH Campaigns / ads by Direct Link Or XML / JSON OpenRTB feeds . .Targeting like Geo , Device , OS , Browser ( in default all is choosen excluding geo ) .Field fot set bid ( started at $0.00001 ) .Option for Top up Balance choosing Payment method . ( Payment method & minimal Threshold set by administrator ) . .Macros option , zone , ip , ua , lang , uid , ref , Domain , refid , .Field - Name of Campaigns / ads .Notes field .Limits Requests per Day Clicks per Day Clicks per IP .Categories field ( Adult or Mainstream ) .Full detailed statistic by Publisher / zones , Geo , Device , OS , Browser , Subid , referrer url , avarage bid , filtered , requests , money spe...

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

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

1. Tax Return Filing Data available in Excel Sheet. See blank excel sheet. 2. Need to use these data to prepare Balance Sheet + P&L. (after trial balance). 3. For last 2 years. 4. May use software or do it manually. 5. Quote price and days to complete. 6. Send template in which you would finally present BS & P&L (as sample). 7. Past years' template can be shared after job is awarded to follow.

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 to add a developer or two to work with another couple of developers on an Excel Add-in we have built. Your role will to be add additional UI elements to the existing web app - another group does a lot of the code that actually interfaces with Excel

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