Excel VBA jobs
I have a Python script which basically runs an Excel macro, but it is giving me a Runtime Error 1004. the macro basically refreshes Bloomberg formulas in the sheet. The macro runs fine within Excel but gives the above error when calling from Python.
Background: We have approximately 60 separate excel files that contain approximately 50 tabs each. Each tab contains the same columns but different row data. Some files contain similar row data but not identical. The data relates to retail locations and the price of a product on a given date. Each tab on the file is a different state within the USA. The Desire/Intended Outcome: • Have a place/tab that calculates the past trend data for each row, on each tab, to allow us to see the median and mean price that was offered for this product, at each ‘location’ over the history of our data. Have the same data calculate the median and mean pricing over the most recent 12 weeks of data, the most recent 26 weeks of data, and the most recent 52 weeks of data. • Add data each week when new pricing comes out, and have that data ‘recalculate’ the mean and median pricing trend as listed above. Some simple method to paste or merge files to allow the new data to be imported into the master spreadsheet that contains the calculations and graphs. • Have a line graph that shows the past 12 months of pricing data for any location, by clicking that location from a drop down to allow for the line graph to be displayed, and then printed. • A version that allows us to print on one page the 12,26, and 52 week data trends for any one location. All of this should be done in Excel, not in another program. We should be able to drop in/paste in the latest weeks data to allow for the data to update A sample version of one of the 60 spreadsheet files is attached. Please see all of the tabs on the sample file.
I have a process that needs be built using workfusion
Hello, I Need to copy data from pdf to excel using macro. Pdf have some data including image form which need to be copied in excel . More details will be given to selected freelancer. Happy bidding. Thanks
Design a complex mind map for me using a particular software. Assume any marketing case and design a mind map.
Hello Everyone! The goal of this contest is to develop two tools or codes: 1. The first one will have to rename the *.txt files which contain a conversation between two usernames with the following format: [login to view URL] 2. The second one will have to open all *txt files in a single workbook where each file must be a different spreadsheet of the workbook. It must also include the headers and the format stated in the excel file. *Feel free to code in the language that you are most familair with. **In the case that nobody performs both tasks, the prize will be awarded for the one who provides the best solution for at least one of the two tasks stated above. *UPDATE: Given the large amount of entries received so far, I ma adding an additional feature, which its not mandatory but will add extrapoints to the one who achieve it. The additional feature consist in merging all the worksheets generated from each file into a single one with an additional column with the name of the original worksheet. Please see example attached. A nice user interphase will also be considered. Thank you! Thank you and looking forward to meet you! Cristobal
I need a Excel Macros expert for my current project. If you have knowledge please bid. Details will be shared in message with the selected freelancers.
Hi Jake S, We currently have a betfair bot that scraps [login to view URL] and looks for price movements before triggering a bet on Betfair. We are looking to extend this to read off TAB, Crownbet and place bets with other Corporates.
There is data on which around 3 to 4 rules need to be applied using excel macros
Build a multi-users (login password for each) software dedicated to market intelligence analysis. Forms to fill database, easily updatable. Aggregated view(market) and detailed view (1 competitor)
Build a multi-users (login password for each) software dedicated to market intelligence analysis. Forms to fill database, easily updatable. Aggregated view(market) and detailed view (1 competitor)
Hello, I'm searching for someone that can made for me an simple excel tool that runs an import job based on this api info [login to view URL] It must check every x min. If there is an bid higher then the one I have did on an specific advertising. When this is happening the tool must create an new higher bid where there are an few parameters like max bid amount and the steps the tool can use. Questions let me know it.
Details of the project; 1-Everyday, Daily all matches we have in history must be transferred to excel. (Example = 09.05.2018) 2-All matches transferred to Excel must include the following conditions. a- Opening and closing rates of the first half of the matches. b- Bookmaker only Bet365 c- Get daily data with VBA. d- The picture of the sample excel format and website has been added to the announcement.
Boa noite, gostaria de uma planilha bem trabalhada que atenda minha necessidade de forma rápida e inteligente. Registrar semanalmente os times, como também qual banco pagou, a quem pagou, qual a data do pagamento e no final um balanço financeiro de quanto foi recebido em cada banco.
Our contact info (name, email, personalization data...) is in a Worksheet in Excel. We want to be able to click on a row, have VBA create a personalized email body, Stop and let us check the email and maybe add additional personalizaton, then Send. Then, track an open, click thrus to various links, forwards...
i have xls wanted it open in excel file with groups and with sub totals and with design
We have a environmental program that is based on an excel spread sheet. Its called an Environmental Management System which is a process including assessments, planning and checklists etc... The tool is not about 5 years old and looks very dated and unprofessional. We are looking for a talented innovative person to come to terms with how the process works and to improve the flow and efficiency for the user as well as making it look much more professional. We have a budget of about $500 to get this done but it it works out well we would also be looking for a more extensive review and improvement (possibly using a different platform). Do you experience in using excel to create user friendly and professional looking processes??? Also are you available to spend about 4 x half days to work with us on this
We have a data base in a spreadsheet in an excel file. We would need a program-app-formula that allow us to write a new data in our smartphone and update it automatically in that spreadsheet. Can you help?
vba code causing memory leakage...program causes Excel to crash.
I have a database that I use for my business and need help automating several aspects of this spreadsheet.
Freelancer should re-design the dashboard to make it more dynamic and easy to control
Hi, I have an excel file I want to use advanced auto filter in it. If you can do it using VBA. It will be grate. Thank you.
I need a Excel Macros expert for my current project. If you have knowledge please bid. Details will be shared in message with the selected freelancers.
I need a Excel Macros expert for my current project. If you have knowledge please bid. Details will be shared in message with the selected freelancers.
Hi I want the person who is good in excel tutoring and make good videos for excel and VBA. Before awarding atleast one sample is required. More details in message Only $2 per hour is the budget if you bid over than that you will not be selected we need 100 or more than that videos need to be created.
I need to be able to use your excel VBA, or SQL, or other methods, to download any information about stocks that I want on the stock exchange. You need to create a solution that allows me to do so at a click of the mouse, whenever I want. I am not a programmer so you might know other better ways to do it. Please message me with details of how you intend to do so. I prefer it to be like a website that allows me to choose the fields I want to download.
We are a company that provide design, fit out, refurbishment and furniture services for businesses and schools. ([login to view URL]) We need someone to build our quotation template in Excel into a cleaner and faster tool that we can use for producing quotes as efficiently as possible. Our quotes are very varied and very complex in construction. I would like to discuss in much more detail with interested freelancers. Prepared to pay good money for a smart, flexible and willing freelancer.
I wish to provide aspiring and experienced models a platform to showcase their talent in print shoots, catalogues/magazine modelling, short films, web series etc.
I need to be able to download all metrics possible from stocks exchange market at any time I want, so that I can do my own filtering. So you will need to write some VBA / queries / API that allow me to do so, by just running your macro / query / program. I’m not a programmer so my understanding of the requirement may not be the best way to do it. In any case, let me know only if you can create something that can support such a request. To prove your understanding and capability, please message me to show me a sample of the market that you have managed to download using your method. Cheers
I want a macro that can be used to restrict each cell to only two lines of text and each line not exceeding a certain number of characters that can be specified for each selected group of cells. The macro should not allow the user to exceed those parameters during editing of the cell (as opposed to alerting the user after the fact).
I want a macro that can be used to restrict each cell to only two lines of text and each line not exceeding a certain number of characters that can be specified for each selected group of cells. The macro should not allow the user to exceed those parameters during editing of the cell (as opposed to alerting the user after the fact).
I need a project done urgently, within the next 24hours. Reword article and extract chart data using excel using a program
i need a product catalogue build with excel using for b2b sales. Basic function is to select product from a list and export the selection to a new file Also calculate discount depending the quantity
create a scheduler that is easy to use and allows for automatic email to the staff when published. see attached
I have some work, in an Excel spreadsheet. we will be working together over meeting ID
I need a Excel expert for my current projects. If you have knowledge please bid. Details will be shared in message with the freelancers.
I need a Excel expert for my current projects. If you have knowledge please bid. Details will be shared in message with the freelancers.
I need some changes to an existing website. I need you to design and build my blog. please first check the link and bid your amount [login to view URL]
BOM = Bill of Materials. It is a document used that has details of all the raw materials that are needed in order to produce one unit of a finished good. In the Macro, we need each BOM to be in a particular format in one sheet only. The Macro helps us to create a BOM in a separate sheet for any one of the Raw Materials present in a parent BOM by the click of a button.
I have an assembly language project are you experienced in this?
Need someone to take an 2013 Microsoft Excel Spreadsheet with VBA code and convert it to new office
Need a list of - Jewelry + Watch USA Dealers From - [login to view URL] Company Name Contact Name Contact Email State City Zip Phone Deliver as Excel file. Time estimate needed prior to award
I am looking for a Excell VBA code (1st preferred) or Matlab code (2nd preferred), that will scrape the following addresses for information: Data source 1 of 2: [login to view URL] -> From this source I want a table of reported earnings for Norwegian stocks. The table should be from "now" and to as far back as the data on this site goes. The table can have the columns that Yahoo chooses to use. The most important piece of information is the reported EPS vs EPS estimate for each stock and the date of reporting. This code must be structured into 2 functions: One to download everything, and a 2nd function to update the existing table (saved table to disk, like an .xls). The second function is useful in the sense that I do not need to download everything again daily, but only the recent reports since last update. Data source 2/2: [login to view URL] -> This is an economic calendar which presents macro numbers all over the world. Like the above task, I am interested in two functions: One to download all, and 2nd function to update the database (.xls) since last database update. Here you must not filter by country; I am interested in all countries as presented by default by Yahoo. If you complete the task I am interested in the following: Source codes and the latest outputted tables in the "database" file as .xls or .xlsx Thank you!
I need someone to link excel with websites to download stock information metrics from some websites automatically. And once developed In just have to refresh to download data automatically so i can do my analysis on that .
i have xls generated by program, i wanted it open in excel file with group, sub totals and with nice design
==No copy-paste voodoo programmer please, I already have enough bad experiences. Thank you for your understanding== An MS Access project went much different from what was intended. In a nutshell, the project is a customized stock management system with 5 different user levels. Each level has different permission for functionality and data accessibility (see [login to view URL]). Authority level: Level 1 > 2 > 3 > ( 4 == 5). Level 4 & 5 == Read only specified sections. Level 3 == Read-only. Level 2 == Read & send revision request to level 1. Level 1 == Read, revise, and approve (or reject) revision. Unique key == composite key of (MC, OP, T, CB, CODE, TOOL NO). Current problem (work scope): I believe it would be best to go level-by-level. Starting from the top (level 1): - Level_1 user can edit data directly while using "search database" function, but there is no <OnDirty> trigger that should lead to change confirmation page and compare "before/after" prior to committing change. - Data within “Revised data pending approval.” cannot be revised before accept. - After clicking “Accept” data revise request (sent from level_2), data does not go to the main database. Does not appear in search result either. - “Compare difference” is not functional. The changes committed do not appear. - “Update” is not functional. Data cannot be imported from Excel anymore. - Need data import function for each of the column, as users store data differently - “Hide” column is not functional. It supposed to hide entries which has the “Hide” box ticked. - Need to search something before the full list appears (bug, low priority). Requirement: - Intermediate knowledge of MS Access VBA. Please PM for further information.