I hope that this request is posted in the correct group and someone can assist.
A simple spreadsheet with 2 worksheets. The first is a predetermined list of 100 members names whilst the second contains a number of columns containing various pieces of information relating to the members. For simplicity, the headings are 'member' & 'information'. The 'members' column selects from drop down list, validated by the list on the first worksheet. New information is added onto the last row and I have an active filter so at any given time i can filter based on the member to show what information relates to them (possibly running to many items) What I would like to do is include a print facility that, with the click of button / macro run, would run through the members list (sheet 1) then filter (based on sheet 2) & print individual members information to a PDF (or similar) with the file title being that of the member. I'd end up with 100 members documents. This is the simple version as, in reality, the 2nd sheet runs to many columns and i realise that i may end up with a number of files containing nothing if there is no members information present. I can visualise what i want to do but I'm totally new to VBA Macros and may have offered a solution to a work colleague that i don't really know how to achieve. Thanks -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe from this group, send email to excel-macros+unsubscribegooglegroups.com or reply to this email with the words "REMOVE ME" as the subject.
