Search results for query: *

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

We have a number of reports that our users run through Sage Manufacturing which have been developed in Crystal, we are to stop using Sage but the users need to continue to run a number of the crystal reports is there a way to run them from a command prompt for example? If it makes a difference...

Already done :)

The spreadsheet in question is a graphical representation (very simplistic) of future sales by week and the colours are changed by the user as they are updated form potential to firm order, to received hence some of it is real guess work/gut feel. Yes we could add a flag for status and sumif...

Trouble is Colour is one of the few things senior managers actually understand. F9 it is thanks

I have a custom fucntion which sums the values in a range depending on the background colour of the cell it works fine however it does not auto update when the colours change and the user has to manually recalculate the sheet by pressing f9 any ideas? the code is below Function SumColor(rColor...