• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Macro Code to Refined

Techtrend

Member
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
 

Attachments

  • MARCH LIVE-NEW-1.xlsm
    701.9 KB · Views: 4
Data sheet is very heavy file.
This sheet is more then 25 MB unable to send in this attachment.

Can i have your Email ID to share the file,
In INTRA File the sheet runs still BHI COL

Kindly do let me know if you need more clarifications.
 
can i have your email id to share the file.

Can u only fix the macro only in intra sheet,
the data sheet works fine.

Will explain one Ex

In INtra sheet the data From B - E comes from Data sheet
The macro takes care of the formula from F- O Col.

The issues we have in macro is it runs slow and the sheet hangs.

Can u please fix this issue
 
@Techtrend
As I wrote...
Where is Your "DATA"-sheet (18. row in code)?
Have You tested that file WITHOUT "DATA"-sheet?
'Fix' without testing would be only guessing!
Have You tried
select case x
case 1
' do something
case 2
' do something
case else
' do something
end select
instead of
if a > 3 then
elseif
' do something
elseif
' do something
elseif
' do something
endif
 
Attached is the data file,
With this i can sent INTRA FILE as it is huge and i cant attach.

you can add this data sheet with the earlier file
 

Attachments

  • MARCH LIVE-NEW-1.xlsm
    108.4 KB · Views: 1
@Techtrend
1) You didn't answer to my question 'Have You tried...'.
2) Have You ever tried to use those files before send here?
2a) There are more 'sheet-to-need'!
2b) Maybe that 'DATA'-sheet should have 'correct date' too?
>> I did 'some' modifications (including TWO questions) and I cannot test!
 

Attachments

  • MARCH LIVE-NEW-1.xlsm
    737.1 KB · Views: 2
I am New to macros,
I did try with all the other sheets it works fine.
The only issue is works slow.

Can i have your email ID to share the complete file,
So that it will be clear on the work.

Also let me know the cost will have it transferred.
 
If nothing else information then almost 'mission impossible'!
Did You read my previous reply's 2nd line?
 
Back
Top