Search results for query: *

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

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

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

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...

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

ah maybe enable macros, how do i do that?

yes, tried again sorry

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

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

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

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

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

Nothing more cosmetic than that???? Ta L

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...

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

I apologise for being unclear however I feel your response is rather abrupt... but its only my opinion ok lets see if I can explain it more clearer than my last attempt At present I send a form out to my staff to complete regarding hours worked When I receive these forms they are stored on...

Thank for that, as i am fairly new to the excel scene (know the basics) what i am trying to do overall is At present what happens is each user is sent an excel spreadsheet with cells to complete when they send it back the files are stored in a folder and a gather macro is used to collect...

Hi all, Here is my problem, I want ot be able to have 2 dropdown lists that if I selected a certain word in dropdown list 1 then dropdown list 2 only displays the values linked to the first value Is this possible? Thanks In Advance Guys any working examples wopuld be really appreciated

thanks for the reply, not sure iof we have that software cheers l

The title above is rather poor however I will try and explain here. I have a list of excel files stored on our network drive, do what I want ot be able to do is to lock them fully so that if someone was to copy it to their own computer if they tried to upload it back I would be notified or they...