I want to create a spreadsheet with a list of tasks for projects. Each tab would be for a separate project type. Based on the tasks selected on a given tab, the text from those selected cells would populate on a final tab all grouped by category to be printed or copied into a Word doc.
Fictional Example:
Tab Alpha
A1 Unbox item
A2 Place sticker on item
A3 Place item in bin
Tab Beta
A1 Prep box
A2 Pack box
A3 tape box
Final Tab (if Alpha A1, A3 and Beta A2 were checked would look like this)
Alpha
Unbox Item
Place item in Bin
Beta
Pack Box
Thanks for any help!
Bookmarks