e the time significantly.
> Regards - Dave.
>
> --
> Date: Sun, 24 Apr 2011 09:03:05 +0530
> Subject: Re: $$Excel-Macros$$ Help me in this
> From: yashr...@gmail.com
> To: excel-macros@googlegroups.com
>
> Thanks Dave, for your suggestion. but problem is that i wa
formula: eg:
=COUNTIFS(DB_Sheet!$D1:$D30,$A16,DB_Sheet!$E1:$E30,K$2,DB_Sheet!$B1:$B30,$A$74)
This MAY reduce the time significantly.
Regards - Dave.
Date: Sun, 24 Apr 2011 09:03:05 +0530
Subject: Re: $$Excel-Macros$$ Help me in this
From: yashr...@gmail.com
To: excel-macros
Thanks Dave, for your suggestion. but problem is that i want to update all
sheets on daily basis. If i'll do this, it also be take same time. If you
have any other idea please share with me. I am also working on it if i will
get any solution then i will tell you.
Thanks & Regards
Yogesh Gohil
On
Hi Yogesh,
At first glance, I'd say that you just have too many formulas in the workbook,
and that most of the calculations should probably be done by VBA rather than
worksheet functions. There appear to be some UDF's, but the VBA is protected,
so I can't examine them, or make any decision on h
