Hello,
I am very new to macros and VBA but trying to improve. Each time I conduct an experiment a raw database is automatically generated. In the raw database each data set is arranged in 1 column with 96 rows (there are multiple columns of 96 on each raw data base). I need to transfer this data to another workbook which is my Final data base and on the final database I would like the data to be formatted in 8x12 grids (one for each column of 96). The way this is currently being done is very slow and error prone so I am trying to automate it.
For each RAW data workbook that is generated I would like to use a template of the final data workbook so that I can create 1 final data workbook which includes 8x12 grids for each column of 96 on the raw data sheet.
I initially used this formula "INDEX(A1:A96, TRANSPOSE(SEQUENCE(12,8)))" using excel 365 and that worked, but realised that the PC that I need to use the databases on has Excel 2019 which does not have the SEQUENCE function.
I am very new to macros and VBA but I was hoping someone could help me write a VBA code to create a function or a command button to do what I would like to do. (Hope it all makes sense - see attachments also)
Thank you in advance