Is there a way to generate nontabular VBA reports in excel. I looked in various places and can not find a way to do so. I can think of a way to extract the data within VBA and generate a report sheet, but it seems like it might be clumsy and slow.
This need is due to large spreadsheet that was developed for a user interface that does not use a tabular layout, but contains 40 similar blocks of data. The 40 data / calculated blocks are about 84 rows high by 9 columns wide and repeat horizontally from 1 to 40. Each block contains the exact cells, but the data changes the needs to be extracted and reported within a tabular report.