After searching here as well as doing several google searches I have found some that closely match what I'm trying to do but not exactly. I hope you guys can help me out. attached is a workbook to hopefully identify what i'm trying to accomplish.
I have a dropdown list cell A1 with "Sheet1,Sheet2,Sheet3,etc" located on an irrelevant sheet "SheetHome" I would like to copy data from "SheetHome" and then have it look to Cell A1 (where it says Sheet1...), then go to that corresponding sheet and paste the data.
Is this possible?
Bookmarks