Hello, a mediocore excel user, I work in a call center and have been asked to log all my calls in a master sheet by case number and my name. I also like ot have alist of my own calls, so I can add more information myself. I have about 4 other people using the master sheet at this time. What i am looking for is a function that will automatically search through column A for my name, if it finds my name I want it to display the value in colomn b of that same row.
I have done this with an if funtion that compares a1 to a cell with my name in it, if it is true it shows b1, I then fill down this formula a few thousand lines and then it shows me all of my entries, but when it comes across someone elses it shows a blank. I want just mine to show up either by deleteing the blanks, or by searching column a for my name and only siplaying column a. Is there a way to do this maybe using a VBA script?
Thank's
Bookmarks