Recent content by leehale

Thankd for your suggestions guys. Was trying to avoid any work at all and put in place a ready completed joby that doess it all but cheap to aquire. Then hand over to the new replacement when he has been sourced. Thanks again Lee

I realise that this is probabley not the right place to get this information but it is normally very good for my formula questions, Anyway here goes. I have just been handed the job of scheduling the transport vehicles and drivers for a local school. (Old chap that ran it has sadly passed away)...

Sorry to be late reply been out. The formula goes into A1 and the date is entered into A2, when I set the formula into A1 it returns period 3 when A2 is empty, not sure why but can manage if there is no option. Thanks for your time Lee

Thanks for that good idea using just the months it nearly does what I want. If there is nothing in the date cell it defaults to 3 for some reason, can this be improved? sorry to be fussy but the guy using it will be happier having it right for him. Thanks Lee

Hi there, I am trying to get a period reference from a list of dates, should be easy but I am struggling could you help please. I have a list of dates going from 30/09/2009 going on through till 2011 they are dates entered when a trip is scheduled. I need to get them to referenced as a...

Thanks all so far but I have still got problems. I have tried all of the suggestions so far and still have a problem. I dont think I have explained it properly so with your patients I will try again. The numbers are the result of a report that are dumped into excel, they are the summed total of...

Hi John. I cannot take the first zero away because it is there to cope when the hours go above 99. Some of the totel colums go in to the hundreds so will need to add all of the numbers. Any other thoughts please.

I now this is an old one but I am having problems with it again. I have a long list of time totals that are formatted in gemeral instead of time. I need to total these times can you help please. A 1 003:30:06 2 001:00:50 3 005:47:39 4 000:00:00 5 001:59:16 6 002:52:49 7...

I have been archiving data from my access data base by copying the data base and naming it database_date.mdb. I now need to gain acess to the archived data from the data base that is active and create queries from the archived data as well as the live data. Is there a simple way of importing the...

I need to take data from one sheet to another using to reference points to ensure the correct imput. I hope the example below explains. AREA PERIOD SCORE TOP PD1 72 MIDDLE PD1 60 TOP PD2 54 BOTTOM PD3 48 The data is exported from a data base for...

Thanhs Tony. I will have a go and let you know. Lee

Thanks anyway but there is numeric as well as alphanumeric. My quest will carry on.... Thanks Lee

xlbo. Thanks fo the response but how do I use a vlookup to check two sheets quickly? I am familiar with vlookups and cannot see how it will check a whole sheet of multiple columns that are updated daily and the differences are not easily visible and could be in any of the the columns...

I have two sheets of data that I need to compare to make sure that the data is the same. Is there a function in Excel that will do this quickly for me. Thanks Lee

Hi. I want to connect to my colleagues PC to help him with a spreadhseet. How can this be done? We are both on the same network. I have windows 2000 he has XP if that makes any difference. I would prefer a way that does not rewuire any software downloads if possible. Best Regards. Lee