I, and colleagues, apply for leave using a Word template.
Unsurprisingly, we have to enter the start and end dates, in cells in a table. Towards the bottom of the page we have to enter these same dates in a different table.
This Word Doc is emaile dto our admin people, who approve it, (or otherwise!), and print the form off, rip off the bottom bit and place that bit in our postbox. Reciept of this means that we have the leave approved, and have written confirmation...
Regardless of the efficiency of this system, it's what we have...
I wonder if there is a way to have the "cells" in the lower table have the entry made automatically, using a formula. Obviously in Excel it would be easy. Can this be done? Bear in mind that it's in a different table, and I am looking for a formula, NOT a macro.
Folk create a new doc by clicking on link to template, fill it in, save it to their local storage an email a copy to dept admin. They can even, if they wish, make there own personal template with personal details filled in.
I'm just trying to obviate the need to repeat date.
Why do you think emailing it would be a problem? Am I missing something?
I agree with Jackcoms. Other than that you could copy the top table/rows and then paste it/them into the bottom bit that they rip off and give back to you. There doesn't seem to be the option to insert text with a formula in a Word Table
Thank for that... I can do that very easily... I was trying to avoid it as almost everyone has a shortcut to a Word doc/template. (In fact since starting this, the shortcut has appeared on an internal Intranet site as well)... though I may go down that avenue.
lotvic and daba... Thanks for those thoughts, I'll look further into it...