Hi. I need a macro that allows me to enter data for different departments that I generate using data validation lists. I set up a column for months, another for day and finally one for product. Each column has a data validation list the user can then choose to select entries. Once the entries are made. the user inputs the data that's based on the month and the day it's entered for. Once the data is then input...the macro should then clear the input row of that data allowing the user to input new data based on the validation selections. Can this be done? I've attached a sample spreadsheet showing what I mean. Any suggestions would be greatly appreciated.
Bookmarks