Search for tab in another workbook, name of tab in in a cell in active sheet

Hi all,

I have a sheet and I want to use a name in a cell that corresponds to a tab in another workbook. So say in cell U11 in the active work sheet is the name of the tab in another sheet which is "Cat" so below works for me if it is hard keyed into the macro;

Please Login or Register  to view this content.

Now I want to change the tab name in the active sheet to "Dog" and then I would have to go into the macro and change "Cat" to "Dog" to make it work.

Is there a better way to do this by instead of puttin "Cat" or "Dog" into the macro I can just put the name in cell U11 which is will reference?

Cheers,

Please Login or Register  to view this content.

Hi Cytop,

thanks for that but not sure if I have got it working properly, the sheet name for the fromSheet is in U10 and previously specified so can I substitute ("SheetNameHere") with ("fname")?