Interesting concept, but a high overhead small volume system (because of the cell merging/formatting and that you keep a copy of the tables and a separate Name set on each Sheet).
HOW TO CONSOLIDATE DATA IN EXCEL 2003 HOW TO
There is an error with "Buckingham Palace" which brings up "N/A", as I said I'm no programmer, if you don't know how to fix it, then I'm sure someone will help. There on the same page as the validation list wouldn't allow me to have it on a different sheet - if anybody out there knows how to do that I'd appreciate you sharing your knowledge with me. The payroll information comes from the payroll number drop down list and the venue from the Venue list, which are both named ranges in the namebox. I have used vlookup and validation lists. Of course all payroll details are made up!! As you can see I'm no programmer that's why it's simple with no macros! but it might inspire you. I developed something similar for jobs and invoicing (that's why it looks a little like an invoice, but it at least shows other calculations). I've attached a file to see if this is the sort of thing you are trying to achieve. If you want a respectable looking print then consider Excel-to-Word, whereby all the calculations are performed in Excel, and the 'items' to be printed are passed to Word as described by in
If your print is a simple one that can be setup on a template worksheet and not become disjointed by the variety of data you have, then a simple loop which transfers row-by-row cells to the template and Prints the sheet should suffice, such a loop could be started by Tools, Macro, Record New Macro and perform the action of printing, then Stop Recording and Edit the Macro to add a loop. Your reply seems to indicate two things, that you have not yet attempted 'elegant' printing in Excel, and that you have not understood the concept of Excel-to-Word mail merge. Additionally, when first beginning this project it never occurred to me that I might want to be able to do this.Ĭan you (or anyone) direct me to any sources that might show me how to create such a macro?
The reason I am keeping it in excel is because of the complexity of some of the formulas involved (I am sure they are possible to compute in word, however, i am not as experienced in doing so).