We have a bi-weekly timesheet in excel that we need to enter our daily work activities from a list of 33 types of activities. Each activity has a 4 column set of codes stored on the codes sheet that needs to be entered into the timesheet for our budgeting department to know where the funding comes. Manual entry and even copy and paste from one worksheet to another is resulting in many errors. I want to create a look up list that will allow the user to pick the work type and have the 4 columns fill in automatically from the codes sheet.
I tried using Data Validation but I can't seem to fill more than one column at a time and I want al 4 to fill with one selection .... Any ideas how to do this?
Thanks!
Bookmarks