As your request is still a bit vague i couldn't begin to help further
without seeing a sample workbook.

*How to get further help with a workbook*
For further help with it why not join our forums (shown in
the link below) it's completely free, if you do join you will have the
opportunity to add attachments to your posts so you can add workbooks to
better illustrate your problems and get help directly with them. Also if
you do join please post in this thread (link found below) so that people
who have been following or helping with this query can continue to do
so. :)


QUOTE=Amit Kumar;648731]i don't know if you can help but i have been
given the task of
creating a macro forthis question.

Create a workbook having a button. When the user presses the button,
it should sort the data in sheet1 & then add subtotals to it. The
parameters required for sorting & subtotals are specified in the
sheet2.

if you can help it would be so nice of you . please if you or anyone
else can solve it by monday please send it to my id alongwith the
excel file



any help would be great


--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: 1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=168421

Microsoft Office Help