• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. S

    VLOOKUP not working

    Thanks, That worked a treat. Shazz x
  2. S

    VLOOKUP not working

    I have a simple VLOOKUP Formula that I just can not get to work. =VLOOKUP(L3,WkNos,2,FALSE) Can anyone advise what I am doing wrong please. Shazz x
  3. S

    Colour Tabs for Protected/Unprotected

    vletm, Sorry What I meant was I want all the tabs to show as Green when protected except the Summary which should be yellow, all tabs should be red when unprotected as well as the summary sheet. Shazz
  4. S

    Colour Tabs for Protected/Unprotected

    Sorry these are two different spreadsheets, I got myself confused lol. The Summary Tab on my other project needs to be Yellow if Protected and Red if not protected. Is this possible. Shazz
  5. S

    Colour Tabs for Protected/Unprotected

    Sorry the Holidays Taken will not refresh when the protection is on, can this be changed at all? and the Summary Tab is definitely not changing color. Shazz x
  6. S

    Colour Tabs for Protected/Unprotected

    v On the attached, the Summary Tab is not colour Coding?, also can you take a look at the Holidays section on the Summary Sheet, they are not updating even though is shows it has been refreshed. Shazz x
  7. S

    Colour Tabs for Protected/Unprotected

    That does not seem to be working vletm. Shazz
  8. S

    Colour Tabs for Protected/Unprotected

    I am using the below code that highlights my tabs green if protected and red if unprotected, I have a Summary tab that is also protected but I want this to show Yellow if Protected and red if unprotected. Can anyone advise how I go about this please. Private Sub Workbook_Open() Dim wbk...
  9. S

    Tab colour for Protected / Unprotected Sheets

    Please ignore, I have now worked this out.
  10. S

    Tab colour for Protected / Unprotected Sheets

    Hi, I found the below code on the internet that is supposed to color each tab depending on if they are protected or unprotected, but it is not working. Can anyone suggest anything please. Private Sub Workbook_Open() Dim wbk As Workbook Dim ws As Worksheet Set wbk = ThisWorkbook...
  11. S

    Calculate Holidays Taken across whole Workbook

    Attached is the code you have used, by looking at one of my tabs on the attached Screen Shot, can you see what I am doing wrong? Function Get_Holidays_Taken(y) On Error Resume Next Application.ScreenUpdating = False With Sheets("Summary") ww = 0 For w = 1 To 52 ww = ww +...
  12. S

    Calculate Holidays Taken across whole Workbook

    vletm, I need 52 separate sheets becasue there are 52 weeks in the year. I've tried both of the ways above and it does not work for me in my spreadsheet, can I message you with the spreadsheet for you to take a look at? Shazz
  13. S

    Calculate Holidays Taken across whole Workbook

    Hi All, I need to know how I can calculate all holidays taken across 52 tabs, attached is a example copy of what I need. Each persons holiday is input on each tab and then I need the Summary tab to show a yearly total, once all tabs have been completed. Any help would be greatly appreciated...
  14. S

    Count specific Text in a range of Cell on another tab

    Dont worry, I have now sorted it out. Thanks for your help. Shazz
  15. S

    Count specific Text in a range of Cell on another tab

    it is still not working, I have copied and Pasted, which is what I normally do, I have typed it myself and this is what I am getting.
  16. S

    Count specific Text in a range of Cell on another tab

    That is not working for me, it is showing what is on the attached. Shazz
  17. S

    Count specific Text in a range of Cell on another tab

    Hi, Can Anyone help at all, need to be able count specific text (SB) in a range on another sheet tab. Can anone advise a formula. On the Summary Tab, I want a formula in Cell L2, that counts the range K6:O6 on Sheet Tab named wk 6 if SB is in any of the cells. Attached is an example
  18. S

    Drop Down List

    Hi All, Can any one advise how you go about having a drop down list with "Select Name" as default in the box but not have this info in the named range?? Thanks Shazz x
  19. S

    Formula for showing initials

    Hi All, I have a spreadsheet (Order Form), in C44 you cn choose a persons name, and I want once the name has been chosen, Lets say Joe Bloogs, in B10 I want BJ to display, I have on tab 2 (Signatures) names of the people in column A and the Initials in column B, I just dont know how to use...
  20. S

    Conditional Formatting Names in a cell

    Hi All, I have a spreadsheet were I want only certain names in Column H to highlight Bold, ie Tracy, Sue & Richard. Please can you advise what formula I need to use, for the life of me I can not work it out. Shazz xx
  21. S

    Formula for Conditional Formatting

    Thanks for that, that worked great, is there any way the VLookup can be altered so that if a project code appears and is is not in the approvers list that it will automatically show as Sarah??
  22. S

    Formula for Conditional Formatting

    Can anyone tell me what Formula I would need to do the below. Cell A1 has ULKY5010 then G1 shows Joe Bloggs. Basically I have a list of 6 names and various Project Numbers, depending what Project Number is shown in A4 will depend what name is shown in G4, or would a lookup be better. Please...
  23. S

    Pick Month out of a Date

    Thanks, that worked great. Shazz xx
  24. S

    Pick Month out of a Date

    Hello All, I Have a Cell that has todays date in it "20 March 2017", I would like another cell to show just the Month i.e "March", is this possible at all?? Shazz xx
Back
Top