• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Effectively searching for a record that meets certain criteria (URGENT)

V

vicmoment

Member
Sample data:


DATE REQUESTED STAFF NAME GRADE TAG SIZE RETURNED DATE STATUS

16-Nov-11 Akan anam Analyst Vic02 340GB 18-Nov-11 Returned

16-Nov-11 manam ana SenAna Vic01 320GB Not available

16-Nov-11 margot truska SenAna Vic03 250GB 17-Dec-11 Returned

16-Nov-11 Jand Tyron Admin Vic04 500GB 14-Nov-11 Returned

11/16/2011 20:55 talop polit Ast Vic03 250GB 20-Nov-11 Returned

11/16/2011 21:43 polit lipog MasAna Vic02 340GB Not available

11/16/2011 21:44 fupa ture Ast Vic03 250GB Not available

11/16/2011 21:44 tuba killa SenAna Vic02 340GB 23-Nov-11 Not available


What i want to achieve is to be able to effectively search for a record. Say for example,fupa ture comes to return the hard drive, i want to be able to key in her name into a cell, the hard drive name in another cell and probably the status in anoda and get excel to take me to the particular row that meets these criteria.


on sheet 1, say i have Name: fupa Ture

HardDriveTag: Vic03

status: Not yet returned


I want to be able to click a button that goes to that record on the database above. Am sure a macro can achieve this but how?


Please help


Thanks
 
Why not just use an AutoFilter? Would take similar amount of steps...filter on fupa Ture, then hard drive tag. If need to filter further, filter on status column.
 
Thanks Luke for ur suggestion,


If i had say 300 records like that and say from the sample data uploaded, pord Nuban returns the hard drive, i would like to be able to access his record straight up simply by knowing his name and the hard drive tag and status as "Not yet returned" to update the return date.


A filter will be able to achieve this, but how can I have a button that can do a "Go to reference" so i can easily enter the data.


https://docs.google.com/document/d/126vG6nxYMP6pY3FkbmOq9aufBS9VdCpWnuZIk-ntDnw/edit


Thanks, hope my explanations are clear
 
I guess I'm still not seeing the down side to using a filter. You'd have less criteria (possibly) that you have to enter, and it takes you to the correct line so you can enter data. Can you clarify what part of the filter you don't like, or doesn't work?
 
I have tried the filter like you suggested and I would say that it works quite well. So what I did was create a button that would filter and another that will remove the filter. So i would say it works quite fine.


Thanks so much for your help.
 
You must log in or register to reply here.
Back
Top