VBA - Automation of movement computation - Multiple periods - BASIC
  • VBA - Automation of movement computation - Multiple periods - BASIC
  • VBA - Automation of movement computation - Multiple periods - BASIC
  • VBA - Automation of movement computation - Multiple periods - BASIC
  • VBA - Automation of movement computation - Multiple periods - BASIC
Originally published: 30/08/2019 21:29
Last version published: 05/09/2019 22:00
Publication number: ELQ-10164-3
View all versions & Certificate
certified

VBA - Automation of movement computation - Multiple periods - BASIC

VBA Script for automatic movement between periods - BASIC

Description
This vba script will allow you to save time on a simple but time consuming task: building movements between periods in your excel sheet.
The script asks the user to select the range containing the figures for which he wants movements vs. previous period built.
Please note that this script is intended to work in the condition that columns containing the figures are all adjacents, and movements are calculated assuming older to newer period are aligned from left to right.
This tool is entirely free to download and to use. Please note that I also offer a more sophisticated version of this tool which will automatically take care of the formatting and also allow the user to add movements in %. If you are happy with the basic version, please feel free to support the time spent to develop this tool by downloading the complete version for a couple dollars only here: https://www.eloquens.com/tool/5MLkUQNE/finance/excel-vba-tutorials/vba-automation-of-movement-computation-multiple-periods-complete

This tool will result in a humongous gain in productivity for any consultant working regularly with financials and for which year on year / month on month movements are a key indicator to look at and to show.
Please have a look at the video I have recorded and attached to see how the tool works.

This Best Practice includes
1 VBA file, 1 Excel file (also including the VBA code)

Pierre-Alexandre HEURTEBIZE offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss

Further information

Gain in productivity by automating a low value added task

Have numbers in adjacents columns and sorted out from oldest to newest , left to right

Reviews


keyboard_arrow_leftkeyboard_arrow_right

More Best Practices from Pierre-Alexandre HEURTEBIZE

Any questions on VBA - Automation Of Movement Computation - Multiple Periods - BASIC?

The user community and author are here to help. Go ahead!

please wait...