Scan a table to create a new table.

[GiovanniP]

Hi All,
i am trying to create a script that writes 3 colums on 5 different table on another sheet.

Te first table has 3 rows:
the first is composed by a group of cells (from A1 to A32).
The value of this fgoup of cells is "Month,Year " (but i also tought i can just write. The second row is not really important. it starts with an empty cell (B1) and from B2 to B32 contains just the numbers from 1 to 31 in progress.
In the 3rd row i have:
In C1 a string (not important) from C2 to C32 i can have:
1) an empty cell
2) various sting/codes like M, P, N or M1, P1, N1 or CI

Now. From this table i have to build a pre- formatted spread sheet like the one attached.

Well... i dont know where to start. Can somebody give me a clue?

[Guido Geurs]

Dear,

I have downloaded your example but I don't understand your text: you are speaking of 3 ROWS from A1 to A32 ???

Te first table has 3 rows:
the first is composed by a group of cells (from A1 to A32).

Isn't possible to send also a sheet of the startpage and an example of the results you want to see (with transfered data) so I can understand where you want to have at the end ?

br,

[GiovanniP]

scan a table to create a new table.

Sure. Here it is

[Guido Geurs]

Dear,

I hope this is what you are looking for (see attachment).

Insert a new sheet and run the macro "create sheet".

br,