Why not post the code you have so far ?

Tim

"Amit Kumar" wrote in message
...
hi i am just a novice at the vba . now i have been asked to submi an
assignment that is:

1)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.

OR
2)Create a workbook for generating the pivot table from the given
data. The parameters for the pivot table are to be specified in
sheet2.


please as i am a novice it would be so kind of any programmer if he
can send me the working excel sheet and yes its very urgent.|(2 days
only)gotta submit it by monday