streamline vba code

Hello everyone, First time poster to the board and fairly new to VBA macrosfor excel. Please bare with me on this post if it is confusing. I have managed to Frankenstein together code that allows fora worksheet to be created based off of a template sheet, followed by adding anadditional...

I'm at the end of chapter 2 of Jelen's book. VBA and macros: Microsoft excel 2010, where he lists several Tips. I'm confused by the first tip: "don't select anything." Having to do with streamlining Recorded macro code In the Excel interface you have to select something before you can format...

The following code does what I want for two rows but I have ten rows of data so I would like to streamline this down to one block of code that can do this work for all ten lines. Any help would be appreciated! <code> Sub Copyinfo1() Dim BottleDate As String BottleDate = Range("AB5").Value...

Hi, I have a database with worksheets for multiple companies and am trying to consolidate them into one masterlist, as well as run a couple other reports. I believe I have the reports working as intended but am experiencing very long processing times in running the masterlist generator. Does...

I am trying to categorize some Contracts data. I am in Afghanistan and working on Afghan contracts trackers. The data has been translated from Dari to English by non-native English speakers so there is a great deal of variability. All that being said I have built the following VBA macro, but am...