Card MIS

[Kaiser]

Dear Respected Users,
Regards, I have expressed my views about this website and the respected Excel Experts to all my colleagues and friends. Recently, at my office I have faced to prepare an excel sheet where I have to show a calculation. All the details and the requirement has been given in the excel sheet that I have attached with red outlines and figures and how the output will be given in the Sheet 1? I have saved the name as Problem Question. Can any of my expert brothers guide me how I can solve the problem. Will be eagerly waiting for your advise and kind favor. Please save the file in different name as Problem Answer. Thanking you.
Kaiser

 

[NARAYANK991]

Hi ,

Please note that what you have posted is probably a problem as far as you are concerned ; as far as I can see it is a mini-project.

Whether members can spare the time to complete this mini-project is anyone's guess ; if you are in a hurry , it is very likely you will be disappointed.

If you are willing to wait , someone may be willing to take up the job and help you out.

Narayan

 

[Kaiser]

Hi ,

Dear Narayan brother,

I do apologies. You are right. Actually, I work in such a place where reporting is a mandatory task for me. Suddenly, the Management is asking to prepare such a spreadsheet which will produce day to day outcomes through our Card. We usually go through thousands & thousands of card transaction every day. It is too hard to keep the track as well. Now, the pressure they have created is also not allowing me some time to think, so I posted the project here to get some help from any of my expert brothers.

You are absolutely right brother, I should give some time. I do apologies to everyone and to you as well. Thanks a lot for replying. You take care..

Kaiser

 

[Istiyak]

This is brain stroming activity.. actually take time.

 

[Ilyas1979]

Dear Kaiser,

Please check the attached file.

Regards

 

[Kaiser]

Dear Kaiser,

Please check the attached file.

Regards

Dear Ilyas Brother,

Regards, I am so grateful to you for your kind favor. But brother I have a small question, if you kindly bear with me. I have seen some of the formula on different sheets, but little bit confused where and how to put. I know you are too busy my dear, but still if you can really take out some time to point me out. Or is there any way to put the codes or design a macro to run after clicking the Calculate Button on Sheet 1. Please do advise, take care bother and once again, I appreciate your valuable time and favor. '

Kaiser

 

[Ilyas1979]

Dear Kaiser,

Sorry

Dear Ilyas Brother,

Regards, I am so grateful to you for your kind favor. But brother I have a small question, if you kindly bear with me. I have seen some of the formula on different sheets, but little bit confused where and how to put. I know you are too busy my dear, but still if you can really take out some time to point me out. Or is there any way to put the codes or design a macro to run after clicking the Calculate Button on Sheet 1. Please do advise, take care bother and once again, I appreciate your valuable time and favor. '

Kaiser

Dear Kaiser,

Sorry for creating the confusion. Please check the attached file. It displays the country result on a single sheet. You just have to select the country from the dropdown list.
Regards,
Ilyas