Lensmeister
Registered User.
- Local time
- Today, 23:10
- Joined
- Feb 18, 2009
- Messages
- 65
Hi all,
Hope someone can help me.
I am in need of assistance with the creation of VBA code thaat counts cells that have certain criteria.
The background (interior colour) is = 35 and the cell contents need to equal a named cell called filename.
In laymans terms if it were a formula would be roughly:
I have attached a copy of the xls to hopefully clarify things.
Thanks in advance.
Hope someone can help me.
I am in need of assistance with the creation of VBA code thaat counts cells that have certain criteria.
The background (interior colour) is = 35 and the cell contents need to equal a named cell called filename.
In laymans terms if it were a formula would be roughly:
In the range of cells called "AllGoals" count the cells that have a background colour of 35 and if the cell has the same contents as cell "filename" then display it in the sheet called profile in cell "G10".
I have attached a copy of the xls to hopefully clarify things.
Thanks in advance.