Hello,

I'm having single column real number input data from a device that's gathering measurements of a XY plate. Trying to transfer data from the column to a table in a separate sheet of the same workbook.

No. Group Value
1 A 0,2
2 B 0,5
3 C 0,9
4 D 1,2
5 E 1,9
6 A 1,4
7 B 1,7
8 C 0,2
...
*No, Group and Value coming in at separate columns

Using the letter A as a reference point for the start of a new row/column of measurements on the plate. "A" should indicate the start of a new row/column measurement on the XY plate. Therefore, the data should be transferred to the next column of the table (no transpose needed). Always odd number of columns transferred (1,3,5,7) to the table and every time it needs to be centered inside the table which is always fixed number of rows and columns (21 x 15). So, for example, the single column input data should be split depending on reference "A" and transferred to the center 5 columns of the table.

Making a UserForm in the input data sheet where you can indicate how many columns will be transferred/used (based on the type of measurement of the XY plate. Also, making sure the table is cleared (or set to zero) for the next measurement.

I hope i made my question clear since I'm not allowed to attach the Excel table that I'm using.

I highly appreciate any tweaks and suggestions for the code (macro and VBA).


Cheers,

Prokis