To add a bit more color to what I’m trying to accomplish. This is what the structure of the data table looks like.
I’m trying to build a tool that allow for the dynamic removal of records 1-3. Or take A4:F8 and write it to a new table in the same sheet so there is a standardized format for use in other tools.
The challenge is every report has a different output in terms of the number of “Filters” but they are ALWAYS only in the first two fields. I also want various users to be able to use the tool as a bot with their own reports. So to this point I have accomplished the following:
- Allow user to select their report
- Get the sheet name (within the excel application scope) as they are different in some reports
- Using the System Read Range to define the data table and then assign counts to the number of rows (rowCount) and fields (colCount) in that data table.
- A sequence to find the last Column letter and store it for potential use (colLetter)