Hi, I am new to Marcros and I need some help please. I created the attached spreadsheet. The Input tab is the one that I will be adding new details to and the Output tab will pull the information from the Input tab. I have a drop down on cell C17. By selecting diferent values there the information on the Output tab will change. The values under the dropdown are the values in column A on the Input tab. I need to assign a Macro (I think Macro is what I need) to the Print button that is located on F2 on the Output tab. I managed to create a Macro for printing the curent worksheet. But I need a Macro for printing multiple worksheets. For example, if I input information on rows 4 to 10 on the Input Tab, I would like to be able to print the Output worksheet for all of them together instead of selecting 4 on the C17 dropdown, print, then selecting 5 on the dropdown, print and so on until the last one I have updated. I hope I am explaining this well. In other words, when clicking on the print button I would like to see an option to select from 4 to 10 for example and then everything to print together.
Please let me know if further clarification is needed. Many thanks.
Bookmarks