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
mething like:
>
> Activesheet.EnableCalculation = False
>
> This way, a worksheet is only updated when needed. It still may take too
> long, but it's simple to do, and worth a try.
> But I still think VBA could do each sheet in seconds, not hours.
>
> Regards - Dave.
ut I still think VBA could do each sheet in seconds, not hours.
Regards - Dave.
Date: Sat, 23 Apr 2011 09:07:55 +0530
Subject: $$Excel-Macros$$ Help me in this
From: yashr...@gmail.com
To: excel-macros@googlegroups.com
Hi Experts,
Actually, this waterfall made by me but its take 3hour to complete. Pl
Hi Experts,
Actually, this waterfall made by me but its take 3hour to complete. Please
help me out to make easy and time reducer format.
This format have Excel function and VBA coding.
*For the attachment you can click on* http://www.megaupload.com/?d=8KTIVGZX
Thanks & Regards
Yogesh Gohil
--
