First let me say that I get a little better with Excel almost daily by searching this board. The people on here are fantastic and all the help is greatly appreciated.
I ran into a unique problem that to me is just mind boggling a small problem I can't fix regardless of the what I do but it should work.
We have two ticketing systems at work. The first system anybody in the company can open up and once they do a triage takes place. If the ticket belongs to a certain system it is input into another system with its own ticket. The ticket numbers do no match and the descriptions can get a little lengthy. There is usually one or two key words in the description fields that match but not entirely. is there a way to have Excel read a cell in a column (say column A of worksheet 1) and have it read all the cells in column b on sheet 2 and compare the words in each description and if it finds ne or more matching words show a possible link in column X on sheet 1? I don't even know where to start on this.
The small problem that no matter what I do won't work. I have tried everything in this board and everything I can find on the net and no matter what I do I can't get userform1 to launch when the file is opened. For me it's not a problem to launch the form from VB but I don't want my users to have to launch from VB then Project Explorer then load the form then click on run. Is it possible that I have a setting I'm unaware of that is preventing this?
Sorry about doubling up. sometimes I get carried away and just can't stop.
Thanks
I ran into a unique problem that to me is just mind boggling a small problem I can't fix regardless of the what I do but it should work.
We have two ticketing systems at work. The first system anybody in the company can open up and once they do a triage takes place. If the ticket belongs to a certain system it is input into another system with its own ticket. The ticket numbers do no match and the descriptions can get a little lengthy. There is usually one or two key words in the description fields that match but not entirely. is there a way to have Excel read a cell in a column (say column A of worksheet 1) and have it read all the cells in column b on sheet 2 and compare the words in each description and if it finds ne or more matching words show a possible link in column X on sheet 1? I don't even know where to start on this.
The small problem that no matter what I do won't work. I have tried everything in this board and everything I can find on the net and no matter what I do I can't get userform1 to launch when the file is opened. For me it's not a problem to launch the form from VB but I don't want my users to have to launch from VB then Project Explorer then load the form then click on run. Is it possible that I have a setting I'm unaware of that is preventing this?
Sorry about doubling up. sometimes I get carried away and just can't stop.
Thanks
