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.
OMO_Import - Error Handling when item prefix identifier does not exist in the master. OMO_Import - Remove filter before starting import (if filter is on) OMO_Import - Better copy of new columns so that formatting and Header formulas are carried across. OMO_Import - Autorun "creatlinks" macro at completion if new items are added Runsheetgen - Borders on either side of drop instances if po...
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 have two excel files with a lot of macros and formulas and different things and I can't figure out how to merge them into one file. One file has like 20+ sheets and the other file just has one sheet and I want to have them all in one file (you can move the 20+ sheets to the 1 sheet file, or move the 1 sheet to the 20+ sheet file, or vice versa).
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
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.
...have an online business with all of my client records on a web portal. I need to build a database in Excel of all of these records, which requires copy/paste from the website in to excel. I have timed myself doing this, and without the help of any macros, I am able to complete one client record per minute and I have a total of 615 client records to enter
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
Need the file automated. I can provide a full walk through on how its currently done, but would like to automate the file! I have to filter every interval and it pastes data. I would like to avoid filtering every interval.
...couple/few hours of design help: I have a set up a simple online store for selling domain names, using Wordpress and Wordperfect. I'm experienced in other platforms (sql/vb/vba, etc) but novice with web design. The site is basically two pages: The "Front page" with links and product list, and the woocommerce cart/checkout page(s). - I'm very open
We are using Ch...server via HTPP POST. 7) Repeat from point 3 until the next day, then repeat from point 1. The scripts also can be run manually, for testing. If possible, the new scripts, or macros, or whatever, should run in a standard Windows machine. And have to be editable, inform about what is happening, and have a verbose mode for debugging.
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.
- Updating of pivot tables to ensure that numbers change when cells are updated - Advanced filtering - Having a data entry sheet and using VBA to transfer the new data to the bottom of the existing data set - Improve user experience by making future data entry convenient
I have an excel spreadsheet with some VB code macros that prompt the user for data input via popup screens, and output some data in a pdf format that I was looking at getting translated into google sheets. This macros that is being used to track a few different things for projects, and was interested in seeing what sort of ballpark timeframe and cost
...quality controls. If you can say yes to the following, then perhaps you can join our merry band! 1. Advanced level of excel ability and familiarity of using macros, v-lookups and templates. This means that you are excellent with excel ! 2. Expert data validation skills and meticulous attention to detail. Ability to find the unusual or odd..... Data bods
...steps development a downloadable excel calculator. The interface and calculations are confirmed and tested. To improve the usability of the tool, we will need the excel spreadsheet to host a number of specific VBA's to improve usability and functionality. I need a VBA programmer for approximately one week with proven VBA credentials to further assist
We are looking for Freelancers that can help us in building a solution where we can upload/downlaod information from an MS Access database to WooCommerce and back using the WooCommerce API. [login to view URL] We would need an expert in communicating with the Woocommerce API and Parsing XML data. The goal is 1. Automate and import/export of products from Woocommerce which would also include imag...
Need VBA code to select a row in external SysListView32 and send right click to it using sendmessage or postmessage API. Assume hwnd of SysListView32 is known.
I need a dash board build in Excel. When I paste the data, it needs to process it onto a dashboard showing me sale details as I require. Also I need the data to extract details from master file to sub files on click.
Hi my name is Sotiris Kazabakas, I need an excel with some pop-up alerts and sound alerts. You will find more on the word that i have uploaded which includes a description of what i need the excel file to do. For any questions do not hesitate to ask.
...need to develop a form in Access 2007 for Microsoft Windows OS, which is linked to an Excel Database. So, that, as user fill up an Access form and hits Submit button, the data gets noted in Excel Database. This form is going to be used by over 50 people (on different computers connected to same WiFi) linked to same excel spreadsheet. Master Keeper of the