Worked great for me, altho had a small problem I am still working on. The data I want to use starts in cell C1 of the excel table (and everything to right), so when I change the set of the row/col count variable to use "C1" (where you have A1), it still started with C1. I think I need to find the numerical offset of what C1 is for the setting of the i variable?? Thx again! very helpful and got me started.
Thank you for the easy to follow tuition. Is it possible for the source data to start a cell other than "A1" and then the range start from there? Thanks again.
This is very useful, thank you! I have a question, what if the columns in each row of the table could be different, some row contains merged cell? Would like to know some contents on this 😊
hi sir. how about creating tables based on the column value. meaning it would create a different table each time the macro see a value on a specific column example. Column A is for Test Case#, so for row 1 its test case 1, the next rows are the steps where it the column A is blank, then once the macro sees a value for Column A like Test Case 2, it would create another table on the next page of the word. HELP ME PLSS