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
New software is to be developed that would replace Excel file with macros. Knowledge of Excel VBA macro language is necessary to be able to study current implementation. There will be more phases for this project, so we are searching for developer that can develop and support this software in long-term. This is description of Phase 1. In this phase
...see the word document attached. An SMS to me will prompt me to email you any explanations you may need, as I am not always at my computer. [Removed by Freelancer.com Admin - please see Section 13 of our Terms and Conditions] I hope you can Help me. QUESTIONS 1. The Database and Main Menu Form: On opening the Database, you must have a Macro which runs
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 the
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