MINTJULEP
Your idea is similar to the one I devised, which Im gonna use, I was lookig for a quicker answer. Im gonna simply do all the ifsums in hidden cells in each table then add them all up at the end. Its easy enough, just gonna take all day condsidering the size of the spreadsheet.
Thanx...
This is a little complicated so, forgive me if this isnt 100% clear. Here is a diagram to help.
___H_____I_______J_________________
3 5 A
5 2 B
5 5 B
4 1 C
2 5 B
In colum 'J' I have coding ('A', 'B' and 'C'), now say I wanted to...
Im trying to use an if statment where the "IF" part refers to the choice taken in a combo box. Iv got it working oerfectly using cell, but I just cant get it to use the combo box instead of the cell.
Basicall all i need to know is what is combo box 1 called, Iv tried combo box 1...
How do you reference to a combo box, its hard to put into words I will explain what Im doing.
Im making a spreadsheet for a company, they need all there expenses for each day listed and they have several (around 20) catergories ranging from motoring to rent, ext. I need to spreadsheet to look...