Hi everyone,
So I'm creating a tracker for a project at work. I'm tracking communication with a group of companies (sales). Anyway, I'm using the first worksheet (i.e. the one on the far left) to keep a summary of the last communication I had with the company. Each subsequent worksheet contains all communication with an individual company from the list contained in the first worksheet.
What I'm trying to do is connect a cell from the main summary worksheet to the last cell with data in a column on one of the subsequent worksheets. The reason I want the last cell of data is because I want to be able to look at the main worksheet and see the last communication I had with any one of the companies that I'm communicating with. If this doesn't make sense, please let me know and I'll clarify! Thanks so much!
So I'm creating a tracker for a project at work. I'm tracking communication with a group of companies (sales). Anyway, I'm using the first worksheet (i.e. the one on the far left) to keep a summary of the last communication I had with the company. Each subsequent worksheet contains all communication with an individual company from the list contained in the first worksheet.
What I'm trying to do is connect a cell from the main summary worksheet to the last cell with data in a column on one of the subsequent worksheets. The reason I want the last cell of data is because I want to be able to look at the main worksheet and see the last communication I had with any one of the companies that I'm communicating with. If this doesn't make sense, please let me know and I'll clarify! Thanks so much!