Forum Discussion
Carrying information between sheets
Hi, I'm trying to set up a worksheet to track completed training within my team. The current format is one sheet with a list of all available training that can be complete, copied using =!sheet1!...
So much depends on how that "one sheet with a list of all available training that can be complete" is laid out. And you don't describe that. Is it possible--first ensuring that no confidential info is included--for you to post a copy of the workbook on OneDrive or GoogleDrive, posting a link and granting access here?
That aside, and depending on how that basic database is arrayed, you might find the FILTER function useful. Two links for you here:
- A YouTube intro to FILTER and associated functions
- A text-based explanation from ExcelJet