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.
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
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. [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.
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
...time the rates will change, but the rate analysis methods wont. The rate analysis sheet need to be updated when i will change the rates in rate chart sheet. I think using VBA script the equal to formulas can be inserted in right cells. I need all the appropriate cells to be updated. A single miss can give wrong result. I will not make any payment if
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 be executed up to the last entry in the fir...
I have two workbooks, each with multiple worksheets. I need the information from one worksheet (as it is inpu...workbooks, each 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.
I need a script to launch an Excel Macro every X seconds within a specific workbook. Please don't bid if: You are not sure how to handle the constraints listed below, You don't explain the basics of how you intend to build the script in your offer. The script must ensure that the following constraints are met: -Excel must be usable between each
...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
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
Looking at creating and automated excel file with VBA and macros for a certain task which would ultimately be automated, save to PDF and .Doc and also enter into another database which will be automatically formed. More details to follow
We want to use a program or a VBA Excel file to search all prices on the football market live from the Betfair Exchange and store the price on specific markets at a time relative to Kick Off or Half Time and also be able to know if one or a couple of conditions is met, such as a certian score, the result at half time or if a goal is scored. The program
Within FactoryTalk View SE 8.1, set code in VBA of a display with a trend object, to make buttons on the display call (or link) to HMI tags to CHANGE OR ADD PENS at runtime. Possibly using parameter files. And without using trend templates. You must know and have FactoryTalk View SE. Convince me that you do, please. approx a 4 hour job.
Hi there, we need a VBA or a Macro to get specific datas from a form into excel sheets. The form is looking like the one in the first picture. We get the form for 6 different locations (nr. 1), so the data need to filled in 6 different sheets. We are working with Outlook.
We receive purchase orders in various formats (pdf and xps) via email. We then convert (manually) them into 2 separate files namely: 'PO Master' and 'Dispatch Detail' - the format with sample data is attached. I need both types of purchase orders received to be converted into these two excel formats.
I'm building a subscription website and want to upload (I currently copy and paste) csv spreadsheets to Google Sheets. The spreadsheets currently are created by vba scripts and I prefer to keep everything in vga.
I would like to import the prov...Binance account into an Excel sheet. For example I want to import the current data from BTC/ETH (Datas from 4h ago to current time every 5min. datas) Additionally, I need the VBA codes to set and terminate the different orders (Limit Order / Market Order / Stop Limit Order) Theoretical , the codes would suffice for me
I am migrating a large excel application to Caspio . There are some forms and reports that contain vba and powerquery operations. These forms and reports need to be customized in Caspio. I need a freelancer with extensive knowledge of Caspio software. Serious bidders only. Thanks
Hi, Need to create the Excel VBA Macro (Web scraper) to pull the information from the below url in the attached excel format. Also need to pull the images if there are any in the subsequent pages. [login to view URL] Thanks & Regards