I'd like for you to write a simple web-based or VBA that will help me to reconcile the bank account every month. INPUT: - bank statement in excel format - account statement in excel format - date range Process - identify all transactions on the bank statement that show up on the account statement Output - if transaction amounts match, mark them as
I am currently an avid fish enthusiast living in the Netherlands. I want to use an Arduino Uno and an RTC (DS3231) to automate my aquarium lighting. I have never written code before so that is my issue. I am looking for someone to write the code to create a sunrise, sunset, and moonlight effect using an APA102 LEDstrip.
Hi I would like somebody to teach me/ do the code in python on how this problem can be solve. I have a watermarked document (both background image and footer which is repeated in 700 pages). Instead of deleting them one by one I believe this can be done using python. The person ideally can teach the basic code. I have very basic python knowledge and hope to enhance this. The doc is attached.
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, 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 someone to send 400+ unique visitors per day to my funnel using a unique traffic method. I don't want to use Facebook Ads, Instagram Ads or SEO as I'm already using them. Visitors need to be targeted and i should expect a percentage of them to convert. Message me with your offer!
...INR 1000/- Word count: 750 I need an excellent technical writer to write a Press Release. Topic: Concerns related to lack of SSL Certificate compliance and fix with fully automated free SSL certificate app This project will be ghostwritten, and I'll have copyrights of the content. Please note: 1. Articles should be unique. Even if 1% plagiarism is
I have an old workbook - xlsx format - that I forgot the password and need to unlock. Since its newer than Excel 2007 its encrypted and the old style VBA password buster wont work. To confirm you have unlocked the workbook show me "Period 1" sheet
I need vba that will autofill and autoclick through the creation of a Salesforce opportunity. You don't need to know anything about Salesforce. Take csv data in worksheet and fill fields, click buttons to move to next screen, etc..
I have an Excel tracker file from which two dashboards and graphs are to be generated. The tracker gets updated regularly. The dashboards and graphs are to be updated automatically. Time line to complete task would be 2 days. More details will be shared with short listed freelancers.
Hello, i am looking for someone who can scrape the DHL parcel information with MS Excel vba. The tracking number is given (Column A) and the tracking information (Column C:L) should be scraped from DHL page (Link in Column B) This should regulary be done for up to 50 tracking ids.
I just want to automate my data entry for inventory movement with excel supported with mobile barcode scanner. So whenever i scan the barcode of an item using mobile phone, when i key in the quantity, it will go directly to respective cell and to the correct date
I need a Macro which can extract specific data from a word file and then generate a User form with drop down having the data from the word file and finally generate a word template with the values selected from the drop down in the user form
...I need demo ro using userform in outlook use to set appoitment step 1 : build this simple demo userform in outlook step 2 : set appoitment based cretiria the vba code should look for appointments in the calendar in date 14.11.2018 in this exemple if from example there is appointment in this data from 10-13 then
I have two sets of data wich have DATE, TIME and four other values, some of those dates/times are mismatched, they exist in one side but not in the other and vice versa. I need a macro/script to align all DATES and TIMES and delete the mismatched values in sheets up to 250k lines efficiently. I have uploaded one examples of raw data that need to be aligned.
...ABC 1-Nov-2018 24 ABC 5-Nov-2018 36 XYZ 12-Aug-2018 32 etc We want a macro VBA Program that can take this data and do the following: 1. Summarise to monthly level by product Store as a new sheet. 2. Apply the Excel Forecast Function to the monthly data for each product and output in the following format for the next 12
Necesito un código en VBA que extraiga la data que está en la siguiente web: [login to view URL]:9d16c843bb5201b86696ba79f964adbf/stock/AAPL/financials y la coloque en una hoja llamada DATA. Adjunto el archivo excel donde debe realizarse el codigo. ---------------------------------------------
I need a way to capture all redirects from a pre-determined URL, track and output data. Would prefer headless Chrome, but am open to alternatives. This needs to run on a Linux environment. CentOS/Debian etc. You would set up the software and utilities required to make this work. I will have the Linux box set up to your specifications.
Hello, I am looking for a program or script that can automatically post advertisements of second hand selling website. For Mac. The website is [login to view URL] there I want to automate advertisements, so they will be deleted and repost again in intervals of 30 minutes for example. Thanks! Jan Renders
As the title says, i am looking for someone to automate the process of making verified accounts for a popular shoe site. The program should have the following functionalities. 1. Able to import proxies 2. Able to import emails 3. Able to generate random data (Firs,last name, Password,DOB,Gender) 4. Able to import phone numbers 5. Able to verify the accounts with the texts received on phone numbe...
We require something that can finish our current website, it is a classifieds based site for adult services for the Australian Market. The site is close to being complete from the last freelancer but then they failed to communicate and the site was never finished Freelancer must be ok working with adult content The site is made using the theme Listify by austoundify, we have purchased the themes p...
I have two sets of data wich have DATE, TIME and four other values, some of those dates/times are mismatched, they exist in one side but not in the other. I need a macro/script to delete those values and align all other entrys in mutiple sheets.
Code to copy from a worksheet with multiple pivot tables, timeline slicers, and a pivot chart into a new workbook and retain formatting (freeze pane). We need to copy the date from the pivot chart to the a new workbook based on every filter in the pivot chart
Need an automated telephone answering, and live call transfer system (i.e.) virtual call center, built for inmate chat line The system we desire will need to do the following; 1) Answer the incoming call. 2) when prompted by the callers automated system, Press 0 to accept the incoming prepaid call 3) Live call transfer the caller into an extension
Try to code in VBA but it's not working. Trying to select on range of 2 original columns and match a new column and replace it with one of the original columns.
Convert a Single Excel Macro VBA Calculator file with buttons and simple math formulas to an Android App to be used on Android Phones.
Hi, I am looking for an experienced content editor and a designer for a web platform development site. If you have experience in technical and non-technical areas of website content, please respond with links to your previous work. Thanks,
I need an Instagram automation like [login to view URL] or [login to view URL] where clients can log in and manage their own Instagram growth. Features: -Auto- follow and unfollow -auto direct message -target chosen- hashtags, accounts and locations -free trial for clients (but takes billing info and takes -payment after trial) -Payments to be taken monthly via PayPal ideally -Clients can onl...
I have an Excel spreadsheet that uses the worksheet_calculate function within VBA to monitor changes to a cell on Sheet1, which in turn triggers a timer whenever a change is made to that cell; worksheet_calculate is used instead of worksheet_calculate because the cell contains a lookup formula that references a table on another sheet within the workbook
Manufacturing business wants to take a daily download excel file from GE Appliance website and create a Macro/VBA tool for non-excel users. The tool would look up our internal part number and box count from a table and output a pick sheet for shipping with customer part number, our part number and number of boxes. Should be able to select time range
Seedbox script, whmcs module for automation & control panel Seedbox script: WHMCS automated Seedbox module * Needs to create a seedbox on a server with available space, must be able to use multiple servers with details from a WHMCS order form 1. Create SSH account (chmoded so other users won't have access to homedir) 2. Create ruTorrent+rtorrent
I have a very complex macro which takes a csv of all our orders and put it in a neat printable html format. It isnt doing one of the things its supposed to properly so I need that fixing and I also need to give it some extra functionality.