User Profile
Gekkouga
Brass Contributor
Joined 6 years ago
User Widgets
Recent Discussions
Creating named range from cell values
Hi, I have some lists and each of these lists has sub-lists. I am trying to create conditional data validated cells i.e. the validated list on the second cell should change depending on the value selected in the first cell. I realised that the easiest way to do this is by creating named ranges of the sublists creating a data list with the main-list and sub-list name on the worksheet using vlookup on the first value with the data-list as a range Finally, using the result of vlookup (the named range) though INDIRECT in the data validation window. Everything works fine but the problem is, it is really cumbersome to create a named range for all the sub-lists especially when there are hundreds of them. Since I already have the name and the range listed on the sheet, I was wondering if there is a way to create a named range automatically from this data instead of entering it manually in the name manager.Spin off Edge PDF reader as a standalone app
Any thoughts on spinning off the PDF capabilities of Edge as a separate app like the Windows 8 Reader app. I have a lot of PDFs and open them all simultaneously. But using a complete browser for PDF reading is such overkill and is not only memory intensive with all the extensions but also drains the battery fast. Instead, a standalone offline PDF reader will make the process much more efficient and a browser plug-in can be used to open PDF inside the browser just like Adobe does. I seriously want to use Edge's PDF capabilities especially with touch and inking but the memory utilisation and battery drain issues are forcing me to use the subpar experiences with Adobe and Foxit.
