asked

I am working with an Excel workbook that has three sheets: (1) Enter Data Sheet, (2) Data Base Sheet, and (3) List Sheet. I need to enter daily information for employees into the Enter Data Sheet and transfer this data to the Data Base Sheet using command buttons. Additionally, I want to regenerate previous day's information into the Enter Data Sheet for each employee and add new day's information to the Data Base Sheet. At the end of the week, I need to select an employee and the week from drop-down lists to populate the Enter Data Sheet for printing. Should I use VBA/Macros or Data Validation for this, and how can I achieve this functionality?

February 9th, 2024

Sign Up to View Answers

Create an account to view answers and interact with the community!