VBA

Using Excel VBA with advanced filter At my workplace I often investigate a lot of different aspects of the data. One important moment is when I need to filter out and examine lots of different unique factors that corresponds to a specific event (I won’t go into detail regarding the actual real data due to secrecy in the workplace). I noticed that my colleagues used Excels table and filter function and simply copy and pasted the results into a new sheet with the filtered data.

Using Excel at the workplace At my current workplace I have been known as one of the “go to college” when it comes to tips and tricks in Excel but also more advance topics like new formulas or macros. One of my colleagues in another department asked over lunch if I knew something that could help him with updating names in a column in Excel. The problem was that another program outside of Excel automatically updates the names but just once a day, and new data can be imported with several thousand rows hours before which therefore have no name for a long time.