Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Bill Howell   on Nov 01 In MS Office Category.

  
Question Answered By: Zack Thompson   on Nov 01

I was able to get what I needed by using the function you gave me. I
was really wondering if there was a way to use a vba  code to do it.
Unfortunately, every time I open the workbook, it freezes, I guess
because it is doing too much work, accessing 5 other workbooks, and
returning the information for 2000 records.

This workbook  is going to get larger so if there is no code  to use
then maybe I'll just have to have 18 workbooks, 5 original, 12 -one
for each month-and one for the result formulas. This seems like way
too much work.

If you have any suggestions, I'd appreciate anything you could give
me.

Share: 

 

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

 
Didn't find what you were looking for? Find more on IF VBA Code Or get search suggestion and latest updates.


Tagged: