Recent content by SmithyJD

Dohhh remember being told that now must be my age. Thanks for the reminder at least I have some hair left been pulling it out :)

I have a list of date and times in coulmn A, in column B1 I have the formular =countif(A:A,">06/07/2013) which returns 133, in c1 I have 06/07/2013 and in c2 =countif(A:A,">C1") which returns 1. Any ideas what I got wrong as I am scratching my head big time with this one Thanks JD

Well either there are no Bank Holiday in 2013 or it didnt for me any ideas people?

Ok I have added public holidays to my outlook/exchange calendar and its been extremly usefull what I now want to see is next years holidays but when I try add again it just adds the current year any idea how I get it to add future years ? Thanks John

To add a little I just discovered that 1 should be CardId=Range("E" & Intcount) 2 if In debug I make the workbook containing analysis sheet active it works but I dont want to do that. Cheers Jd PS wish you could edit your own previous post if no one has replied.

OK heres the code I have For intCount = 1 To intCountcells CardType = Range("C" & intCount) Select Case CardType Case Is = " Card Creation Event" CardId = Range("E" & intCountcells) Sheets("Analysis").Range("A2").Value = CardId MsgBox "Card Cteate" End Select Next intCount When I run it I...

Hi Can someone please explain to me in simple terms the differents between using these two commands to set a cells value Sheets("weeklyreport").Range("b" & y).Value = XXXXX Worksheets("weeklyreport").Range("b" & zz + 7).Value = XXXXX Also is there an equivalent that...

Thank you a prefect solution! [2thumbsup]

Hi I have a macro which is reading data from one work sheet and matching it to another however occasionally the user ends up the the source data as number stored as txt (its being filled in by some remote app) consequently when I come to use it in my macro it dont always match. Is the an...

Yep thats what I want to do, as a work round we now have a short descption 256 charachters and a details column not ideal but got me working.

When I create a list sharepoint adds a title field with a type of 256 characters, I need this to be a multiple line column I couldnt change it but managed to hide the title field and create my own called incident however I then can't edit existing entries ie I lose the functionality assigned to...

That explains it then its a Lookup field I am trying to combine, back to the drawing board for that then. Thanks Jd

I have created a new list to manage reoocuring calendar task to get round the issue of not displaying sub headings for all day tasks I want to create a calculated field combining Task and closed by. However the closed by column doesnt appear in the list when i try and add a calculted field, any...

I have a crystal report which we run through the excellent Crystal Coral report manager what I need to do is print two copies of the same report one headed Customer Copy and the second identical but for changing the heading to read office copy. Guess I could be a subreport on the last page and...

Thanks for that Peter off for a look at the options now. Thanks again Jd