I work in property for 23 different hand receipts. Currently I have one spreadsheet that has the information for all 23 hand receipts in one big list. What I want to do is set up multiple tabs which would all reference data in the main tab. Each tab would only pull data which has a specific customer ID, and would do this automatically. That way I can pull up the main list for all 10,000+ lines, or just click on the hand receipt tab which I want to view. I understand that I can just filter a column to do the same thing. But, my concern is to screw up the main tab accidentally by doing so.
Here's an example of what I'm talking about. Below is what is in my main tab.
Column A Column B Column C
12345 Red Pen Y86ABZ
34565 Blue Pen Y86ACO
23409 Black Pen Y86ABZ
What I want to be able to do is search Column C for "Y86ABZ". If the cell has that information then in a seperate tab it would display the information from Column A and Column B for that row.
Issue is, how do I do a line by line cell search for Y86ABZ out of the other possible 23 codes. to display the information i want. What I mean is since Row 1 has the correct answer it would display that information in the first row of the new tab. Since row two does not have the correct answer it would be skipped. Which then means the main row 3's information would be displayed in the new tab on row 2. It's confusing I know. I can picture it my head. I just cannot figure out the formula.
Bookmarks