Hi! Excel novice and I’m trying to figure out how I can get data from one master log to automatically flow into a separate worksheet based on the "state" designation. So, whenever I am on the master log worksheet and I enter something for PA I would like that entire row to automatically show up under the PA tab as well. I realize filtering is a quick fix but I’d like to be able to see the info on different tabs. Is there any easy way to do this?
Thanks!!
Brittany
Bookmarks