Hello Team
The INTRA FILE Attached has a Macro Already,
What it does is
We will take One script EX :
1) For Script ABIRLANUVO In B COl The data for C,D,E Comes from An other page As these Data comes F-O COL The formulas are there which calculates and displays,
Now we have done macro for which this work is taken care but the DRAW back the process is very SLOW and hangs as the data in this page is huge,The processing itself takes abt 5 min.
The data in this sheet is saved every 15 min one below the other.
As the data is arrived in B-E COL we need to generate formulas automatically in F-O Col.
And vice versa for the other scripts also an other ex as the data comes To P-S Col one below the other The formulas in T-AC has to be automatically caluculatd in macros.
We have it in formulas as it is becoming heavy we converted to macros.
The code for calculation in macros is correct,
Only we need to process more fast in macro.
Can you please help me to fix this issue.
Regards
Naren
The INTRA FILE Attached has a Macro Already,
What it does is
We will take One script EX :
1) For Script ABIRLANUVO In B COl The data for C,D,E Comes from An other page As these Data comes F-O COL The formulas are there which calculates and displays,
Now we have done macro for which this work is taken care but the DRAW back the process is very SLOW and hangs as the data in this page is huge,The processing itself takes abt 5 min.
The data in this sheet is saved every 15 min one below the other.
As the data is arrived in B-E COL we need to generate formulas automatically in F-O Col.
And vice versa for the other scripts also an other ex as the data comes To P-S Col one below the other The formulas in T-AC has to be automatically caluculatd in macros.
We have it in formulas as it is becoming heavy we converted to macros.
The code for calculation in macros is correct,
Only we need to process more fast in macro.
Can you please help me to fix this issue.
Regards
Naren