by Ilker | Apr 19, 2018 | Excel Macros, Excel Tips & Tricks
Although keeping the data on different sheets help organizing them in terms of look and feel, this approach may cause problems when you need to get data from all sources. VLOOKUP or INDEX functions can’t really help here, and other methods to combine data can be...
by Ilker | Apr 18, 2018 | Excel Macros, Excel Tips & Tricks
You’ve worked with text data before, used formulas, and created reports, but how do you up your game? Efficiently loop through text data using this simple VBA code to analyze or manipulate strings. Code Sub LoopThroughString() Dim counter As Integer Dim mystring...