IF statements with a module

**lostboyca** · 08-27-2008, 11:44 PM

I am a Novice and I am trying to do a calculation of the following

Please Login or Register  to view this content.

I want the final calcuatlon would show as below and I would like the code to not list duplicate text as well. This calculation will be for multiple worksheets.

All Blocks= Apple, Grapes, Lemon
All Pass= Apple, Orange
All Fail= Lemon

Plus I have attach my excel for clarification as well its in MS excel 2007

Thanks in advance,

Lostboyca

**ravishankar** · 08-28-2008, 01:45 AM

Hi
attached is a file with macro.
Ravi

**lostboyca** · 08-28-2008, 02:47 AM

I do not want to have to click on a button I want it to show up automatically when the excel is launched. Plus this is a small peiece of a bigger picture is there a way where I can just put in the formula on a cell to trigger a module?

Maybe have some sort of formula for the cell that states like IF Sheet2 = Block then run a module that will trigger the block information...

**ravishankar** · 08-28-2008, 07:41 AM

Hi
The solution provided will be restricted to the information given in your message. Preferably give us a complete picture in the beginning so that we don't work on the same problem again and again. Try the macro in the file attached.
Ravi

**lostboyca** · 08-28-2008, 06:19 PM

hmmm... I don't want any popup box plus I think the code you have is to specifc for that excel.

I have attach the real file which i need the code to be in as well so you can see what I'm really trying to accomplish.

I want the calculation to retrieve from 01_Interface tab and so forth. The information will be combine to Statistics Tab A35, A36

I will be using the same excel layout to do other testcases as well so it needs to be simple enough that I do not have to change the module code for example I would like it to be simple enought to add two or three more tabs and triggering the code.

There are codes in that excel which I'm experimenting with as well to get my desired output

Thanks,