fenway Posted March 11, 2008 Share Posted March 11, 2008 I'm pretty good with excel, but not with VB script. I have a drop-down list populated from a named range (say, of names). Upon selecting a name from this list, all of the other fields on the page get updated from the master worksheet. Here's the goal -- I want to be able to print off a copy of the updated values for each person in the dropdown with one click of the button. There are 50+ people, I don't want to have to click the drop-down each time, hit print, and repeat, 50+ times. Seems like it should be easy to do with a script that either (a) iterates though the list and prints each one or (b) iterates through the list, makes a new sheet in a new workbook with the values only (no references), and then print that entire temporary workbook, with 50+ sheets. Personally, I think (a) is very easy, but I'm sure screen updates and print queues are invovled. HELP! ??? Quote Link to comment Share on other sites More sharing options...
effigy Posted March 11, 2008 Share Posted March 11, 2008 Is VB Script required? Perl's Spreadsheet::ParseExcel might have some offerings. Quote Link to comment Share on other sites More sharing options...
fenway Posted March 11, 2008 Author Share Posted March 11, 2008 Is VB Script required? Perl's Spreadsheet::ParseExcel might have some offerings. In this particular instance, it has to stay within excel... but that module might come in handy another time.... Any other takers? Quote Link to comment Share on other sites More sharing options...
fenway Posted March 14, 2008 Author Share Posted March 14, 2008 Really? No one? The one time I need help ;-( LOL Quote Link to comment Share on other sites More sharing options...
freakus_maximus Posted March 14, 2008 Share Posted March 14, 2008 It's been a while since I did anything with VBA (Visual Basic for Applications) that is built into Excel, but I think that actually might be more than you need. It sounds like you might need to do this on a regular basis, not just this one time, correct? If that is the case, then I think you can simply go to "Tools", then "Macro", then "Record New Macro". This will allow you to walk through doing this manually once (through all 50), then save the macro and run when you need to. If that doesnt help, I've used http://www.ozgrid.com/VBA/ previously to learn or find a solution to what I was needing. Hope that helps, espcially for all the help you have provided. Quote Link to comment Share on other sites More sharing options...
fenway Posted March 14, 2008 Author Share Posted March 14, 2008 Unfortunately, the list changes... but yes, I guess I could right a macro that compensated for that. Quote Link to comment Share on other sites More sharing options...
roopurt18 Posted March 17, 2008 Share Posted March 17, 2008 Really? No one? The one time I need help ;-( LOL I find that once you reach a certain level of competency the questions you post are unanswerable by almost everyone. Quote Link to comment Share on other sites More sharing options...
fenway Posted March 17, 2008 Author Share Posted March 17, 2008 Really? No one? The one time I need help ;-( LOL I find that once you reach a certain level of competency the questions you post are unanswerable by almost everyone. No kidding... I think I've posted maybe 10 times total, and I'm 0-for-10. Maybe we need a "superfreaks" forum ;-) Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.