named rages

I am making a bracket for basketball teams by region. I select the winner of the game based on a list referencing the named ranges you see pasted below. I pull data from multiple web queries into each regional bracket and have many formulas. Because of this, its quicker to copy the sheet and...

Hello all - I recently posted something similar here, and got some great help that got me 70% of the way, but I'm still stuck. Was hoping someone could pick up the thread and show me the error of my ways. Thanks! Final result desired: I have a chart on Sheet3, and wish to update that chart...

I have 50 named ranges. Some of them are just a range, others have dynamic ranges (formulas). None appear to be incorrect. Everything is calculating correctly based off of the named ranges. I have used the Name Manager to filter for Names with Errors and there are none listed. I need to...

Hello! I am trying to write some code so that a vlookup is automatically performed when a change is made to any cell in column A of a specific worksheet. Also, if the vlookup returns N/A, I want to leave the output blank, instead of N/A populating. 2 Worksheets, same Workbook: Population &...

I have an existing named range called 'MyRange' which is dynamic. I'd like to get a new named range using vba of all unique values in 'MyRange'. I'd prefer not to have the unique values listed anywhere in my spreadsheet. Here is the code for the named range MyRange: With Sort k =...

Hello everyone I have a worksheet that has multiple columns, e.g.: a b c d e 1 2 3 4 5 6 7 8 9 0 What I need to do is 'find' columns B and D and create a new column: a b c d e f 1 2 3 4 5 =2/4 6 7 8 9 0 =7/9 I am trying to use this macro to find each column (one is called MtM/D): Dim...