-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
invalid data
-
D
hyperlink w/in excel loses reference
hyperlink w/in excel loses reference this is the situation person cell id hyperlink Adams b20 b20 Jones b50 b50 Zilch b99 b99 If I create a hyperlink at Zilch to Jones the hyperlink = b50 then if I add a person above Jones (b50), the Jones info moves down and...- dueker1
- Thread
- cell id hyperlink address invalid data
- Replies: 3
- Forum: Excel Questions
-
Q
Creating an "Invalid Hyperlink" warning
I'm looking for a list of characters that are invalid in a hyperlink address (at least as far as Excel is concerned). I have a form where the user can input a hyperlink address, and through VBA convert it to an active hyperlink. I've discovered that if the address has invalid characters (such...- quackdad
- Thread
- hyperlink invalid data
- Replies: 0
- Forum: Excel Questions
-
A
To Filter move out the Invalid data to a new sheet.
i have two sheets. Sheet 1 list contains orders & part nos. While the other contains the part no which are in stock. the format is as shown below. Sheet 1 Order no Part 1001 x 1002 y 1003 z 1004 x 1005 a Sheet 2 Part no Stock x 1 y 1...- aramdc
- Thread
- data validation filtering invalid data
- Replies: 3
- Forum: Excel Questions
Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.
