Hoping someone can help.
I need some code to do the following. If cell A1 contains the word Torrified then I want to place the contents of cell A2 in A1 of a sheet called TorrOpex. However, if cell A1 contains the words High Energy then I want to place the contents of A2 in a sheet called HEOpex. There may be up to ten sheets to be populated this way. if someone can provide the code for these two sheets then I can amend the code accordingly.
Many thanks in advance for your help.
Bookmarks