Dear MrExcel community.
Over the last year I have needed to collect and process more and more data which is coming my way from an online survey distributed to colleagues. The output of this survey is generating an array of data which is 40 column x 300 row (thereabouts). I am currently performing a custom sort to alphabetize a name variable before selecting 4 rows specific to a chosen name. I past this data into a new sheet before in turn populating a template on a 3rd sheet through a series 1-2-1 cut/paste operations. This template in turn has a telescoped PDF save operation. The fact that there is a (likely) redundant 2nd sheet and lots of individual cut&pastes is a reflection on my lack of knowledge and experience and having cobbled this together via macro recordings and some found code.
The essence of my query is how I can loop the initial array selection so I can loop and ultimately generate all PDF reports at one point in time, a time which is most suitable for the reporting to colleagues rather than piecemeal.
Essentially, I would like to select Range("A2:W5") from sheet1 and input that into the described cascade of cut/paste and PDF saves over sheets 2 and 3, before moving onto Range("A6:W9") until running out of 4 row ranges.
I thought I would be able to find/adapt something....but no....getting very frustrated by what must be simple .
I'm happy to share what code I have, but as it is clunky and runs to pages because of all the cut/pastes I thought I would leave off in the short term.
Many thanks in advance,
Dr_drc
Over the last year I have needed to collect and process more and more data which is coming my way from an online survey distributed to colleagues. The output of this survey is generating an array of data which is 40 column x 300 row (thereabouts). I am currently performing a custom sort to alphabetize a name variable before selecting 4 rows specific to a chosen name. I past this data into a new sheet before in turn populating a template on a 3rd sheet through a series 1-2-1 cut/paste operations. This template in turn has a telescoped PDF save operation. The fact that there is a (likely) redundant 2nd sheet and lots of individual cut&pastes is a reflection on my lack of knowledge and experience and having cobbled this together via macro recordings and some found code.
The essence of my query is how I can loop the initial array selection so I can loop and ultimately generate all PDF reports at one point in time, a time which is most suitable for the reporting to colleagues rather than piecemeal.
Essentially, I would like to select Range("A2:W5") from sheet1 and input that into the described cascade of cut/paste and PDF saves over sheets 2 and 3, before moving onto Range("A6:W9") until running out of 4 row ranges.
I thought I would be able to find/adapt something....but no....getting very frustrated by what must be simple .
I'm happy to share what code I have, but as it is clunky and runs to pages because of all the cut/pastes I thought I would leave off in the short term.
Many thanks in advance,
Dr_drc