Hello All,
I was wondering if there was a way to insert a formula for my macro to refrence another sheet and pull all Names under the dates of certain years.
For example: GS 2019 BP 2019 GP 2019 GS 2020 BP 2020
The Name "GS" or "GP" or "GS" are in a separate cell from the data in sheet2 I am poulling from the dates would be on E and G, and Names will be in K. I will need to be able to have the lists with data validation list starting in sheet1, I would need all years seperated so : 2019 = GS, BP, GP 2020+GS, BP
I was thinking of using
but unsure
Thanks, for any help
Bookmarks