Hello,
I'm working on a report that contains rows with employee names their job titles, locations, department in which they work, and a number to specify a category (1-49).
I have created individual sheets labeled 1-49 and am looking for a way to automatically insert the entire row in which the number in row G matches match the active sheets name.
Attached is a small excel sheet to demonstrate what i am trying to accomplish
Thank you!
Bookmarks