Search results

  1. O

    Days per Month

    Yes I use networkdays alot. But I couldnt find an easy way to break down the network days by month. Thanks for your reply, I dont suppose you could quickly write up a workbook with the month ranges from Feb 2009 - Feb 2010? I have over 200 dates that need sorting by month ranging from the...
  2. O

    Days per Month

    arghhhhhhhhhhhhhhhhhhhh! Have I not explained myself clearly? please someone at least tell me that much...
  3. O

    Days per Month

    :( Please someone help, im sure there is an easy solution...
  4. O

    Days per Month

    Please help, I need a solution ASAP. Thanks
  5. O

    Days per Month

    Hi guys, Easy one for you here, I just cant think of a way to do it. I have a list of dates (Sample): 17/02/2009 07/04/2009 17/02/2009 16/03/2009 19/02/2009 17/03/2009 20/02/2009 17/03/2009 24/02/2009 15/04/2009 26/02/2009 19/03/2009 All I need is the number of days (Networkdays) per...
  6. O

    Numeric field overflow

    Hi guys, I have a database using link tables from Excel. The Excel spreadsheet itself is linked to another workbook on a sharepoint network. Yesturday everything worked fine when I put it together. Now I open a query and it works fine (the first time)... But when I run the query again I...
  7. O

    Query subtracting 2 months

    Yeah, way ahead of ya :) Thanks!
  8. O

    Query subtracting 2 months

    Thanks alot mate!
  9. O

    Query subtracting 2 months

    I have a query and I need the last feild to subtract 2 months (or 60 days) from a date specified in a different feild. eg. Query 1 ID: R5345 Start: 01/03/2010 Calculation feild = 01/01/2010 I just keep forgetting simple things... Many thanks guys
  10. O

    Macro - Filter

    Thanks again Namliam! Perfect
  11. O

    Macro - Filter

    Hi guys, I have a macro filter used on a form - toggle buttons. I have 8 feilds in my form. One of them being 'Allocation'. The form works fine, im using buttons to filter by feilds or data included in the feilds. I have a number of buttons within an option group which filters the...
  12. O

    Conditional Formatting - Including a Sum()

    Could someone please advise? Fair enuff if its not possible, but I need this sorting asap
  13. O

    Import data from a worksheet in a closed spreadsheet.

    Well thanks.. All i needed was someone to tell me to copy the data -> paste special and select copy link. There is very little help available on here...
  14. O

    Conditional Formatting - Including a Sum()

    is this possible? I need this asap. thanks again
  15. O

    Import data from a worksheet in a closed spreadsheet.

    Where do i put the range? The wizard is Data -> Import external data? Could i have an example pleasE?
  16. O

    Import data from a worksheet in a closed spreadsheet.

    K, all I need to know is how to specify a selection, I dont want/need the whole worksheet, but a portion of it. Many thanks
  17. O

    Import data from a worksheet in a closed spreadsheet.

    Hi, I've had no luck finding a solution. I need to import selections of data from a worksheet in another excel spreadsheet. Data import is OK, but I cannot select a worksheet or a selection in that worksheet only the first worksheet and the entire page! Many thanks
  18. O

    Conditional Formatting - Including a Sum()

    Hi, i'm sure you've seen my previous threads (sorry for dominating :cool:). K. I have conditonal formatting on my grid with 3 conditions: =IF(Q4=TRUE,$O4=-1,) go red =IF(Q4=TRUE,$O4=0,) go orange =IF(Q4=TRUE,$O4=1,) go green I now need to include a sum 'I4' (Total) divided by 'M4' (No...
  19. O

    Conditional Formatting - Multiples

    SOLVED: =IF(P4=TRUE,$N4=-1,) =IF(P4=TRUE,$N4=0,) =IF(P4=TRUE,$N4=1,) Thanks anyways guys :)
  20. O

    Conditional Formatting - Multiples

    Yeah I already tried that :( Formula Is =AND(TRUE, N4=-1) Formula Is =AND(TRUE, N4=0) Formula Is =AND(TRUE, N4=1) Its filling the rows I want in the right colour, but all the 'FALSEs' are filled too... P.s I'm using a few different sheets to experiment, so obviously cell co-ordinates...
Back
Top Bottom