VBA

Learn Excel – “Crazy Macro Recorder Shenanigans”: Podcast #1885

               

Does that really say, ‘Shenanigans’? Back

Dueling Excel – “Unmatched Debits & Credits”: Podcast #1872

               

In Duel #156 we have a list of debits and credits. For each amount, match it with the next matching negative amount. After doing all of the matches, Back

Dueling Excel – “Category and Settings in Same Cell”: Podcast #1867

               

Every once in a while, you run into ugly Data Sets and this one qualifies.  In ‘Dueling Excel’ Episode #154, we find that someone decided it would be brilliant to Back

Learn Excel – “eBay Gallery Concatenate Image Names”: Podcast #1865

               

Dale needs to upload listings to eBay. One of the tough fields is the Gallery field, where the names of several images need to be in a single Cell separated by Back

Dueling Excel – “List All Day Numbers In A Date Range”: Podcast #1864

               

Given a start date and an end date, how do we produce a list of all the Day Numbers? For example, between Feb 28 and March 5 Back

Learn Excel from MrExcel