Hello ,
I am new in using macro ,i would like to ask about how can i create table depends on number of rows and columns that included field names ,do we have method that it counts number of rows and create table depend on it .
because my data in excel sheet will not have the same range and it is different from file to another but it has no tables ,i want to write a code that implement on the whole excel sheet for each sheet in this excel each excel has around 3 sheets with different size of table and design table for each rows has field names .
i found many articles but all of them i have to select the range and so on but in my case ,i hany excel files and each one has different in rows in the table so i want the program to do it automatic .
Eacch table contains data under each other ,but i do not know how many rows will be in the table so i want from macro to do it automatic to calculate the number of rows and do the table as picture
I am new in using macro ,i would like to ask about how can i create table depends on number of rows and columns that included field names ,do we have method that it counts number of rows and create table depend on it .
because my data in excel sheet will not have the same range and it is different from file to another but it has no tables ,i want to write a code that implement on the whole excel sheet for each sheet in this excel each excel has around 3 sheets with different size of table and design table for each rows has field names .
i found many articles but all of them i have to select the range and so on but in my case ,i hany excel files and each one has different in rows in the table so i want the program to do it automatic .
Eacch table contains data under each other ,but i do not know how many rows will be in the table so i want from macro to do it automatic to calculate the number of rows and do the table as picture
