I am an HR Director and need a lot of information for my monthly reports. I am wanting to have all of my data on one sheet and make formulas to auto-populate in the other sheets wherever needed.
An example would be:
On Sheet one, I would have employee names in column A and training month in column B.
So on sheet two in a cell, I would like to copy over the employees name if the training month is November.
Please explain as much as possible the formula.
Note:I used a month as an example, I have other categories that I cannot put into numerical value.
I really appreciate this!
Bookmarks