Forum Discussion
auto-fill preset content (not sure if the labels are right)
Cell A1 is the header, cell B2 is the subject of this discussion.
The aim is for as soon I start typing 'SOMETHING WRONG' in cell B2 after the template text cell B3 immediately creates a new row populated by the same template text.
And once again with cell B4 when I start typing 'SOMETHING ELSE WRONG' in B3.
Naturally its required that an entire row is created to avoid overlapping with the next header.
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
- Thanks for your help however I managed to find a somewhat limited but functionally sufficient solution. Select ten rows below each header row, click 'Insert', go to the Data tab, from the Outline section, click 'Group' with the newly inserted rows. I only get eleven rows for each section but honestly my boss'd probably be of the opinion that thats still too many. Underreporting is not something I'm likely to be accused of. Thanks again.