Hi all,
I have 40 sheets with different name. In the 41th sheet, these sheets' name are listed as cells in ascending order (a to z). I want to compare these cell names with first 40 sheets' name and if the names are matched, returned a value of the matched sheet into the 41th sheet right side of that matched cell.
I guess it is more understandable if i attach an example excel file. I assigned first 4 sheets' necessary value to 41th sheet's related cells and colored them yellow. Is it possible to write a code with "for and if cyntaxs"(as i think)?
Thaks for helping.
Bookmarks