lanhao
05-14-2006, 12:59 PM
Hi there,
I've been recently asked by some people at work to put together some forms in Excel to help with keeping track of things and documentation. I currently am working on a sheet where I need to actually have the sort dependent on two piece of information instead of one (specifically the month in question and the name of the person). I honestly am stumped as to how to make it look for both variables, adn only pull the information on those specific rows. I have the base code in place for the actual entry of the data, but I can't for the life of me figure out how to have it do the two lookups.
Any suggestions/guidance would be greatly appreciated.
I've been recently asked by some people at work to put together some forms in Excel to help with keeping track of things and documentation. I currently am working on a sheet where I need to actually have the sort dependent on two piece of information instead of one (specifically the month in question and the name of the person). I honestly am stumped as to how to make it look for both variables, adn only pull the information on those specific rows. I have the base code in place for the actual entry of the data, but I can't for the life of me figure out how to have it do the two lookups.
Any suggestions/guidance would be greatly appreciated.