you made that over complicated with so many confusing named ranges.
here is the solution you need. see attached.
test.xlsx
here is the solution you need. see attached.
test.xlsx
Title | # Comments | Views | Activity |
---|---|---|---|
How do I enter a formula in Excel to capture a part of text from a cell? | 7 | 27 | |
Excel VBA - need a reliable method for SendKeys Number lock | 4 | 36 | |
Dynamic Excel Countdown Graphic | 21 | 23 | |
Conditional formatting based on date | 2 | 12 |
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
12 Experts available now in Live!