Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Wayne Crawford   on Jan 01 In MS Office Category.

  
Question Answered By: Madiha Malik   on Jan 01

After I sent the code,I thought about it some more and would've
changed a number of things - and I also had a d'oh moment when I
registered all of what you'd suggested in the first place: using
Excel's Sort on the pertinent data Copied and Pasted into another
sheet (I like it).

As to only grabbing only unanswered questions  in the first place: this
was perhaps a bit of 'do now, think later' on my part. I'm currently
dealing with spreadsheet 'datasets' of up to 20,000 rows, so it's
become a habit of mine to stick stuff in arrays. My thought process
was that one has to check if the question was answered at some point,
either before it's put into an array or after. If before, I think that
would mean that you'd have to move down the column cell by cell,
checking for whether it's been answered (True or False). This
'cell-by-cell' process is slow, compared to performing it when the
data is in an array (hence, 'stick it into an array'). For this
problem, of 100 or so questions, I'd be very much surprised if this
method is any slower than using an array.

I certainly have very limited experience in VBA programming, so if
there's a method to loading an array with only data meeting particular
criteria, not involving a programic inspection of each cell, I'd be
interested in what it is!

Share: 

 

This Question has 7 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on List in one sheet unanswered questions in checklist sheet Or get search suggestion and latest updates.


Tagged: