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 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
Hi , I need demo ro using userform in outlook use to set a...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 the new appointment will be from time 13-17
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
...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 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.
...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 for lookup and select
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
Need to change the background of the photos to a real outdoor location. The location should be natural and normal looking and not too professional. Also, need to add objects to the photos. The objects added should look natural and real as if they were present in the original photo.
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 am in need of a design engineer who can put together a floor plan, el...installation of a 10,000 pound coreless induction furnace, a holding furnace and draw line for continuous horizontal casting of brass and bronze alloys. This installation would be an addition to our already existing foundry at Chicago Extruded Metals Company in Cicero, Illinois.
...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 buildi...the sales details (customer information, products sold, payment details) back to our database. We are open to suggestions on a strategy for implementation. This project is time sensitive so we need to make sure that you can commit to it right away (implementation 2 weeks max). Thank you.
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.
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.
...description will follow- Nous sommes à la recherche d’un(e) photographs professionnel pour un shooting de meubles de jardin dans les régions de Ho Chi Minh et Quy Nhon - Période : Janvier 2019. Il y aurait plus de 200 références à photographier sous plusieurs angles. Sachant la météo capricieuse...
Based on a extension I need a unit addition parameter User specifies that product A has to have 5 additions each, so when the client orders it he will only be able to make an order as in 5 , 10, 15 units and etc, if 7 then 7,14,21 etc
Hello, I have an Access database with an existing form. I need someone to develop a script that exports the form as individual pdf files for each record in the database. The name of the pdf file will be derived from a field in one of the tables. I will upload an example Access database shortly. Thank you, Simon
I want to prepare a excel workbook in which, I want to enter data about the materials and labour required. Accordingly, in a second sheet an analysis will be prepared. The labour rate will be intered in first sheet as an input. Each and every time a new PDF need to be generated with given file name format and need to be saved. Similarly the loop need
To an existing android app the following additions are needed. - Multi-language - Login module with token and key