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...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 convenie...
...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
...WooCommerce API. [iniciar sesión para ver 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 images for these products. 2. Update Quantities on existing items in Woocommerce
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.
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
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.
...over 25 years and use a custom built excel spreadsheet to calculate initial and ongoing product costs and to assist with the setting of 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
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
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 co...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
Hi Chandrasekhar G., 2 years ago you did some excel VBA work for me. I have a new workbook that I need almost the same functionality on. I can even provide you the old workbook to work from. Interested?
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 se...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 provided API data from my 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
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
I need to read data from a web page that provides API. You are required to create a VB code on excel that reads data from this web page. You are required to help in telling what data can be pulled from the web page.
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. [iniciar sesión para ver URL] Thanks & Regards
I have an already built VBA macro using UserForm. I need to do some cosmetic changes. I need the count of records in the Supply section and it needs to be a link, once clilcked, should display the same in an already existing listbox.
We need a VBA developer that is experienced with Excel, VBA, and Jira. Need an Excel macro to connect to Jira query for Epics, stories, linked test cases, bugs found during testing. I have all of the JQL needed to find the issues in Jira.
I have a project that aims to fine-tune some existing Excel VBA Macro details (4 of them) and, more importantly, implement several new Powerpoint formats (project roadmaps, dashboards) based on data in an Excel source file. Attached is the complete Statement of Work and would appreciate if you could go through it before committing. Obviously the document
hello, i need some help and training on vba / excel. basically i have multiple input files from "source A" and one output workbook from "source b" i need to check that the input files match the output workbook that has 15 worksheets. there are 280 input files that are in csv format and there is one output excel workbook that is created with 15 worksheets
...help and training on vba / excel basically i have multiple input files from "source A" and one output workbook from "source b" i need to check that the input files match the output workbook there are 280 input files that are in csv format and there is one output excel workbook that is created i need to check all csv file data with correct col...
I am after a bit of VBA for excel written up that will: On click of a button: - Refresh the following data sheets: ------Project Actuals ------Project Budgets ------Project Forecasts ------PPO List ------Benefits List ------ICT PMO List (These worksheets will remain hidden in the final version. They pull from an internal SharePoint server, so it will