What have you been working on? (Week of July 19, 2019)

I just finished an internship at a manufacturing company. During that internship I started practicing VBA. I helped multiple colleagues to automate some manual tedious tasks. For example one task was: Opening a macro enabled workbook; edit some values based on a condition; running a macro from that workbook; Copying a specific range of cells and pasting into a MasterWorkbook (this has to be done for around 16 workbooks). After that creating a table of that copied values; entering some formulas into new columns; creating a pivot table of that data; inserting slicers and doing some formatting so it looks good and easier to read.

People who are really good using hot keys can do this task pretty quick without a macro, however, I think opening and closing a macro enabled file and repeating some minor tasks for so many workbooks can get really annoying and you might do some mistakes during the operation.

While creating this macro I learned certain things, for example:

-Having the .Open method early in the subroutine will shut down your macro when using a Alt+Shit+* hot key for running that macro -I used the .Select method waaaaay to often which made my macro run very slow -WiseOwl is the best VBA Tutorial out there -VBA recorder is VERY helpful

/r/vba Thread