I am using the current CntIF3D VBA code in my excel program and it works really well.
http://www.mrexcel.com/forum/showthread.php?t=36082
The issue is that I have a huge amount of sheeets.
=IF(CntIf3D($A$1:$G$43,A1,"J3","J4","J5","J6","J7","J8","J9","J10","J11","J12","J13","J14","J15","J16","J17","J18","K1","K2","K3","K4","K5","K6","K7","K8","K9","K10")=1,"",ROW())
What I would like to do is rewrite this code so I don't have to refernce every sheet like this. Just from one list I have 422 Cells that can be used on any one of these sheets.
Thanks for any directions..
http://www.mrexcel.com/forum/showthread.php?t=36082
The issue is that I have a huge amount of sheeets.
=IF(CntIf3D($A$1:$G$43,A1,"J3","J4","J5","J6","J7","J8","J9","J10","J11","J12","J13","J14","J15","J16","J17","J18","K1","K2","K3","K4","K5","K6","K7","K8","K9","K10")=1,"",ROW())
What I would like to do is rewrite this code so I don't have to refernce every sheet like this. Just from one list I have 422 Cells that can be used on any one of these sheets.
Thanks for any directions..