br1

I would like a macro to save my last sheet with the same name as the sheet for if sheet name is July 2019 to save as July 2019 followed by -BR1 Data This sheet to be saved will always be the last sheet tab Your assistance is most appreciated

Hello, This is just a simple VBA code I made to import data from three tabs, and bring it all into one tab where work can then be done on the combined data. This will normally run on data that runs about 18-30k rows per tab. I like the code, and feel that it is sufficient, but if anyone has...

I have a macro to delete the following items in Col Y I need to amend the section of the code to allow me to specify ore than one item in Col Y to delete the row If Range("Y" & i).Value = "BR1", "BR2" Then Kindly amend my code See full code below Sub Del_Unwanted() Dim LR As Long, i...

I have names in Col O in Sheet2 I need the header in (O1) as well as the name in Col O to be copied to Z1 on the applicable sheet for eg BR1 on Col O as well as the heading to be copied to Sheet BR1 Z1. it would be appreciated if someone could kindly provide me with code to do this...

I have code below which open a specific file in a directory. I could have several csv files with BR1 in the name, but want the latest file name containing BR1 I want me code amended so that it attaches the last file name specified in the code If objFSO.GetExtensionName(objMyFile) = "csv" And...