Nontabular VBA Report


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.



1 Reply


With your permission, I may recommend...VBA isn't very helpful in this sort of thing...would recommend Power Query instead :).

About Power Query in Excel




I know I don't know anything (Socrates)