I have a spreadsheet with around 20 tabs of different clients to call from each state. Often times I have to leave a note to call them back the next day or week. I need to create something that list out all of the cleints that need to be called back form the entire spreadsheet into one tab. I can make a new column called "follow up" and if I insert a date into it excel would pull a copy of that particular row with client info and add it to a list on the first tab. I am not sure what the name of the function is called? pivot table? list? follow up list? any ideas?
Bookmarks