Search results

Hi When I use my macros from my personal macro workbook they do not work, but if I use them in a workbook they work fine. Is there something else that has to be done in order to make them work in the personal macro workbook?

Hi I have a macro that will import data from another file into the opened workbook. The only problem is a have to include the path too the file. Is there a way to create a prompt to ask me where the file to import is located. Here a sample of the macro Dim wb As Workbook Set wb =...

Hi I have a macro to opens a specific file and copies data to my open workbook Dim wb As Workbook Set wb = ThisWorkbook Workbooks.Open Filename:="WORKSTATION-48Excel Macro FilesPL_Import and Conversion_Template_DATA_1.xlsm" '<<<< Change File Name...

Hi I have a Macro that lets me delete an entire row based on the beginning letter of a specified cell. However, I just need to delete two specific cells in that row not the entire row. Dim LR As Long Application.ScreenUpdating = False For LR = Range("D" &...

Hi Im am looking for a way to delete a row that has a cell that begins with certain letters. I have searched the site and internet and could not find something that could meet my specific criteria. Example: CR21 2939.85 2997.98 90 Top CR25 3226.85 3130.46 270 Top E1 3964...

Hi I am looking for a macro that will export my data into two new workbooks based on the information in column E (primary or secondary). Here is a sample and I included a file https://www.dropbox.com/s/af6bvmoaluikb94/7064378F.xlsx C1 4642.5 1447.28 180...

Hi I would like to compare data in A1:B1 with the data in D1:E1 and ouput the difference in G1:H1. Here is a sample C1 C0603C101J5GACT C1 C0603C101J5GACT C10 C2012X7R1E105K C10 C2012X7R1E105K C100 C0603C104K3RAC C100 C0603C104K3RAC C101 C0603C102K5RACT C101...

Hi the formula works great when I manually use it , but I would like to use it in a macro where it sorts column B as well. This is part of the macro Dim F As Range 'Add Formula For Each F In Range("A1:A" & Range("A" & Rows.Count).End(xlUp).Row) F.Offset(, 3).FormulaArray = _...

Hi I am looking for a macro that will take my data, sort it (True or False) and then delete all the false results. I have supplied sample data and sample results https://www.dropbox.com/sh/67unlewr92vgm3z/XAGscYaB7G Thank You

Hi, I am trouble getting this array formula...

Hi I would like to only delete certain cells in a column that do not match a certain format. For example I have this data 706832-02 0 REFERENCE 706831-02 1 S706831-02 0 706830-02 0 REFERENCE C0603C102K5RACT 1 C46 C0603C104K3RAC 1 C31 C0805N101K201N 3 C19,32,33 0805N221K201NXT 1 C11...

Hi, I am looking for a macro that can convert information form this format: C110,C126,C128,C129 CAPN/U-0805 C119,C124,C125 G40X152K050 C12,C106 GRM188R71E474KA C120...

Hi, I am looking to get this information C3 C8-10 C19-20 C22 C41-42 C49 C58-59 C61-62 C76-77 C79 to look like this C3,C8,C9,C10,C19,C20,C22,C41,C42,C49,C58,C59,C61,C62,C76,C77,C79 I have multiple cells will similiar data, but with different letters Thank You

Hi, I would like to add a letter infront of several numbers in a cell. I would like to take this: C12,16,19,26,27,41,50,74,75 and turn it into C12,C16,C19,C26,C27,C41,C50,C74,C75 I have hundreds to do like that, so something automated would make it a lot easier. Thank You