Hi All,
I have an Excel. Which has around 30 worksheets. I want to search for a particular worksheet based on the value worksheet name. and copy the contens of the worksheet to new worksheet with the name as 'Search worksheetname'. Can you please help me in getting the macro code for doing this? I should have a text box and a button in the search worksheet. Where I can enter the worksheet name. Once i press the button,it should search for the worksheet with the name i entered and copy the contents and create a worksheet with the name of 'search worksheet'. Please help me. Thanks in advance.![]()
Bookmarks