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!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Lee24

  1. Lee24

    Excel IF Statement

    Still lost.... All I am asking for is some help so third time lucky Can someone point me in the direction of how sumif helps but if its too much of an issue just forget it... However thanks for the help and example of sumif from jlf81
  2. Lee24

    Excel IF Statement

    Skip can you please give me an example? I have tried various attempts but fail each one Much Appreciated
  3. Lee24

    Excel IF Statement

    Ok Target Value Complete 1 15 Y 2 15 Y 3 15 4 15 5 40 Total 30 So when I manually enter a Y in the 3rd column the total increases in this case would be 30
  4. Lee24

    Excel IF Statement

    Hi Guys, Trying to come up with a formula that will........ I have targets Target 1 = 15 Target 2 = 20 Target 3 = 30 Target 4 = 10 Target 5 = 25 What I want to be able to do is that when Target 1 is complete I put a yes in the cell beside it and there is a total amount complete cell at the...
  5. Lee24

    combobox to select worksheet

    Bingo...... Thanks, i am just going to a meeting just now i will let you know how i get on Thanks Again
  6. Lee24

    combobox to select worksheet

    ah maybe enable macros, how do i do that?
  7. Lee24

    combobox to select worksheet

    yes, tried again sorry
  8. Lee24

    combobox to select worksheet

    Yes... The drop down works as I can see my worksheet names, just when i select one it changes in the box but that sheet does not open do you have a working example you could send me? thanks
  9. Lee24

    combobox to select worksheet

    Sorry, when the user (me) clicks on the cell the list appears, when I select something from the list I thought it would open up the relevant worksheet? sORRY
  10. Lee24

    combobox to select worksheet

    Hi, must be missing something here.... Is there anyway that the drop down arrow can be displayed on screen rather than appear when they click on it? Also followed your instructions and nothing happens when I select an option. Thanks L
  11. Lee24

    combobox to select worksheet

    Hi, Can someone point me i the correct direction of how to use a combobox on sheet 1 of excel to automatically go to sheet 2 / 3 / 4 etc etc. Many Thanks L
  12. Lee24

    Create Menu Screen In Excel

    To be honest I dont know where to start.............. do you have any eXamples? L
  13. Lee24

    Create Menu Screen In Excel

    Nothing more cosmetic than that???? Ta L
  14. Lee24

    Create Menu Screen In Excel

    Hi all, just a quickie but sure someone iwll know what to do.... I have a excel sheet with 12 worksheets within it, i am looking to have a small menu that the user can click on and it takes them straigt to the worksheet. Any examples would be greatly appreciated. L OH YEAH THANKS IN ADVANCE...
  15. Lee24

    Excel - Drop Down Lists

    Ok thanks for the response, so now I know that one avenue not to go down is data entry (as I really need all the information) in Excel. Do you have any suggestions on how to tackle my question? Thanks L
See more

Part and Inventory Search

Back
Top