coach_veto
New Member
- Joined
- Jan 26, 2016
- Messages
- 15
Hi guys,
I have a blank template that contains many rows for data. Whenever someone fills out the template, there can be any different number of rows filled out.
I am trying to write a macro that, when clicked, will know which rows are filled out with data and which are not, taking only the populated rows and exporting that information into a new workbook.
The challenge I see is that there are 3 sections in my template, so the code would have to know where to start, go down the rows until it hits blank, then go to the second section and do the same.
A possible solution is maybe a function where the code finds the name of the section ("Section 1"), then does a loop down the rows until it hits a blank, then looks for the next name ("Section 2") so on and so forth.
All thoughts and suggestions are appreciated!
Thanks!
I have a blank template that contains many rows for data. Whenever someone fills out the template, there can be any different number of rows filled out.
I am trying to write a macro that, when clicked, will know which rows are filled out with data and which are not, taking only the populated rows and exporting that information into a new workbook.
The challenge I see is that there are 3 sections in my template, so the code would have to know where to start, go down the rows until it hits blank, then go to the second section and do the same.
A possible solution is maybe a function where the code finds the name of the section ("Section 1"), then does a loop down the rows until it hits a blank, then looks for the next name ("Section 2") so on and so forth.
All thoughts and suggestions are appreciated!
Thanks!
