Totally new to the forum (hence the name). I'm hoping that someone is able to assist me.
I am hoping there is a way that I can assign a value to another value in a different column and apply it across multiple sheets. Here is what I am trying to do. I am trying to create a spreadsheet that allows our territory managers to view their progress versus years past in certain counties. The way I received the data has it broken down by county, but I would like to add a manager column so that I and everyone else can easily filter by the manager name.
For instance, Manager A is responsible for Washington, Alleghany, Frederick, and Carroll counties. In the current format of my data set, the County column has these county names. I would like to be able to enter a formula or function, that tells excel that everywhere Washington, Alleghany, Frederick and Carroll counties appears in the county column across multiple sheets, to then assign "Manager A" to the Manager column. Is there a way to do this or do I have to manually enter everything?
Thank you for your help.
Bookmarks