You are reading a single comment by @hugo7 and its replies. Click here to read the full conversation.
  • 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.

  • Or maybe there's something with the Group / sublevel / subtotal function which would make the same effect. I forgot what it's called.

  • 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.

About

Avatar for hugo7 @hugo7 started