-
I'd use separate tabs for the inputs. Ref tab with the standard stuff (name, position etc) with a unique ID for each person. If I had three attributes I wanted to document, I'd create a tab for each attribute and use the unique ref and name with columns for all the stuff I wanted to record. I'd join all the tables I've created in each tab using the unique ref and create a master data sheet in PQ which I'd copy and edit into the required outputs zooshed back into the spreadsheet with all the formatting etc. Basically a series of input and output tabs.
That's a really good shout.
I'd like to add it as a company template doc, hence wanting to make it look nice. Otherwise I'd just go with a windows 95 aesthetic.