Any workaround to have a range name start with a number?
I have a few worksheets that I need to create dependant data validation lists for but one of them has numbers in the 1st list. Since it's critical that the range name for the dependant 2nd list match the value in the original list, I'm hoping there is a
workaround that will let me name the range with a number.
If not ...
is there a way I can allow them to enter the number & programatically prefix it with a letter so it'll be invisible to the user but still satisfy the range name format so it can pull the second list of appropriate values for them to choose from?
Don't know if that's even possible.
The first list doesn't have to be a drop down if that helps. There will be so many items in it that we can keep it as a straight data entry field if that helps resolve this.
Thanks for any help you can give me with this!
Keys to the Problem Any workaround to have a range name start with a number?
Suppose in your primary validation list, the entry is 123
The constituents of 123 (which should appear in the dependent validation list) are 123.1, 123.2 and 123.3 (these appear in range D10:D12)
Select D10:D12 and assign it a name as A_123
In the secondary validation cell, enter this formula in Data > Validation > List > Source
B2 is the primary validation cell where you have selected 123.
Hope this helps.
Check if there are memory problems
Memory management issues can also cause a BSOD in Windows 7. Thankfully, Windows 7 has a Memory Management Diagnostic tool that detects and solves problems related to system memory.
- Click on the Start button on the Taskbar.
- Type "Windows Memory Diagnostic Tool" or "Memory" (without quotes) in the Search box or,
- Click on Windows Memory Diagnostic Tool (in the search results).
- Click on "Restart now and check for problems (Recommended)".
- The system will restart, and you need to follow the instructions given on the screen.
Recommended Method to Fix the Problem: Any workaround to have a range name start with a number?:
How to Fix Any workaround to have a range name start with a number? with SmartPCFixer?
1. You can Download SmartPCFixer here. Install it on your system. When you open SmartPCFixer, it will perform a scan.
2. After the scan is done, you can see the errors and problems need to be fixed. Click Fix All.
3. The Fixing part is finished, the speed of your computer will be much higher than before and the errors have been fixed.
Related: error message fsui.exe/ wlidcli.dll is missing
,Solution to Error: Excel: Automatic number generation
,Troubleshoot:i wanna change language of all windows in Windows 7 Home Premium
,Troubleshooting:IF Function, if the vendor ID in column A matches any of the vendor ID's in column F, I want 1099 to appear in column D. Error
,Fast Solution to Problem: ReadyBoost is not working properly in my computer
,Troubleshoot:Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive. Error,External Hard Drive not listed in Windows 7 backup wizard Tech Support,Tech Support: I'm always being signed off so annoying,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.,Referencing data in Access using Excel [Anwsered],Need Best Way To Present Data [Anwsered],Same question but for windows 7 home edition,sometimes fullscreen won't activate [Solved],Solution to Error: We bought a new computer with windows 7 and it is constantly freezing. How do we fix this?,Solution to Error: Windows 8 update crash (2013-07-22),brclr.dll.mu_ Missing Error Fixer,How To Resolve Missing fin_myagtui.eng Problem,Corrupted f_0006ad File - How to Fix,nkebigvg.cpl Not Found Error Fixer,Corrupted olcontrols.ocx File - How to Fix
Read More: Troubleshooting:Amazon Unbox won't play video's \"error code 0xC00D2728\",An unhandled exception - Error 0x1A88 [Solved],Fast Solution to Problem: An old version of Microsoft Project,[Solution] an unspecific error has occurred. Your request cannot be processed at this time. Please try again later. (0x80070001),Tech Support: Analysis Toolpak not accessible from data tab of ribbon in Excel 2007.,After Windows Update CD/DVD drive does not work,After installing windows 7 to laptop the labels print out of line how can I fix it,After my computer sleeps the wireless always disconnects and will no reconnect,After signing into Pogo.com, I get a message" This tab has been recovered"....what does this mean and how do I fix it.....,All desktop icons changed to windows live and does not open