While you can manipulate Excel to a fair degree through the use of formulas alone, there are always going to be tasks that require you to move and sort data in ways that are limited through the use of this knowledge alone. In these situations, it will generally be much more efficient time-wise to just create a program that can automate the task you are attempting. If you like the sound of this but don’t know what steps to take to make it a reality, then Excel VBA: A Step-By-Step Tutorial For Beginners To Learn Excel VBA Programming From Scratch is the book you have been waiting for.
Download