Hello
I currently have a sheet with 3 tabs on, tab A has a list of information on, tab B has a breakdown of 3 select items from tab A if they're present.
My issue is I need code to search through tab A to see if a certain word is in a table, and if so copy the data from tab B associated to it?
For example... if tab A has the word apple in a column, then the sheet would copy the breakdown of apple types in tab B to tab C.
Any help would be appreciated.
I currently have a sheet with 3 tabs on, tab A has a list of information on, tab B has a breakdown of 3 select items from tab A if they're present.
My issue is I need code to search through tab A to see if a certain word is in a table, and if so copy the data from tab B associated to it?
For example... if tab A has the word apple in a column, then the sheet would copy the breakdown of apple types in tab B to tab C.
Any help would be appreciated.
