Search results

Hi Narayan Beautyfull, everything checks out. I can not thank you enough. Yours truely Jayzon

Hi Narayan If i type a non excisting item number and search, i get a run time error 13, type mismatch. The hick up seems to be here. If match_found = 0 Then MsgBox "Item Number " & Sheets("Sum").Range(aSource(0)).Value & "has not been found on any tab", vbExclamation Exit Sub Jayzon

Hi Narayan Just got home from work, i have checked it out. I have not found any problems, a very nice job indeed. Thank youu very, very much for your time and interest. Yours truely Jayzon

Hi Narayan Its fine you have already put in much more time and efford, than i could have hoped for. I have to go to work now. Thank you very much for your help. Jayzon

Hi Narayan All item numbers are unique, and should if possible only be in one rowtab. Yes if there is only one entry in the entire workbook with a specific item number , i will search the item number and change the row and possibly one or more of the ok tabs and then press send. I get your...

Hi Narayan If i understand you correctly yes to 2. 1.It can not be dublicateded in more than one rowtab. There can be double entrys, but only in one rowtab and all the ok tabs. Now every time a send is made the same item gets an extra row in the ok tabs. I think one solution is to...

Hi Narayan It works beatyfull, but there is a couple of details though. When search i have to enter data in both C3 and C5, the C5 meens i have to know where item is in advance. When i update any cell, the data is still in the old row sheet so if i change row to 2 and send its entered in...

Hi Narayan I have latest changes in the workbook that is in drop box now, i made the headers in all sheets. If i enter an item number in C3 and press search it is to change the row or other cells of the item, so there will be data in C5 and when i then press send the data should be send to...

Hi Narayan There is a search and send button in the summary tab in my sample. The header will be the same in the Stand , Pre , Cam , Scan and An tab and data send here is to stay stored here and not included in the search, the search is only for the row sheets. You might be right about the...

Hi I am pretty new at this, so i have tried to modify code i have found online, and it works ok. But i would like to make it a bit more advanced. I want the data in the summary sheet to be moved to specific sheets based on the row cell, so if the value in the row cell is 1 its send to the...