austenr
09-28-2005, 12:43 PM
I need to be able to match a value on one sheet and if found, check every other month for that person to see if ther is a value for them.
What I need to do is this:
Start with sheet1 which is January. Move the employee number, last name, first name and amount to the summary sheet. Move to Febuary and determine if this person is on that sheet and if they are, move the amount for February to the February column on the summary sheet, etc. There can also be additions to a month and if that is the case move them to the summary sheet and then begin to look for that person on each successive sheet.
I think I can use the match function but have never used it before with multiple sheets. I have attached a sample for you. Would really appreciate some input. Thanks
What I need to do is this:
Start with sheet1 which is January. Move the employee number, last name, first name and amount to the summary sheet. Move to Febuary and determine if this person is on that sheet and if they are, move the amount for February to the February column on the summary sheet, etc. There can also be additions to a month and if that is the case move them to the summary sheet and then begin to look for that person on each successive sheet.
I think I can use the match function but have never used it before with multiple sheets. I have attached a sample for you. Would really appreciate some input. Thanks