1. T

    don't copy sheet with specific name

    how to not copy a sheet with specific name please, thanks!
  2. A

    exel 2002 total accumulated payments

    i need to know what is the toal of monthly payments i have made i have forgotten how to include a spreadsheet on this forum post! thanks all <colgroup><col style="mso-width-source:userset;mso-width-alt:2560;width:68pt" width="90"> <col...
  3. S

    LARGE MATCH and INDEX formulas with dublicates

    Hello, I have big problem. I want to make a 1,2,3 biggest numbers but there is two simillar so exel write two same words, how should I write the formula? =INDEX(A4:A16;MATCH(LARGE(H6:H16;{1;2;3}); H4:H16; 0)) How should I correct this formula? If it need, i can add the photo. P.S. sorry for...
  4. L

    Adding dynamic excel filter search box to existing exel tables?

    Hello all, Please help me with this. I have tried many vba and tutorials on youtube but with no any luck. I wanna add dynamic excel filter search box to existing exel tables. Can you please help with any tips?
  5. M

    random assignment

    Hello i have 1001 individuals in my dataset, i would like to assign randomly to each one "owner" and "non_owner". knowing that after the random assignement i should have 71% owner and 29% non-owner. is it possible with excel? thank you for your help
  6. F

    Combox list depend on OptionButton value

    Hi all, I'm trying to include 2 lists for my Combox listing, but it's not working.... Here's my code and I hope someone here is able to help out Private Sub OptionButton1_Click() End Sub Private Sub OptionButton2_Click() End Sub Private Sub OptionButton3_Click() End Sub Private Sub...
  7. G

    Excel Macro Just need to go next ROW if the value is not Numeric.

    This code has some syntax error but its generic I cant understand. Says For with no Next I have got an next in code it as I am new at this how can I Skip to next row if the row does not contain a number? For Each Nextcell In Range(InitialRow) If Not IsNumeric(Nextcell) Then...
  8. J

    Data Validation and Current Time

    I am creating a spreadsheet for users to punch in an out after they have completed a task. I need to ensure that these entries are honest. Is there a formula I can use that will ensure a user can only enter the current time in a given cell?

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...