Hi!
New to the forum. I've been using Excel for a long time, lotus 123 before that, but have only a very shallow understanding of it. I have a large excel sheet with tabs for each week, it's used for my business to monitor weekly financial activities. It has turnover & profit information per client on each tab. What I want to do is have a separate tab that monitors which clients we are currently working with as a way to isolate with who we're having a downturn and redouble efforts to chase them up. It would also be handy to be able to tell when we last worked with them. Basic look of the sheet is below, I'd like the formula in the "current" column to search through the tab referenced by the cell adjacent to "week ending date" (set to 10/03/2019 for this example) and check if the client name in the "name" column appears. The client names are all in the same column on each tab, the tabs of each week are a copy of each other just with the raw data changed. If so, it'll return "Yes" and if not "no". Then, if the "current" column is returned as "no" the formula in the "Last interaction" column will then go through the other tabs (max 52 for a year) until it finds said client and inserts the date from that tab in the cell. Is this at all possible or am I totally dreaming? I obviously am unable to send anyone the actual excel sheet as it contains a large amount of personal data for my candidates and clients but please ask if you have any questions that will help resolve.
Many thanks,
Lewis
Week ending date 10/03/2019
Name Current Last interaction
Client 1 Yes Current
Client 2 Yes Current
Client 3 No 17/02/2019
Bookmarks