...sheet the links have hyperlinks automatic. I can remove then in Excel easily, but as soon as I paste them they become hyperlinks. How do I stop that in just the 1 column from happening? Also I need 2 blank rows every 5 rows. need to work on this now, anyone available? Can be done in Excel or google sheet, I just ideally would like to have it in Google
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.
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.
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.
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
Hey! I need a formular in Row J: IF Row B = (is found in) Sheet "Kosten" Row B AND IF Row F = (is found in) Sheet "Kosten" Row G THEN SHOW Price of Sheet "Kosten" Row R File is attached. I think it's very easy for you. Who can help?
...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 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.
I want to demonstrate SQL data in a table. Picture 1 SQL query result. Picture 2 HTML table. I want to create a query which is...SQL data in a table. Picture 1 SQL query result. Picture 2 HTML table. I want to create a query which is result will be like HTML table. I mean I want to show Year column as a row and subjects as a group. I just need a query
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.
On this website: [login to view URL] I use Content Egg plugin to show the following products through a shortcode. I'd like to add a new row (with CSS and HTML) above this shortcode (with image, title, price and buttom) to show a new product that I'll add manually when I edit this post in Wordpress. This product should
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
I'm working on a SSIS package, need help to...simple for SSIS developer. We can finish it quickly where going over it together online (Webex). The package needs to: get a table object variable, use foreach loop to process each row, each row has components of a custom sql, run the custom sql and store end result into a SQL table. need to start asap.
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 have two excel matrix. 1 imported from PDF , huge amount of data in one column only. 2nd is the matrix csv i have to finalize in order to have all the information into the same column. Huge data entry work, but simple, no need to know any technical skills, only patience and have a great sense of order and data organization.