I'm working on a program that will generate an excel spreadsheet. I have two goals: Add data validation drop-downs to cells in sheet1 and use columns of data in sheet2 as the list of available values.

How to create a VBA procedure that closes all open workbooks in Excel Your email has been sent Some of us work with several Microsoft Excel workbooks open at the same time. Either we open them and ...