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 List EN US
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
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 protection locked. Cell W38 has ...
I would like the highest and lowest rating in column R found and the the whole corresponding row copied to a blank sheet. This needs to be done for all sheets in th...rating in column R found and the the whole corresponding row copied to a blank sheet. This needs to be done for all sheets in the workbook. Please check screenshot for more information.
...source code of the link. (i.e. 2018-02-14 630-S-Pacific-Ave-San-Pedro-CA I am open to using any RPA Software package (i.e. UiPath Studio) for Windows 10, or scripting a Macro in Microsoft Outlook, whatever will get the job done. Many Thanks....