Forum Discussion
auto-fill preset content (not sure if the labels are right)
OK. See the attached file for a slight variation on your layout, one that uses Excel's data validation tool to create consistent sub-headings in column B, with your details in column C. It will end up looking like this:
What I've done is create a "data validation" list on sheet 2, and in that list you'd put all the locations. For example:
What this does is give you a drop down selection for column B, which gives you a choice if you need to start designating work in a new area, looking like this
I've formatted column B that so it's in a slightly larger font and bold, so it stands out as a sub-heading.
But you only need to enter it once for a building if there are multiple floors or buildings to be reported on, because in column C, far as many rows as you need, you describe the various tasks
