Vba Projects
Looking for freelance Vba jobs and project work? PeoplePerHour has you covered.
opportunity
QuickBooks & Xero to Microsoft Excel Coding Expert Wanted
Are you an experienced coder with a knack for seamlessly integrating financial data from Xero and QuickBooks into Excel? We're seeking a skilled individual to develop a custom solution that will streamline the process of downloading financial information and populating predefined Excel templates. Key Responsibilities: 1. Develop a solution that allows users to select clients from Xero or QuickBooks directly within Microsoft Excel. 2. Enable users to choose specific types of reports such as Balance Sheet, Profit & Loss, Trial Balances, and more, all from within Excel. 3. Design a system that automatically feeds the selected data into predefined Excel worksheets, ensuring accuracy and efficiency. Requirements: 1. Proficiency in coding languages such as Python, VBA, or similar, with a focus on integrating APIs (Xero and QuickBooks). 2. Expertise in working with Microsoft Excel, including creating dynamic user interfaces and automating data entry processes. 3. Experience in developing custom solutions for financial data management and reporting.
21 hours ago19 proposalsRemote
Past "Vba" Projects
pre-funded
I need some Excel VBA code correcting
Hi, I'm trying to finish a macro which will clear a selection of cell details, using ClearContents. I've got the selection of the cells written and runs fine, but keep returning an error on the second half of the macro - clearing contents. Error returning 1004 Code: Sub ClearContents() Dim rng As Range With Worksheets("Proforma") Set rng = Union(.Range("H13"), .Range("H14"), .Range("H15"), .Range("A23"), .Range("G23")) End With rng.Select rng.ClearContents End Sub Successful applicant will have VBA knowledge and able to provide the correct, working macro code. Thank you
pre-funded
Automate two Excel Files
I need to automate the following process in Excel using VBA. File 1 This is a reference file. See attached. Users can add/delete from this. File 2 File 2 is the Excel Master Template. In worksheet 1, there is a measure name in column A and a table with the 12 months of the year, split by quarter in columns B,C,D and E. The measures or tasks that people do in their day get manually input by TLs each month in the respective cell of the month against a measure line in cell B3, B4, C3, C4 and C13, C14 etc., TLs can manually update other cells that are not relevant to this exercise. In addition, there are 12 other tabs in this file, one for each month. Each of these tabs has its own tables with data in them that people manually enter. Format of these tables are the same for each month tab. These two files are saved in the same folder. TLs currently open File 2, go to worksheet 1 and manually insert the task or measure that they did each month. For example, they will update figures and text cell B3 for January and in C2 for February and so on. They can also update tasks that they hope to in future months. TLs update this same information again in the corresponding monthly tab. I want to automate this process using VBA. Pick the information from worksheet 1, say, cell B2, B3, B4 for January and copy the information into cell B33, B37, B28 etc., in the January tab. However, any other information that already exists in the monthly tabs in other cells that has been manually input should retain that information irrespective of the macro. They manually input the individual reference number and name in columns B1 and B2 of these monthly tabs. This needs to be automated using VBA using predictive text and populated to all the monthly tabs. In simple terms: Open file 2, pick reference data from 1 and populate cells in B1 and B2 in 12 monthly tabs. Then run VBA and take information from worksheet 1 and insert into specific cells in their coo corresponding monthly tab. Have a ‘Save As’ option defaulted to where File 2 was picked with the file name defaulted to the reference name picked. I use Office365 at work and my data is confidential. Therefore, I have created two dummy data files in Excel for you to work on. I have to replicate what you do in my work computer. Therefore, I must be able to re-type the VBA code at work. My suggestion is to create an Update tab for this as per File 2. Happy to look at alternatives. For someone with good VBA skills, this isn’t a difficult/time consuming job. So, if the VBA code need to change by a single line, I don't want you to charge me for an hours work! Timeline is roughly to have a demo version within three/four days and a permanent solution within one/two weeks max as I have to juggle any testing around my day job and possible yours. Thanks, Prasad.
opportunity
Modifications to Excel VBA Program
User requires enhancements to an Excel VBA program, String Match Correction, written for Excel 2010. The Program performs search, logic and comparison operations, metrics and scoring, and string manipulation between two Excel music data spreadsheets. The enhancements are required to accommodate a newly developed spreadsheet (Singles) and changes and additions to the field names of existing (AlbumCD and Tapes) spreadsheets. The task involves developing new VBA coding, integrating and modifying existing VBA coding to expand the automated spell checking, data comparison, metrics, scoring, and data editing features of the VBA Program’s functionality for the three Excel data spreadsheets, Tapes, AlbumCD, and Singles. Contact Buyer for spreadsheet and current UI views
Excel programming, table evaluation
We are looking for someone who can create a small macro or VBA script or something else for us to create an Excel table with evaluations from a text file. The data needs to be sorted automatically and simple calculations like multiplication and sums need to be done. The data is working hours that we have to evaluate every month. 1. The total monthly working hours per person should be calculated and be rounded down to a full hour. 2. 30 minutes should be subtracted from the daily working time. 3. The total monthly working hours should be multiplied by a fixed value. 4. Finally a fix amount must be subtracted.
Receive feed and do Data Manipulation
I wrote a VBA code and want that to be converted to a Web/mobile based app. The logic is outlined below but you can even look at my VBA code to get an idea. The basic requirements are 1.) To read, manipulate and update data 2.) Have a payment receiving options (paypal, credit card) for monthly, quarterly and yearly subscription based. 3.) Some required Graphs The received data will have minutes by minutes info of Date, Price, Open , High, Time Low, Time, % From this daily minutes rows daily high and low should be determined For example it needs to get real time forex feeds from yahoo finance website and add some logic to filter data and display it on my site with some graphs. Is that something you would be keen on? It is for student/personal use so can you let me know what your charge? The below website will show how to get data from yahoo finance and the other links will show how to display data https://www.youtube.com/watch?v=1O_BenficgE https://m.youtube.com/watch?v=kQo7nxxmwus https://marketmilk.babypips.com/market-movers https://market24hclock.com/Currencies/Daily-Highs-and-Lows The UI should be similar to the below for multiple currency heat-map https://moonance.com/ https://www.tradingview.com/markets/currencies/cross-rates-overview-heat-map/ When clicked Each currency should show something similar https://signalsbonanza.com/signals/ It should show a.) Daily Highs b.) Daily Lows c.) High - Low (its difference) d.) 1weeks High and Low e.) 1 months High and Low f.) 3 months High and Low g.) Direction - i.e Based on 1 week High it show show up or down directions i.e if last week high was 1 and today it is 1.3 then it is up direction (blue) but if today high is .8 then it show show down direction(red) h.1) Prediction- Based on history movement of forex High and Low it should approximately tell the next few days direction with Approx high and low range. (h.2) Testing - Use the historical and Economic calendar data, daiyfx IG report and see how good the next days prediction is happening and adjust the prediction to improve its accuracy. https://www.youtube.com/watch?v=1O_BenficgE https://www.dailyfx.com/sentiment-report https://www.investing.com/economic-calendar/ https://www.youtube.com/watch?v=n8iYQuaOTnU i.) Required graphs to be shown
Web scraping (URL) with VBA
Hello, I have an e-commerce website (not create by myself and no real database), I was able to extract main product information in CSV but I still need the URL 'page for each product to use for SEO and redirection. I would like a VBA macro using my website adress, using the product description, copy/paste them in google and extract the URL of the first product found (99% of chance to be mine). I can use VBA for some work but I cannot use it to be connected to google, internet... I can provide an excell sheet with website adress and product description, Column A : www.classic-red.fr Column B: product description in french, Column C: www.classic-red.com, Column D: product description in English. Expected, Column E: URL for french version, Column F: URL from english Version. Tell what you think and I am open to other ways as I am able to use it. regards regards, xavier
Excel Automation Expertise Needed
I'm looking for a highly skilled freelancer to assist me in automating tasks within Microsoft Excel. My goal is to efficiently manage and process basic data and return optimal results as well as a visual. related specifically to manufacturing foam blocks. Ideal Freelancer Skills: - Proficient in Excel VBA and macros - Experience with automation of data tasks - Knowledge of manufacturing industry a plus - Detail-oriented and analytical thinker Project Requirements: - Ensure accurate interpretation of manufacturing data - Generate solutions for rectangular and custom-shaped blocks processing Specific request: We are a foam manufacturing company and we cut foam to size from very large blocks on saws. We typically calculate the size to cut manually on the factory floor using the hard copy sheets (see attached). I would like to have an excel sheet to essentially mimic these sheets where you input the 3 sizes of the foam we'd like to cut and then the results will show the factory floor how to cut the block as well as showing a visual to the factory workers on how to actually make the cuts- basically creating these sheets in excel. Please let me know your thoughts on cost - this is likely more of a presentation basis than programming, but we will need some formulas and graphics to calculate and show the best way to cut the block and best way to to "yield" pieces from the block BLOCK SIZE IS ALWAYS 40 X 80 X 108 INCHES. There will likely be a couple iterations of this to get to completion.
I have a spreadsheet that requires VBA automation
I have a spreadsheet that requires automation. Can you help? I have MS Excel document where it presently shows tabs for: the following types of items: headware, miscellaneous, parkas, shirts, DEU tunics, FTU tunics, DEU pants, FTU pants, DEU boots, FTU boots On each tab, the headers are: inventory ID (its a number, mostly used for me to just reorder)., Name (title of the object for ordering), description (description of item), unit price (its based on a point system, not currency, and is presently ), quantity in stock, reorder level, and quantity to reorder. When I update this sheet, I want to scream. There is too many items (809 to be exact )and simply removing an item from each section as required, is extremely time consuming. I was thinking of making the sheet have another tab where you select "issue" or "return", type in the size and then it will auto removes or add it to each items count. I would also need another tab bulk new inventory to be added in (like 25 t-shirts, size small). But I have no idea how to do so.
Excel VBA Expert needed to create Macro
I'm looking for someone who has a very strong command of Excel; including VBA, Power Automate, and Power Query to support the work of my company's Information & Data Teams. The initial project is focused on writing a VBA Tool which will convert a matrix (manual raw data) into a column vector for use in another tool. The input and output formats are specified and we need a tool which automatically transforms the data.
Looking for a Python Developer for Stock Market Analysis
Looking for a developer who have experience in Indian Stock Market and can get live and historical data by using python (non API or API method to get data). Knowledge of python, excel, vba.
opportunity
VBA Expert - PDF Retrieval
Hi I need to retrieve print ready (large) pdfs from a local server and place them into a hot folder for printing. I would like to use an excel spreadsheet to dictate which pdfs are retrieved. Ideally the number of sheets required to be printed per pdf are also input at this time into the print server. Thanks Andy
opportunity
Developing a Container system in Windows on Cloud
I want to develop a container system in Windows for using VBA tools. I want to give clients a link where they can log in and run the VBA based tool. The link should be controlled by us and we should be in a position to see their activities.
Financial Modelling + Excel Skills for E-Commerce Subscription
Need Financial Modelling for E-Commerce Subscription Coffee Platform - Must be High Level Excel Skill and Understand Products Business and Profit Loss Please answer questions: 1 - Do you have Any Experience working on financial models for any type of subscription business ? 2 - Do you have VBA programming ability in Excel ? 3 - Can you create database and connect to Shopify if needed.? UK based people only please.
Dashboard in google sheets with charts/graphs
Create multiple dashboards with charts/graphs based on our existing real estate data from our property portfolio. Must have understanding of real estate development financials/metrics and expert in dashboards & data visualization. The best person for this job will have *your own* good ideas about what data to bring out in graphical form to best tell the story contained in the data, and have the ability to identity and highlight the most interesting trends and comparisons. I'm NOT looking for someone who asks "What graphs do you want me to make?" I'm looking for someone who says, "Based on this data, here are the most interesting graphs to make." All the data is maintained and up-to-date (in an google sheet). I just need someone to create interesting and insightful charts and graphs from this data. Dashboard(s) should have selectable list of properties to compare multiple properties, and graphically represent certain data points between the selected properties, such as e.g. Initial purchase price, Sale price per square foot, IRR, etc. Or compare cash flows between multiple selected properties. VBA would be a plus for working buttons/selectors and other controls. This is an open-ended ongoing project. Bonus point for anyone having good conversational English for quick video calls if necessary (any calls will be billable). Any background in real estate development metrics a plus
VBA Excel Automation
I am looking for a VBA Excel automation expert to assist with data entry and manipulation tasks. The project involves automating repetitive tasks and performing data entry and manipulation. Skills and Experience: - Proficiency in VBA Excel automation - Strong knowledge of data analysis and reporting - Experience in automating repetitive tasks - Ability to work with large data sets and manipulate data efficiently The client does not have a specific data set in mind but can provide a description of their requirements. The preferred timeline for the completion of the project is within two weeks.
Excel VBA data sorting
I have data of 2 columns and 20K raws in serial number,which I want to get classified through VBA and sequence of raws as per my requirement, could you please connect and understand it. Thanks Madhukar
opportunity
VBA EXCEL MACRO - compares two files and put results in a third
Hi all, Every working day I have a new .csv file containing a list of products. Every month I restart the cycle with a new file; so every month I have 21-23 files starting from the first working day of the month. In this zip file you have all files of March 2023 and the last day of February 2023. The number (first 8 chracters of the filename represent the date, year_month_day format. Ie: 20230330_Aggiornamento Prezzi Retail - MARZO.csv Is for: 2023 = year 03 = month 30 =day Every row of the file identifies a single, unique product: I cannot have a single file with two identical rows. Every row is identified by three variables: 1. “Codice offerta”; Column C: the unique code of the product (it is an alphanumeric number, in this example I used a fake string) 2. “Nome Trader”; Column B: the name of the company 3. “Nome offerta” ; Column D: the name of the product The first column “Data Rilevazione” (Column A) indicates the the date of the single day. Other colums (E to W) are parameters. Every file has the same column of the preceding file (the file of the day before). Every row/product, identified by columns B-C-D,can assume three conditions (do not consider the date in Column A): 1. is identical to that of the day before 2. is not identical to that of the day before, in one or more values of the E to W columns 3. is new, it means that the product did not exist in the file of the day before There is a fourth condition 4. the row (product) does not exist, but exists in the file of the day before In short: 1. the product is the same of the day before 2. the product has changed 3. the product is new 4. the product is no longer offered I need a VBA EXCEL 2007 MACRO that compares the two files and put the results in an Excel file like this: “Aggiornamento Prezzi Retail - MARZO.xlsx”. I start with the file of the last day of the month before (in the example, February 28, 2023; this file will be the “master file” for the month of March) the macro must run using this file as the basis of the routine. Al the date in Col. A are in yellow. Results depends on the four conditions we saw before: 1. nothing happens 2. the new row is inserted under the old one in the “Aggiornamento Prezzi Retail - MARZO.xlsx”; all the cells in E to W columns that had changed become green 3. the whole row is inserted, in alphabetical order by Col. B and Col. D, in the “Aggiornamento Prezzi Retail - MARZO.xlsx” and all the row cells become green (even the Col. A) 4. the old row in “Aggiornamento Prezzi Retail - MARZO.xlsx ”becomes light gray” (even the Col. A) During the year columns can change (ie, adding a parameter column)… it is not my fault… but it can happen. So I need an excel “parameters file” where I can identify ID columns (in this case B, D, C); date column (A); parameter column (E-W). In this file I have to identify, also, the “master file” (the last one of the month before), all others file are in one working directory. Thanks, Arnaldo PS PPH does non accept more than 3 files (and non .csv). I have uploaded an example in .txr; if you are interested, I will send all the .csv files for the work.
VBA - Machine Design / Intergration
Require a professional in VBA programming - Clear set of requirement… need a programme to be created to support with machine improvement capability.
Excel VB Macro Scripting
There is a Capacity Predictor based on the resource availability in a team and the total working hours billing all should be calculated in the excel in one click on each sprint. I would need some one who is having good excel VBA macro programming who can make the formula's effectively and make it worked I can provide the source excel file after the proposal if you don't have Macro programming experience please don't bit here this is kind of special skills required on this project.