Hi All,
Any help with the following is appreciated.
I'm using excel for purposes of an IT asset audit. I want to set it up so that when entering make/model of a computer i.e. Dell, the entries of 'destop' and 'workstation' are entered in adjacent columns automatically. Also, is it possible to have validation data lists on a different workbook from the actve sheet and have these linked in some way. Hope this makes sense and someone can help.
Thanks,
Steve
Any help with the following is appreciated.
I'm using excel for purposes of an IT asset audit. I want to set it up so that when entering make/model of a computer i.e. Dell, the entries of 'destop' and 'workstation' are entered in adjacent columns automatically. Also, is it possible to have validation data lists on a different workbook from the actve sheet and have these linked in some way. Hope this makes sense and someone can help.
Thanks,
Steve