Recent content by LMcleod

Ramzi, my apologies! You can actually do it from there, by going into sort options & choosing sort from left to right! oops!

Thanks Carrr, I'm checking it out now. Ramzi, I realise that sort was there, but it only sorts rows, not columns. Thank you anyway.

Hi, Just wondering if anyone knew of a quick way to sort columns in Excel. I have column headings in row 1, and I want to sort the data in alphabetical order. The long-winded way would be to copy, paste special values & transpose, then sort, then copy, paste special values transpose back...

Thanks Carrr, I'll give it a go

Hi, I was messing around with Word the other day, with WOrd Art and all the effects you can assign to your text (eg. flashing text, 'blurry' effects etc.) Somehow I have set it to automatically have this effect on every worksheet I open, and I can't remember what menu I need to go in to change...

I will try these both this morning, and get back to you. Thanks for your help.

I've got a spreadsheet that I'm using to test this. If anyone is interested, then send me your email. I'm off home now, but I'll be checking the forum tomorrow morning.

Zathras, 1) 9 days 2) 8 days 3) 10 days 4) 11 days

xlbo, I see what you're saying - I'd like to assume that it is 1 month between any 1 date in one month and the same date in the following month, regardless of the month being 28, 29, 30 or 31 days. Mmmmm...I can see this becoming tricky. You would think there would be a function that would...

Uberskunk, Sorry, I don't think I explained too well what I needed. I'm after the difference between 2 dates, but (see above) the difference between 5 July 2002 and 25 September 2002 will be "2 months 20 days", NOT "2 months" and NOT "81 days" I hope this makes it...

Zathras, It will be 2 months 20 days.

No, I have looked at this function, but that gives me the total difference in months. For example, if the start date is 14/04/02 and today is 15/04/02 (which it is!) I need the answer to be: 1 year ( this one I have worked out correctly) 0 months (this is the one I have trouble with) and 1...

Hi, I need to get a function to produce years, months and days from a given Start Date up till Today. Here is what I've come up with so far - the years and days arre working fine: Years =YEAR(TODAY())-YEAR($A2) Days...

Hymn, That'd be great! I'm using Access 2000. My home email is mcleodh@aol.com Cheers Lou

Illini, Thanks for this - since I'm not too clued up on VBA, could you tell me where I can put this code amongst what I already have? Here's what I have behind the button: Private Sub Command39_Click() Dim db As DAO.Database Dim rs As DAO.Recordset Set db = CurrentDb Set rs =...