Search results

Thanks - downloaded newest and it now gives pop-up warning when I enter only matching data. (server1, server2, server3 and server4) - if I type in server555 it does not appear! YAY!! MUCH APPRECIATION AND GRATITUDE!!!

:-) SirJB7 - ya, great idea - at least we'd get some stuff in a timely fashion. On a more serious note, it seems that the popup comes up even if there is not a matching server name. I am looking through the code and not sure where I would do the matching function, or how to do it. How does...

As far as our dev guys - well, I cannot wait for them to get to this, so I had to ask the experts who I know can come up with several ways to tackle the issue and not take 6 weeks - YES, 6 weeks for them to even acknowledge I made a request! Way beyond running "lean and mean" these folks are...

SirJB7 - thanks! Ya, got the data all standardized as text to alleviate the number issues that can crop up. I will take a look and give it a try. Much appreciated!!

Hi folks, (apologies for the long post, but the 'stickies' say give as much detail as possible, so... I did...) I am working on a firewall configuration form. In that form (Sheet1), the person will enter in 1 or more server names and an IP address for each server, one server and IP per row. In...

Montrey - I went with =MATCH(C2,servers,0) - even if there is not match, Excel 2007 seems to be OK - no errors.

Hi folks - J here. Been an Excel tinkerer for some time now and have used chandoo as a resource from time to time to unwind my messes and to learn new techniques. In Northern California, working for insurance company, evil, I know! I am doing more data analysis and such, so expect to see me...

SirJB7 - thanks for the guidance - you're right, I jumped the gun a bit. I will take a look at the stickies, though I did do a search and could not find what I was looking for, but then again, I am not sure I know exactly what I was looking for. :-) That said, I think I have a solution, but...

For some reason Conditional Formatting won't let me set range to a different worksheet... Error: you cannot use references to other worksheets or workbooks for conditional formatting. BUT - if you name the ranges, then it accepts the formula. THANKS!!

Hi - I am trying to do something that is probably simple, but I am struggling with exactly how to accomplish it. I have two worksheets, both in the same workbook, Excel 2007, and the first worksheet is for detailing firewall changes. The second worksheet is the list of all the servers that...