You can save them in your personal workbook (google 'save macro in excel personal workbook') to make them available at any time. Other good, useful subroutines are to perform any repetitive task you do regularly. He doesn't have to ask me to update it every time he wants to look. And PowerQuery will only get more powerful with time, while VBA isn't going to change.Īt work I link PQ directly to our database to pull production data so we can track failure rates and process variables - I can put together a file, send it to my boss, and he can just hit 'refresh' whenever he wants new data. Though like /u/cbr_123 suggests - PowerQuery can usually do that unless there are some really messy rules about how to combine dissimilar files.

For a neat mini-project that's not very practical (it really slows down the workbook): use the Worksheet_Change event to highlight (change fill color of) whatever row you select a cell in.Ī slightly bigger and much more common project, is to use VBA to merge data from a bunch of CSV or XLSX files into a single XLSX.

Visual basic for excel reddit