dependant

  1. A

    Dependant Drop Down lists without a macros - how to reduce the file size

    Hello I've created a dependant drop down list in Excel to aid user entry but the size of the file is worrying. Empty it is 300KB, when I add my data in (around 6,000 rows) it goes up to 600KB. I could get around 100 responses (via email) that I would then need to attach to the relevant record...
  2. D

    HELP with INDIRECT formula

    Hello Can anyone support me and figure out why the formula below is not working? What I want is for the formula to work, dependant on what value is entered in cell O2 on a worksheet =MODE(INDIRECT("C"&ROW()-o2)&":"&INDIRECT("C"&ROW()-1))
  3. G

    Unhide specified number of rows

    Hi, I am very new to VBA, so please be gentle. I am looking for some code that will unhide a specified number of rows, dependant on a Cell value. For Example, If "B2" states 2, then 2 rows will become unhidden, starting from row 2 inclusive (2:3). If "B2" states 5, then 5 rows will become...
  4. G

    dropdown list with criteria

    Hello, currently i am using the following recorded code to create a dropdown list Columns("ab:ab").Select With Selection.Validation .Delete .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _ xlBetween, Formula1:="='SQ Hierarchy'!$A:$A"...
  5. B

    Copy certain cells dependant on cell value

    Good afternoon, Can you please help. I have a infrastructure fault spreadsheet, which shows all faults in my building. It has 2 tabs one named Fault and one named EWP. Within the fault tab, there is a column W which states if a job is over due "X" or complete "Y". In What I am after is to copy...
  6. E

    Data Validations Dependant Lists

    Hi, Could I possibly ask for some help on Data validation dependant lists I am trying to set up a dynamic dependant drop down list, but because my headers will change due to formula's elsewhere on the sheet, (lists outstanding orders) is there a way to still have the dependant drop down lists...
  7. sharky12345

    Custom Ribbon Items dependant on User

    Guys, Firstly, wasn't sure if this needed to be posted here or the general forum, so apologies if it's the wrong one but as it's related to Excel I guessed here would be ok.... I've been using the Custom UI Editor to add my own Ribbon menu items - this has been successful but now I need to...
  8. J

    Formula with tolerance & conditional formatting

    I am trying to add a formula which looks at 2 results, also a set tolerance. Should the second result be within tolerance of the first result then the cell would need to be formatted green or red dependant on within/outside tolerance. eg 1 result 1 - 15.96 result 2 - 15.92 Tolerance - 0.1 eg 2...
  9. N

    Goal seek Two dependant target values by two dependant input cells

    I have searched extensively for the above, but i cannot find a solution that is iterative and that satisfies the conditions. I have a value, x, in cell A1 and a value, y, in cell A2. Then i have a value, k1, in cell A3, and a value, k2 in cell A4. I want to change the value of x and y, to...
  10. T

    VBA rename sheet based on calculated cell value

    I already have VBA code using a "Worksheet_Change" event that works successfully to rename specific sheets in an Excel workbook once a value from a dependant dropdown list on the cover page "Sheet1" is selected. On the same sheet1 in a separate range "Y120:Y127" a formula concatenates the...
  11. sharky12345

    Use formula to change cell value dependant on another

    I've got this formula which updates a cell dependant on another - it shows either true or false dependant on the other value; What I'm trying to do is add a condition that will show 'true' if J26 is 'NTE' but I can't get it to work. The formula was on a worksheet sent to me, so not something...
  12. M

    Cell with list validation only required based on another cell

    I have a range (A1:A100) which has list validation requiring either R,L or T as the list. Blanks are not ignored here. I have another range (B1:B100) which has list validation requiring Bass,Bliab,Bequ,Prev,Pbas,Pexp,Pinc,Unex as the list. Blanks are ignored here. I would like to set it up...
  13. P

    VBA message box code - help needed

    Hi, i am trying to write some code in VBA that says when a button is click check if cell L49 is populated with the value yes then Cells L52,L55,L58 will each needs to be populated, if they are empty I need a message box to appear, if the Cell L49 doesn't say yes the script can end at that...
  14. C

    combo box dependant userform submit button

    I have this code: Private Sub sbmt_Click() Dim irow As Long Dim wb As Workbook Dim ws As Worksheet If NHdata.nhNme.Value = "JOHN" Then Set wb = Workbooks.Open("L:\NAMES\JOHN\JOHN.xlsm") Set ws = Worksheets("Data") ElseIf NHdata.nhnNme.Value = "GRANT" Then Set wb =...
  15. S

    VBA Macro that Shows and Hides Rows depending on User Input

    Good Morning All, I'm trying to write a macro that shows and hides rows on the click of a button. I have rows 33 - 51 - of which certain groupings need to show when a specific user input is detected. I was trying to make so that the selection was converted to a number (1/2/3/0) with formulas...
  16. David Kemp

    Count depending on instance?

    <tbody> Tony Yes Tony Yes Frank No Frank Yes Frank Yes Tony No Tony Yes Kate No Kate No </tbody> Hi everyone, I want to count how many times yes has occurred once for each person. For example, Tony has 3 yes's, Frank has 2, Kate none. I want another cell to...
  17. N

    Combining dynamic dependant drop down lists in a single result

    Hi, I'm not an expert in Excel, but I need to make a sheet to facilitate my work. I will describe the situation, so you guys maybe will see a different solution for my problem. I have a spreadsheet where I have different inputs, and new arriving every week (let's call it #Input1). I have a...
  18. O

    Filter combo box based on cell value (or another combo box, or list, or anything else)

    Hi Guys, I have searched and not found the answer to this because my sheet has to use comboboxes and CANNOT use data validation - too much else is dependent on the combobox at the heart of this (plus the information in the comboboxes are set not to print out - it would ruin the form if they...
  19. J

    Ignore blank cells in a named range when using dependent data validation

    I am using dependant data validation in cell ‘Sheet2!$B2’. It’s formula is ‘=INDIRECT($A2)’. The dropdown menu in ‘Sheet2!$B2’ then references a named range in ‘Sheet1!$L:$L’, which at times has one or more blank cells at the top of the column. I would like to ignore the blank cells in the...
  20. W

    Checkbox Link Dependant on Address Function Value???

    I am trying to create a Football Pick'Em spreadsheet and having some trouble. On one sheet I have "Week 1" picks. In Column A of "Week 1" it has the first and last names of all the players in my league. In the next 32 columns it has the teams that they picked (designated by =TRUE for a guess...

Some videos you may like

This Week's Hot Topics

Top