Hi , 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
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.
...like this at a transactional level: Product Date Quantity 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
Necesito un código en VBA que extraiga la data que está en la siguiente web: [iniciar sesión para ver URL]:9d16c843bb5201b86696ba79f964adbf/stock/AAPL/financials y la coloque en una hoja llamada DATA. Adjunto el archivo excel donde debe realizarse el codigo. ---------------------------------------------
Hello, We are moving from a DB that was designed using PHP and forms to a Pre-Built product. They charge by the number of tables in the DB and I need someone to look at all the tables and consolidate them so that we can save some cost in migrating this to a new service. You will have access to MYSQL/PHP admin where you can pull the DB down and work
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
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 "[iniciar sesión para ver URL]" erfolgen. In dieser sind bereits Module und Code zur vorgese...
Combine my two ZOMBIE trailers to create one master cut. Add better gun sound effects and gun flashes Download footage from this playlist(scroll to bottom of the list)(BEST VIDEOS are at the bottom): [iniciar sesión para ver URL] The best ones are #53 & #54 Other material that can be used:
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.
I have two independent functional Android apps and wish to combine these into one. The apps are a Sony Remote camera app and a Tensorflow object detector app. I wish to apply object detection to the livestream from the Sony camera. I will send the zip file to interested parties after discussing the project
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
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 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
...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. [iniciar sesión para ver URL] We would need an expert in communicating with the Woocommerce API and Parsing XML data
This is a simple project for someone who knows excel. Combine data from two spreadsheets that have common data in one column. The first spreadsheet has contact data. The second has account data. There is a common account number column on both spreadsheets. The delivered product will be the contact Excel spreadsheet with all account data on the
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 t...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.
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 have some work, in an Excel spreadsheet. Looking for a macros to combine multiple csv files and filter based on set of keywords and remove duplicates based on one column.
I want to prepare...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 be executed up to the last entry in the first sheet.
I have two workbooks, each with multiple worksheets. I need the information from one worksheet (as it is inputted) to populat...with multiple worksheets. I need the information from one worksheet (as it is inputted) to populate to another based on a couple of variables. Best done in VBA. I will provide the working files to the successful candidate.
...sell prices. Our business has grown from 20 odd products to over 180 products and the spreadsheet is now cumbersome, easy to “corrupt” and difficult to navigate. We seek a VBA expert to re-write our software to correct the above issues. ie standardised entry forms for stock, standard template for new product entry, time trial database & linking, labour
Hi there, I have three columns in excel with core data and three columns with input fields, when user puts value in the input fields it need to check if it is according to the core data (value is on same row) If not is the same, it needs to show message box stating, value is not the same. then user can proceed to change value or keep different value and it has to do for all the values check scr...
All details are attached file. Bid only if you can complete the task today. You need to use only formula not VBA. Fixed price: £20
In a project we have several parallax entities based on jarallax. We want to implement a progressive image load. In the attached .zip you find the example code. At the html doc you see a fullscreen image in the parallax function. the progressive image load is applied but doesnt work. further down in the document you see to another images outside of the jarallax environment. they work. please fix t...
i have 143 excel files. i need the 3rd sheet of each file, combined together into 1 big file. all the files have the same number of columns and same type of data. So i want the data added one after another into the new bigger file. each file has about 20 columns of data and about 200 rows. each file has a header row also, which i dont need into the
I just need a simple Google Sheets script to copy the entire last row and paste it down one row below. This script will be run once a day to keep copying down the last row for each new date. I can get this scrip to work in Excel but not Google Sheets:
Create a VBA sub program that creates a game for multiple players and finally declares the winner. The detailed procedures to create the game are given below: • Create a spreadsheet and place the buttons as shown below in the picture. • When the button “play” is clicked, the program should ask for the number of players and the number of cards. • After