Hey all,
I've been working on our headcount templates for our planning process and I'm trying to find a way to extract the data from all of the responses into a single worksheet that can then be imported into Access.
It's highly manual and did a simple macro but it didn't capture everything.
The sheets have a common header (A9:U9) that doesn't need to be extracted (I'm thinking the destination file will already have this populated in A1:U1)
Two data ranges that can be variable within each file (could possibly be distinguished by number in column "A" for first range and then next number in column "A" for second range?) and can be run on a single or multiple worksheets to the destination.
Can anyone help with a macro for this??
Thanks so much!
I've been working on our headcount templates for our planning process and I'm trying to find a way to extract the data from all of the responses into a single worksheet that can then be imported into Access.
It's highly manual and did a simple macro but it didn't capture everything.
The sheets have a common header (A9:U9) that doesn't need to be extracted (I'm thinking the destination file will already have this populated in A1:U1)
Two data ranges that can be variable within each file (could possibly be distinguished by number in column "A" for first range and then next number in column "A" for second range?) and can be run on a single or multiple worksheets to the destination.
Can anyone help with a macro for this??
Thanks so much!
