I have enclosed the file for your reference.
When we open the file the userform will automatically opens, where i can select
the store which i wanted to display. After selecting the store number and
cliking on the View button. I need to sort data  by the selected store number and
it has to be pasted in a seperate working sheet  for easy display.
Here after copying the data from the main sheet and pasting the data into the
working sheet (used paste  special command) getting an error  message.
Could you please lookinto the file and get back to me.