Macro

Learn Excel – “Use Solver with VBA”: Podcast #1830

               

Haizen has to arrange transport for ‘N’ employees where ‘N’ can be 1 to 500. There are three types of vehicles available with different capacity and different cost. He wants a Formula for Back

Learn Excel – “Make Ctrl+V be Paste Special”: Podcast #1828

               

Seckin set up a Worksheet for his co-workers with great Conditional Formatting. Unfortunately, the co-worker uses Ctrl+V instead of Paste Special Values, Back

Learn Excel – “Show AutoFilter Selected Items”: Podcast #1827

               

Mark G has an AutoFilter outside the print range and wants to show what is selected in the AutoFilter inside the print range. Excel 2013 Table Slicers could do this, but Back

Learn Excel – “Create an Invoice Register”: Podcast #1808

               

This follow-up video – Episode #1808 – to previous Episode #1505 shows how to automatically create Back

Learn Excel – “Hide Blank Rows” – Podcast #1738

               

Preserve ‘Undo’, Show All and Hide Blanks: “Go!”

Learn Excel from MrExcel