Select a Sheet Base On User Input

[SamRam]

Hi People

please see the code below

Please Login or Register  to view this content.

i am trying copy data from one worksheet to another worksheet while copying the records to new row. i want the user to input the worksheet name based on that the data should be copied to another worksheet. used the above code but getting"Compile error", please correct me. thanks in advance

[davesexcel]

possibly

Please Login or Register  to view this content.