variable input cells

  1. L

    SUMIF on a variable range

    Hi, I am looking for a formula that will allow a SUMIf on a variable range. I need it to sum the total column for any amount above £7,500 but it needs to exclude the grand total line (row 10 on the example below). The end of the range varies on several sheets and month to month, so I am...
  2. T

    link it! hyperlink with variable input cells

    Hi most appreciate expert, I would like to insert a hyperlink in the following code: Sub metadata1() Dim wsOut As Worksheet Dim zOut As Long Dim xOut As Long Dim ws As Worksheet, WB As Workbook Dim varFS Dim i Set wsOut = ThisWorkbook.Worksheets(1)...

Some videos you may like

This Week's Hot Topics

Top