search and delete

My present coding moves information completed on a UserForm to a Spreadsheet. Individuals may need to update the information submitted so if they submit another form, I require a search to happen by the PRI number and replace the old information with the new information. For example.... If the...

Hello, There are some cell that have a full stop (.) others not many of them have full stop (.) in the middle of the text, how can I delete all full stops at the end of cell only. Thanks in advance.

Hi All, I have some data which I need to sort through and as part of my macro, I want to delete rows which contain certain text. So for example, in column G if the word "Late" appears in cell G50, I want to delete row 50. From other threads I have found the below code which works, but I now...

I am working on an inventory list that allows us to keep track of every item that we have within our stock. Now Someone before me created this and it is up to me to continue it though I see numerous bugs that need to be addressed (when I say bugs I mean that certain things that should have been...

I'm a relativly new VBA user, so this may be a rather elementary question, but: Is there a way to search for a text string through the entire workbook instead of searching each page individually? My wookbook has 100+ worksheets with lots of data and calculation, and inputs new data as well...