invalid data

  1. 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...
  2. 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...
  3. 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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top