We would like to get a simple macro if you are familiar with VBA in excel. The base is an excel sheet with a few hundred-thousand building addresses. For each address, a link to a pdf exists. In this pdf, on page 1, multiple data need to be read out and put to the corresponding address line. On page two it should be counted how many "apartments" are
Hi there, Looking to have a freelancer update an Excel document's VBA script to provide better outcome. Attached is file (see 'Master_Contact_List' tab), which combines all sheets into a single page. Hoping to have the below achieved for 'Master_Contact_List' tab: #1 Only use columns A-J from other sheets (not collect entire sheet) #2 Have predefined
I need you to develop a VBA script to convert Excel to JSON files. For every row, it would generate one JSON file.
We pays 100+ individuals for their freelance 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 in Arabic. I created a macro to add a link to Arabic words, but it had to use hex decimal codes. it can be found here: [login to view URL] Please think about the code and test before bidding. I don't want to get stuck with a developer
...file?rq=1 Python Threading: [login to view URL] Python Time functions: [login to view URL] 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.
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
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
...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 balance 5
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 [login to view URL]
Help us create barcodes with commands within them. For exam...create barcodes with commands within them. For example: abc<TAB>123<TAB>def where <Tab> means that it will jump to the next cell to write the next set of characters. We use this vba : [login to view URL] and we do not want to migrate to another solution.
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. [login to view URL]
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
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 need a logical argument coded in VBA. I want to populate a calendar dependent on if a person is assigned numerous tasks. N10 is todays date cell F is the task start date column J is the task end date column Person is Dominic C, D & E are the columns that could contain the persons name I can use the following and copy it across the calendar if I have
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
...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
...need someone who can execute queries, from within Excel VBA such as the following: [login to view URL],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
...exhaustive and the user cannot enter values outside the range. All of the above is designed and working as intended - it is for background only. Spec of what is required: Excel VBA script that automatically clears the contents of either cell when the value in its neighbouring cell changes. Typical use case: User picks on A1 LOV and selects "Fruit" as the
...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, analyzing, and summarizing
...happen with the AUTO/AUTO ALL buttons in off positions to avoid conflict. Upon, opening file, VBA/Excel needs to establish auto-login to all the client accounts. Also need Excel/VBA to send an email alert from my Comcast SMTP email account/login, to two other email addresses if any cell values in Open Positions (cell N15:S15) change between 0930-1600 EST
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);...
Il progetto consisterà nella esportazione di un contenuto di una pagina web. L'idea è quella di creare una codice VBA con delle regole per andare a estrapolare tutte le info necessarie dalla pagina. Vi allego qui un esempio di una pagina tipo. Solamente tramite delle credenziali è possibile accedere al sito quindi lo script dovrà essere implementato
...hlw/edit?usp=sharing but I can’t recreate the macro as I don’t know google apps script. Is this something you could help with if so what would be the cost? I include the vba code below Thanks Neil [login to view URL] = False Dim lastrow As Integer Dim user1 As Integer Dim user2 As Integer Dim total_users As Integer total_users = [Totalusers]
Hello, I require an excel expert to work on an existing excel sheet. You must have an excellent knowledge of Excel VBA, Macros and add-ins. The sheet already contains a lot of existing code which has some bugs which need to be fixed. The main part of the project is to create an add-in for mapping. This need to be dynamic. It needs to map the values
I need a VBA expert for my current projects. If you have knowledge please bid. Details will be shared in message with the freelancers.