Forum Discussion
auto-fill preset content (not sure if the labels are right)
What's eluding me in a clear understanding of what you are wanting the template to do.
Do you want it to work such that when ever you start editing ,
"...a new one that says the same thing is automatically inserted below making it so that no matter how many different notes I need for the 'Hoover building, third floor, East wing' I always have the template notes ready because they just pop into existence."?
Or is that what you don't want?
I find it entirely possible to read what you've written either way.
Another question, though: are you using Excel because it has cells, specifically cells organized in rows and columns? OR, are you using or expecting to use, Excel's capabilities to calculate, store data, retrieve data from tables, etc? If it's just the former, you might find creating a Word template just as effective. Maybe even more so, as you have a bit more flexibility with layouts.
mathetes You were correct with the first understanding. Let me try to diagram it here.
Hoover building, third floor, East wing, (text added to the template)
'poof' a new row is added below with the same starting text as soon as I began typing. Forgot to mention that I'm hoping to coot the entire row as soon as a cell in that row is edited.Hoover building, third floor, East wing,
I'm actually coming to Excel from Word. I get what you mean but there are just certain things that are not working for me with Word. I'm pretty sure that the columns and rows of cells in Excel will work well for me to organize the information.
Sorry. It's still not clear what you want. Your "diagram" didn't communicate clearly. Can you attach a copy of your workbook to a message? If you open the full text edit capability, you should see a place to drag and drop files.
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.
