reduce calculation time

  1. W

    Running VBA Code on two worksheets simultaneously

    Hi All, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I wanted to know if it is possible to run a VBA simultaneously on two worksheets (in order to increase speed and reduce coding) <o:p></o:p> <o:p></o:p> For example, I want the following...
  2. F

    how to reduce sheet calculation time period

    Dear Sir, Can anyone help in reducing calculation of the sheet. i have following formulas with quantities 270 times ---------> =SUMPRODUCT(('raw data'!I4:I4116=$B3(('raw data'!I4:I4116=MONTH(N$2)&YEAR(N$2))*'raw data'!R4:R4116) 9 times ----------> =DSUM('raw data'!J3:T4117,'raw...

Some videos you may like

This Week's Hot Topics