PDA

View Full Version : If statement to run a module



lostboyca
08-31-2008, 10:46 PM
I would like to have a calculation of the following. I want a cell in the Statistics tab to calculate the following B35. If any cells in I6 to I12, J6 to J12, K6 to K12, L6 to L12 then copy all the information from Cell O6 to O12.

For example 01_Interface tab I6, I8, J6, J8, J12, K6, K8, L6, L8, L12 has the text ?FAIL? then on Statistics tab B35 should have the following text 1-VGY29, 1-5Y9UN, 1-VGY29

01_Interface tab I6, I8, J6, J8, J12, K6, K8, L6, L8, L12 has the text ?BLOCK? then on Statistics tab B35 should have the following text 1-5K3AA, 1-5K3BB, 1-VGY29

If the Cell O has nothing do not copy. Keep in mind I will be adding more Tabs to this workbook so would like the code to be as simple as possible to use with multiple tabs without change much of the macro.

Thanks in advance.