Good Morning,
With the above code (it has an error) but it was a bit of research and a bit of guess work to try and achieve the following:Please Login or Register to view this content.
Search cells C:E for a value, if it occurs in any cell to then create a new worksheet named of the value. For example
Surname Forename Option 1 Option 2 Option 3 Smith John 1 6 25 Bond James 25 29 9 Hunt Ethan 6 17 12
If I was to type "25" in the inputbox I would need it to copy row 2 & 3 and name the worksheet "25"
Hope this helps
Thanks
Ashley
Bookmarks