lynette1953
New Member
- Joined
- Jun 7, 2019
- Messages
- 3
I am having difficulty finding the best way to link cells from one sheet to another. I want to keep the rows together and only transfer info that has a blank recovery date. I have Columns B-L and 305 rows. In Column B, I have Dates of Service with other identifiable info in the columns to follow. I need to only link the rows that do NOT possess a Recovery Date (Column J) and is blank. Those are the tickets that are still missing. I want to link those missing tickets and their corresponding rows to another sheet. I've explored Advanced Filter options, Get External Data from Other Sources, and have experimented with different formulas that I have found online. Nothing seems to get me what I'm looking for. To add to my frustration...I tried to find a way to attach a screenshot on here to no avail. I am very new to VBA codes and the world of advanced Excel techniques and could really use the help!!!