Search results for query: *

Hi Can you have 2 codes in one Worksheet? I have one code for searching for data starting with Private Sub Worksheet_Change(ByVal Target As Range) Then I've added another code which adds the date automaticlly in cell AK starting with Private Sub Worksheet_Change(ByVal Target As Range) Both...

Hi PH Tried and tested. :o) Excellent!! Thanks guys

Hi Geoff That worked just fine. I've learned quite a lot from your code, changing the figures and seeing what changes are made in my (test) spreadsheet However within my (real) spreadsheet each User will have 1 or 2 workstations and 2 monitors all of which are asset tagged so how can I Target...

Hi Skip and Eveyone else for that matter. I've had a look at the link and a few threads within but I'm none the wiser... When I put the asset tag number into column H do I always have to type =Lookup **(asset tag number)*** etc. I just wanted to type the asset tag number in column H and cells...

Hi Everyone Wonder if you can help me once again. In Worksheet 3 Lets say I have 3 columns, Their headings are Asset Tag, Serial Number and Mac Address under each I have 150 entries. When In worksheet 1 and I enter the Asset Tag number into column H, how do I get excel to search all the Asset...

Hi Guys I like to thank you all for your replies to this Thread. To be honest going through my worksheet again trying different variations to acheive my goal it finally cliked that I was making a schoolboy error... I could try and explain what I was finally tring to accomplish and try to...

I tried again... Failed. I had two more attemps at this. One in a new worksheet and one in a new workbook but in both attemps when I sort the list of names the hyperlinks associated with each name remains in its original cell while the names move to its alphabetical location... Can anybody...

Thanks Skip I will do a second (Test) worksheet and see what happends. I'll come back to you with the results. Aspesim

HI Skip The first sheet only has the names listed in coloumn C (Not sure why I put them in coloumn C, I guess just to make it look better). The hyperlinks are also in Coloumn C. If Cox, Peter is in cell C5 so is the hyperlink. when clicking on Cox, Peter's name it should go to another...

Hi Skip Thanks for your replies. However when i make a change in coloumn A it stills updates the (Now)/ date cell although I made the Range("B:L"). Also any changes to cells after coloumn L updates the (Now) / date cell? Aspesim

Hi Mint No good!! I only have one coloumn with text in it (coloumn C) When highlighted it still doesn't keep the hyperlinks in the right cell... Aspesim

HI Guys I have a worksheet in Excel which has a list of names in coloumn C. Each name has a hyperlink attached to it, which when clicked on will give me more information for that paticullar person. I can insert and delete rows and the hyperlink will move accordingly with the cell number...

Thanks Skip it worked just great. However: What do I enter if I want column A and all columns after L to be exempt from the automatic date entry? Kindest Regards Aspesim

Thanks Skip Hi Guys To say I'm newbie at this is an understatement. I need to know how to add the date (say in coloum L)in MS EXCEL on which the row (A - K) had been last modified. I've read some threads on this but I don't understand them. First of all where would you enter the code...

Hi Guys To say I'm newbie at this is an understatement. I need to know how to add the date (say in coloum L) on which the row (A - K) had been last modified. I've read the above but don't understand it. First of all where would you enter the code. 1 step at a time I guess so please be...