Hello All VBA Experts
I got table (as per attached doc.) and I would need a code which will automatically create a new table next to existing one (2 columns after existing table) with the same table headers and consecutive numbers when last row (whichever cell) from previous (current) table is not blank.
in other words - looking at my spreadsheet I would need a code which will create a new table with consecutive numbers in rage G1:J31 when any last row cells (range B31:D31) in table from range A1:D31 is not blank. And then repeat the same operation when second/third/etc. table meet the same criteria
please refer to spreadsheet for better understanding of my request:
when any of last row cells in table (range A1:D:31 excluding first column of the table) is not blank create new table next in range G1:J31 with consecutive numbers in first columns where first number will be next number after last number from previous table (so in this case 30) and then when this table is completed (last row cell is not blank) create another table in range M1:P31, etc....
is that even possible .......?
Please note I'm not familiar with VBA at all
thank you for your help
Bookmarks