I need a macro written that will remove certain character strings from a row and add them to a new a tab without the strings + remove duplicate values. Here is an example: Striped Jeweled Hoodie XS Striped Jeweled Hoodie S Striped Jeweled Hoodie S/M Striped Jeweled Hoodie M Striped Jeweled Hoodie M/L Striped Jeweled Hoodie L Remove the "S/M"
I need a Macro in order to fetch the data within the sheets of attached file and give the output in other sheets within the same Excel file. Attached please find the Excel file which contains all the sheets. The data from the following sheets needs to be searched EN US Orders BOL Orders ELNINO Orders within the following sheets BOL Lis...
Hi: We have a ...where each record includes a complete html text page. We need Python 3 code that will get each record, parse the required fields, and enter into into another table in a postgresql database. (To be clear: no webscraping needed - we already have the data.) We will provide many samples of the .html and what fields we want to extract.
Looking for an experienced Python developer who can create code to: - authenticate, retrieve and process JSON data (account details) - using Python code - using the API provided by the bank ([url removed, login to view]) - Fields required: name, balance
I need a macro to automatically copy formulas based on the first row and paste it to rest of cells. Please find the two files. I have 40 files like this. The whole files need to go from step 1 to last step in matter of seconds.
Please look into the sample files. In every step it is just the data of the previous sheet and the same has been copied to rest of cells every time. I need a macro to go from step 1 to last step within seconds. I have 40 files like these.
I run a macro to send an email on a daily routine set in Windows Task Manager. I use Macro Recorder to build my macros ([url removed, login to view]). The macro imports into the clipboard the list of receipients from a .txt file. This allows me to update the list without having to play around with the macro coding. The script that does the
Objective: We are looking to get an Excel Macro built that will take our shopify export file and clean the data up where we can work with the data into other product catalogs. Scope of Work: We need this to be coded in VBA for Excel 2016 and when we open the workbook it will do the following: 1. Browse for the CSV or workbook to transform 2. Run
I would like to be able to process images of Restaurant menus and pull out structured data that will be used in a database. I understand the system will need to use OCR technology and this may be done using cloud services like Google, AWS or Microsoft etc. Each menu is often very different but I would like this to work for as many menus as possible
Need an excel macro to get prices from website into excel
Financial/Business analyst ,Excel Macro expert needed for some task .
Hi freelancers, in the attached file I want a VBA code to do the following: Check all cells from W37 to the "last row" in the sheet. If any cell in that range contain date less than 1-1-2018 , the next two cells in the same row must be protected. For example cell W40 in the attachment has the date 22-Sep-2017, then cells Y40 and AA40 must has the format
...categories and locations that I specify. The XML feed needs to be simple to use and basic, I'm not after anything complicated yet. This is not an RSS feed, it's an XML file from an external http:// source My requirement is to be able to: 1. Bring this XML feed into a (PHP/WordPress) website 2. Limit the number of jobs in the feed and paginate