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: 16/11/2019 02:38
Publication number: ELQ-10164-7
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.
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 here: https://www.eloquens.com/tool/5MLkUQNE/finance/excel-vba-tutorials/vba-automation-of-movement-computation-multiple-periods-complete. If you have already paid for the basic version, just reach out and I'll provide you with a coupon to only pay the difference with the complete version.

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)

Acquire business license for $5.00

Add to cart

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

  • Rate this Downloadable Tool

    Write a review

  • Mera Estate(last updated: 18/09/2019 03:13)
  • Suresh Arigela(last updated: 07/09/2019 15:07)

keyboard_arrow_leftkeyboard_arrow_right

More Best Practices from Pierre-Alexandre HEURTEBIZE

keyboard_arrow_leftkeyboard_arrow_right

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

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


5.0 / 5 (2 votes)

please wait...