Search results

Mornin'! I have a slight problem (more of an annoyance). I have a workbook with countless worksheets. On each worksheet I have data vailidation employed, all the drop downs work fine on every sheet but one. The drop down will not work, but if I hold Alt + Down arrow the list appears (But...

Hi guys, easy one for you. I have 4 colums: the 1st I have a unique code. the 2nd i have the date log 3rd a colum with 4 types (red, blue, green etc) for example. 4th just a title. I need to count the number of colours in colum 3 in each month (Aug, sept, oct, Nov, Dec, Jan and Feb...

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...

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...

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

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...

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

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...

Hi guys, I have another query. Ive got my spreadsheet/timeline working how i want it to, but now I have added a 'Probability' column. I now need the month-fills colour coded: Red if -1 Orange if 0 Green if 1 I cant get mine working, It colours the correct cells but also fills the...

Hi, I have a spreadsheet with numerous columns and I wish to make a 'timeline' (filling cells with a colour based on 2 dates). Example: Project ID - Date Start - Date finish AA0011____01/01/2010_01/03/2010 AA0012____01/02/2010_01/04/2010 then i'd have my timeline to the right of it...

Hi, I have a signle table with a large number of feilds (project ref, name dates etc... and a large number of skills). the skill feilds hold a number (number of days) assigned to each skill. If no values are entered no skill for that particular project is needed. Many of these feilds remain...

Hi, I have a signle table with a large number of feilds (project ref, name dates etc... and a large number of skills). the skill feilds hold a number (number of days) assigned to each skill. If no values are entered no skill for that particular project is needed. Many of these feilds remain...