Forum Discussion
Printing a document with data from a table.
I know this should be simple, but it's escaping me right now. In the attached file are 2 sheets. i want to be able to print the Master sheet with the data from the Names sheet/table. I really do...
Link to the tutorial your solution is based off on:
https://youtu.be/Ea_ACp5W8zI
Here is your solution. When you want to put the name, click on the Name textbox, and type the first few letters of the name then click the drop down toggle, if you are using the web version of excel the drop down list will just automatically drop down for you to choose the name:
to replace the names in the name sheet, just highlight all the sample names, then press delete then copy the actual names you need to use for your purpose.
enjoy!
- This was great Information. But, I am still not seeing how to achierve my goal of printing 1 weekly master notes for each and every individual on the names sheet. I havent actually tried to print it. I have just been using the print preview. Would that make a difference. Do i need to create a Word Document and use mail merge? I really thought doing it in Excel only would be simpler.
Why don't you make the form in a word document, attach it on this post, including the list of house and their occupants in them, and i'll help you create the word mail merge with the data list being in excel.
Cheers
- ok Thanks, I will try to get that done in next few days
- I was going to suggest MailMerge, in fact. That would be very easy; its whole purpose is to run through a list like that (and can be made much more complex in fact); in Excel you'd probably have to write a macro or VBA routine. It could be done. But with MailMerge, it HAS been done.
