We pays 100+ individuals for their freelance work every month. Instead of data-entry the 1...work every month. Instead of data-entry the 100+ individual bank details, name and amount into the bank portal, we would like to have a script that convert the details from Excel into a CSV format that is ready for bank upload in accordance to attached format.
...will be going to my website. I will have an excel sheet with 2 columns, one for the term and one for the url slug. I need an MS word macro to do the following when I run it: 1- go to the excel file, grab the first term 2- search the article for this term and add a link to it, using the slug in the excel sheet (The macro need to have the fixed part
We are developing a WordPress website for a client, who has 48 projects to put into their portfolio, which are being loaded as po...applied and customised is called Uncode. We will provide Dropbox links to a folder containing the copy and images, and are available for any questions. Images below show the page layout, which is clearly not complicated.
...text-file?rq=1 Python Threading: [kirjaudu nähdäksesi URL:n] Python Time functions: [kirjaudu nähdäksesi URL:n] and need some Excel and VBA work i need just simple one hour work for experts, fix rate whole work (2 to 5$ final) sorry for advance milestone or payment , payment after the approval of work by client
I need a SQL program to be executed from Microsoft access. I will need to print information on PDF and TIF files on header/footer - left, mid, left side in up to 250 character each. We have a program today (see attached), but only working in TIF and in a only one line.
double check excel files for missing data or errors Hello, i have some excel files i need checked, so i would imagine a skilled vba coder could do this very easily. files to check the following will be highlighted in report 1/. check missing data 2/. check for blanks or duplicates 3/. check for missing dates and missing data 4/. check for out of
Proyecto de desarrollo requiere programador en Access VBA con experiencia comprobada (Prueba online inicial básica requerida, por lo que se establece Micro Proyecto (10-30 USD) para dicha prueba) Los aspirantes recibirán el pago de su prueba y se seleccionarán a los mayores puntuados para un small project (Creación de interfases individuales) que luego
I need some help with API connectivity in Excel VBA to 3 cryptocurrency exchanges The following functionality needs to be created: 1. Get live price data (bid, ask, sizes of bid and ask) for selected crypto currencies - including depth of the market 2. Live price data collection and archivation. 3. Ability to access archived data. 4. Get cash
We buy/sell/repair tank containers. I am automating the records system and need help with form design and reports and general Access/VBA skills from a reasonably local person. Look [kirjaudu nähdäksesi URL:n]
Hi, I will provide a CSV file ([kirjaudu nähdäksesi URL:n]) and a link to HTML page. Task is to create JS that will parse given CSV and populate HTML (including CSS and JS). Task should take a 2-4 hours of work, please bid accordingly. Looking for people proficient in JS and CSS as more complex follow-up tasks are available.
Working on a number of VBA tool projects for my startup business over the past year. Realizing as I go that what I think I need the tools to do changes the more the business develops, and therefore I can't really hand anything off to someone to develop on their own. It would be worth it for me to have someone I can consult with to assist me. Much
I am an expert in VBA Excel automation. I have done many projects including Live Stock market analysis, Data formatting, Outlook Automation and many more. Please check my YouTube link. [kirjaudu nähdäksesi URL:n]
I need someone to add Business Application Header and Business File Header to existing xml file. The code to create XML report is in Access database attachment. I need someone to add code for creating Business Application Header, Business File, and all declarations exactly as shown in samples. Description and samplevs are are provided in word and pdf documents.
Hello, I need someone who knows vba and sql in access to work on access form just need to do 25% of work. You need to understand the work already done by someone them and remaining to continue with the 25% of work. Budget is 30$.
VBA script required to: 1. Clear contents of a range of cells, when a value in its corresponding cell changes - up to 5 ranges shall be possible. Code exists to perform this function on one range and can be provided if needed. 2. When a use enters a single value in the same range, and then drags the value across a range of cells, code must evaluate
I am looking for the exact VBA code that will allow me to do the following in Excel: I want to have a custom function in Excel that references two other cells, one with the ticker of a stock eg AAPL and one with a date. The function should then pull the closing price of the stock on that date. The API I want to use for the code is AlphaVantage, they
...coding for data management projects. The data management projects involve manipulating and organizing files with the use of R studio. The project involves creating detailed excel databases with the use of content found online on the websites of Investment Banks. I need detailed spreadsheets with color coded data. I also need help with the transcription
...ugly report that when pasted into a "converter is supposed to produced a clean version with raw data that can be used to create further analysis with Pivots or graphs. The VBA in the converter is giving me a runtime error 91 Object variable with block variable not set and I do not know how to fix it. When i hit debug - I get this " intColRoomType
Hello, I have a list of images URLs in an excel file, I would like to have a macro file that I can use often to download the images and then in next column put his path that the image has been download, then in the next cell, the path of the image renamed. Thanks to contact me to discuss about it
... I need someone who can execute queries, from within Excel VBA such as the following: [kirjaudu nähdäksesi URL:n],THB,HKD,GBP,EUR&base=USD To retrieve currency data and then paste it into excel cells. The HTTP query from within VBA is quite simple to build. Example: str = "https://api
Background: Excel spreadsheet has two workbooks: One for data entry, one for controlling entered data. Entry to a range of cells (A1:A10) on data entry sheet is LOV controlled by a table on the control sheet. The table controlling the LOV is exhaustive and the user cannot enter values outside the range. A second range of cells (B1:B10) on data entry
...statement, - Tabulating rent rolls from monthly reports - Creating financial models for real estate development deals - Analyzing debt instruments, Excel data manipulation and formatting, including using VBA to automate such tasks. - Maintaining historical records by filing documents into Google drive - Preparing financial reports by collecting
Currently placing market orders through IB TWS BasketTrader with separate csv files for 6 segregated client accounts. Need to integrate the task to one Excel interface/worksheet. Column A contains the list of desired symbols separated by short and long. All intraday market orders with specific entry/exit times per account. US regular trading hours only
Please note: this project is only for Vietnamese Freelancer. A new forum setting up for Vietnamese high school student and require some initial content. I required at least 400 posts on forum. Further details to be provided when freelancer is chosen.
This project is to build a VBA macro to cycle through a drop down list of dates contained on an open internet explorer page and print them to pdf via pdf creator. For the file name I would like to be able to type a 6 digit number at the beginning of each run to be used with a date stamp added from the webpage (I.e. the pages date that is currently being
Produce a form, which, upon input of a person’s date of birth, can classify the person according to the following age groups: Baby (< less than 1 year old); Child (1-11), Teenager (12-19), Young adult (20-35), Middle adult (36-65) and Older adult ( > 65). Your program should: • allow the user enter the date of birth, either via InputBox or a Form; • validate the input(s);...
I have a website running WordPress (php /mySQL). I have pdf forms that are auto-fill forms. My user will log in and based on the info from their user account, needs to populate a pdf form for them to download. They will be able to save the pdf to their pc. Have looked at GravityPDf for a type of solution, but it looks like the downloaded pdf will have
I have a web application from which i want to call a visual studio project that will give me a "telerik" report. The data will be loaded from a webservice. I am not very familiar with this so I need step by step guidance in order to achieve that.
I have a spreadsheet in excel that includes a macro simple (less than 50 lines of code) It mainly just moves stuff around I have recreated the spreadsheet in google sheets [kirjaudu nähdäksesi URL:n] but I can’t recreate the macro as I don’t know google apps script. Is this
Develop VBA analyzer that can access stock pricing information from the Internet (e.g., [kirjaudu nähdäksesi URL:n]) and perform basic analysis on them. To be completed in 4 days.
I want to buy and customise an off-the-shelf, WordPress and wooCommerce website. Add images supplied by me. Approx 100 images in four categories.
I need some help with API connectivity to 3 cryptocurrency exchanges. The following functionality in excel VBA needs to be created: 1. Get live price data (bid, ask, sizes of bid and ask) for selected crypto currencies - including depth of the market 2. Live price data collection and archivation. 3. Ability to access archived data. 4. Get cash
Hello Salion. We create Excel templates and custom spreadsheet solutions for global markets and are looking for a teammate who is extremely skilled in Excel and VBA. If you are interested joining us, I would like to discuss opportunities with you. We may work on some ad-hoc tasks or more complex projects depending on the situation.