Afternoon,
I'm currently working on a spreadsheet and need the final piece of the puzzle if anyone on here can help.
I need a code for the below
Search term would be the active worksheet cell "B2" (this will change to search a different term)
Search column "N" on all sheets, new sheets will be added regularly and it needs to search these as well, for a match to the search term of cell "B2"
If a match is found, then copy cells "N" to "Y"
there may be multiple matches that need to be copied on each sheet
Results to then be pasted onto the original sheet from cell "B5"
Any help would be great, I've been looking through Macros all day trying to find one that i can change to work but haven't got anywhere
Many Thanks
Mark
I'm currently working on a spreadsheet and need the final piece of the puzzle if anyone on here can help.
I need a code for the below
Search term would be the active worksheet cell "B2" (this will change to search a different term)
Search column "N" on all sheets, new sheets will be added regularly and it needs to search these as well, for a match to the search term of cell "B2"
If a match is found, then copy cells "N" to "Y"
there may be multiple matches that need to be copied on each sheet
Results to then be pasted onto the original sheet from cell "B5"
Any help would be great, I've been looking through Macros all day trying to find one that i can change to work but haven't got anywhere
Many Thanks
Mark