Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Aspesim
  • Content: Threads
  • Order by date
  1. Aspesim

    Error using two codes whtin the one worksheet in Excel

    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...
  2. Aspesim

    Search worksheet 3 and return the information in worksheet 1 in Excel

    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...
  3. Aspesim

    Excel Hyperlink Querey

    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...
  4. Aspesim

    How can I change the date automatically when a row has been updated

    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...

Part and Inventory Search

Back
Top