You are reading a single comment by @Chalfie and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
@Chalfie
I'd been thinking that I could move it.
wait, so I could:
autofilter for one thing, paste to a new sheet, delete the original sheet. (this is the delete everything but the array step)
then
loop through creating new sheets by autofilter? (apply filter for the other thing, paste data to new sheet)
then apply the save separate worksheets loop.
Would that be quicker?
I mean, i'm going to use the one i've got on a regularly sized data set (approx 100 records max) so i'd expect it to be done < 40 seconds.