The following are data spreadsheets. They are examples of macros and templates built by ExcelHelp. Feel free to download them and see how they operate. (Note: you must download and save the file to your local drive, then reopen in your Excel for the macros to work).
If you have any questions or would like any data spreadsheets tailored for your needs, please email: ExcelHelp.firstname.lastname@example.org
This macro was requested to remove rows that exceeded 3 months old from todays date, whilst transferring the deleted items to a new sheet.
Currently in development. This is a file which records the ball hit at a driving range. It records whether it was a good, average or bad shot. It then accumulates all the shots at the driving range and provides statistics for the shots hit at the driving range.
Currently in development. A simple appointment tracker, showing past, today and future appointments, hours per clients and cost per client.
Still in a development phase, however the above reports enable corporate finance reporting users to be able to compare month vs month, ytd v ytd by actuals and budget and/or forecast. The templates shows that by using the offset formula you can keep the sheets clean and simple.
This template contains a macro to aid with reporting.
Please download and save the file and enable macros first before running the report.
The template, allows you to enter you own company name, and to enter daily stock or transaction amounts. Future versions will allow you to change the standard naming of the report columns.
This report is built to show student monthly quantity of lunch and drink consumption. The report automates the use of pivot table, and contains a validation list for the months.
This report contains an excel macro.
This report uses the list validation functionality in excel. It help keeps the data consistent by limiting what the user can enter. It also allows dependencies to occur without interrupting, as the data input is always consistent.
This template does not contain an Excel Macro, and is purely formulae driven.
This template establishes the setting up of periods for either a calendar starting financial year, or a July starting financial year. Once the period numbering has been established, vlookup or offset tables can be used to compare month to month variances.
The accounting template uses a macro that re numbers the months for each period, it also contains the list validation data check.
This report was developed to automate the splitting of columns. The invoice number has been split, and the prefix and suffix has been removed.
The report uses data and working sheet.
Report manipulation (SAP)
This report was created because SAP could not summarise GL accounts. The raw data of SAP could be obtained in the form of an excel dump. From which this excel report, then manipulates the SAP raw data into a useable form for the user.
The macro saves the user time, whom would otherwise need to spend over several hours in remove blanks rows, columns, moving headings around etc.
The Student Report shows which objectives each student is meeting or participating in.
The inventory report shows the total quantity of stock required to be purchased for each part or inventory id. The inventory id total quantity is determined by a pivot table and also with the use of a sum if formula.
The above report demonstrate a Vlookup function, and also in the Insert Discount macro, it uses the select case. The select case, helps with applying conditions based on a range, rather than using many IF statements.