...client account/column. Ideally that would 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
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
I'm here for some help for my wordpress project I need someone to build my homepage and some related pages like 'contact us', 'about us' etc. I will provide ...'contact us', 'about us' etc. I will provide KingComposer and premium theme. Also you will use my own text and i'll provide a sketch to make an idea about my preferences. Feel free...
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);...
...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 [log ind for at se URL] = False Dim lastrow As Integer Dim user1 As Integer Dim user2 As Integer Dim total_users As Integer total_users = [Totalusers]
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 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.
Saludos cordiales, estoy trabajando en un proyecto de una hoja de excel para uso de pro-formador y base de datos, para una micro-empresa en el área textil, he avanzado algo con la programación y la obtención de costos en de los productos, y necesito ayuda para darle el acabado de presentación y que esta calcule algunos parámetros, necesario para el negocio. espe...
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 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.
I need a VBA expert for my current projects. If you have knowledge please bid. Details will be shared in message with the freelancers.
Necesito un código en VBA que extraiga la data que está en la siguiente web: [log ind for at se 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
please only German programmers Das Projekt muss mir VBA in Excel realisiert werden. Die genaue Beschreibung ist im Anhang zu finden. Es sind zusätzlich Dateien nötig, um die Aufgabe zu erledigen. Dies ist ebenfalls im Anhang enthalten. Die Programmierung soll in der Datei "[log ind for at se URL]" erfolgen. In dieser sind bereits Module und Code zur vorgesehenen
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.
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.
I need some changes to an existing website. I need you to design and build a landing page.
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
We have a product which is mainly for the use of Tourism Operators and free lance photographers. I have a list of topics I would like articles written on. I am after someone who can research topics really well and write them.
...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 in the development of the excel spreadsheet. It will be for Mac and PC, 23 bit and 64 bit, 2010 - 2016. VBA's with the
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. [log ind for at se 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 ...