Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations MintJulep on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
locating and gathering data from many sheet!
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...- WJT19
- Post #5
- Forum: -Engineering spreadsheets
-
locating and gathering data from many sheet!
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...- WJT19
- Thread
- Replies: 6
- Forum: -Engineering spreadsheets
-
Combo box names.?
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...- WJT19
- Thread
- Replies: 2
- Forum: -Engineering spreadsheets
-
Excel combo Box referencing
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...- WJT19
- Thread
- Replies: 3
- Forum: -Engineering spreadsheets
