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

    WORD doc Formula for Drop Down list without adding item one by one

    As above this is an Excel space. However, it seems you might be looking for some VBA for you purpose so I just googles this: https://www.gmayor.com/word_vba_examples.htm Good luck
  2. Matt_Straya

    Copy multiple sheets to one master sheet - header issue

    Thats it! Thank you p45cal! sometimes (most times) I cant see the wood because the trees are in the way! Cheers
  3. Matt_Straya

    Copy multiple sheets to one master sheet - header issue

    Thanks P45Cal, That code does the same. I have attached a file that demonstrates the issue I get on the master sheet. Thanks for your time!
  4. Matt_Straya

    Copy multiple sheets to one master sheet - header issue

    Thanks vletm - that is me. This code is meant for other people at my work but CAPU is me
  5. Matt_Straya

    Copy multiple sheets to one master sheet - header issue

    Hi I have a problem I should know but am getting tied up in knots over it. I have multiple XML files that I pull into one Workbook (multiple sheets), then the next bit of code creates the Master sheet and copies all the sheets data into it - all good up to this point. However, I only want the...
  6. Matt_Straya

    Macro to clear a column range based on another cell value

    Perfect Alan, Thank you!!
  7. Matt_Straya

    Macro to clear a column range based on another cell value

    Hi, I have a sheet that has dates on it, displayed as days of the week. I am trying to get a macro to clear the contents of the column range from F7:F22 if F5 has "Sat" or "Sun". What I have tried as a private sub clears all the cells, not just the column range under Sat or Sun. Any ideas -...
  8. Matt_Straya

    ShowDataForm vba error 1004

    Thanks Chilhiro the sheet is a bit sensitive but what you have given me make a lot of sense. Thank you.
  9. Matt_Straya

    ShowDataForm vba error 1004

    I am at a loss why this error is occurring the vba is Worksheets("Questions Act").ShowDataForm this is the error I get - any ideas how to fix it?
  10. Matt_Straya

    Copy sheet address to a formula

    Thanks Pecoflyer! works a treat using this: =IFERROR(INDIRECT("'EMP"&ROW()-10&"'!$K$2"),"")
  11. Matt_Straya

    Copy sheet address to a formula

    Thanks S - no that didnt work. the original formula is =IFERROR('EMP4'!$K$2,"") - Id like to copy this formula down the column and the EMP4 to change to EMP5 and so on
  12. Matt_Straya

    Copy sheet address to a formula

    Thank you, yes! - each sheet is called EMP1, EMP2 etc up to 40
  13. Matt_Straya

    Copy sheet address to a formula

    Hi, instead of typing out each formula I want to copy a list of 40 rows referencing to each sheet. I have attached the example. Any ideas?
  14. Matt_Straya

    Userform ComboBox to set active cell

    Thanks for your time and reply. It has heaps of confidential stuff in it so I have abandoned the form altogether.
  15. Matt_Straya

    Userform ComboBox to set active cell

    Below is my current code. I want what ever is chosen in the combobox to make the cell active. Then, edit it if required and save it. Private Sub CommandButton1_Click() Unload Me End Sub Private Sub TextBox3_Change() TextBox3 = Format(TextBox3, "$#,##0.00") End Sub Private Sub...
  16. Matt_Straya

    Userform ComboBox to set active cell

    Thanks Logit, not exactly what I am after but a helpful video just the same.
  17. Matt_Straya

    Userform ComboBox to set active cell

    Hi, I cant remember how to use the combobox choice to set the active cell. Can anyone please advise?
  18. Matt_Straya

    How many people are away today? - Match dates and return corresponding value

    Perfect! thank you! and just in time for the report to the boss :)
  19. Matt_Straya

    How many people are away today? - Match dates and return corresponding value

    Hi I am looking to return a value that matches today's date. I need to know how many staff are away based on today's date. I would really appreciate any help on this one.
  20. Matt_Straya

    Highlight cells if they contain another cell value

    Excellent -thank you so much! Fluff13 formula works perfectly. bosco_yip formula highlights only 2 numbers half way down the list. It may be the way I entered it? The VBA also works great - thank you!!
  21. Matt_Straya

    Highlight cells if they contain another cell value

    Hi, I cant for the life of me figure out the formula to highlight a cell if it contains the value from another list I can get something to work but it is never right. Attached in the sheet. I want the "Tenure" column on sheet "MINAW" to look at the list on Sheet2 and highlight the relevant cell...
  22. Matt_Straya

    UserForm check boxes

    No hold it - thats not right either the cell may have several different values and the checkboxes need to reflect that value
  23. Matt_Straya

    UserForm check boxes

    OH! I can see the mistake already! It references CheckBox1 for all instead of the other checkbox names. I was trying to get the checkboxs to populate with that coade.
  24. Matt_Straya

    UserForm check boxes

    Hi, I have a training sheet I am trying to build, please forgive the untidiness of it. one problem I am having is that in cell C4 I have a conditional format to display checks, crosses etc using 0, 1, -2, -3 and -4. This works ok but when I open it in a form, the same check box is checked for...
  25. Matt_Straya

    Copy formula but change row referance

    Fantastic! both work well. Thank you.
Back
Top