This script is designed for importing and manipulating .csv files from Ramp. It categorizes the data into separate subtotals. The script also includes functionality to automatically update pivot tables whenever changes are made to the data source.
Feel free to make any changes that suit your needs
- Ensure that the Excel workbook containing the VBA script is enabled for macros.
- Update the worksheet names in the script as needed to match the specific worksheet names in your Excel workbook.
- I have left worksheet names as empty strings; "" - please amend as needed.
- Customize the criteria for categorizing the data into subtotals according to your needs.
- Consider creating buttons in your Excel workbook to run the relevant procedures.