On Fri, 19 Feb 2010 22:25:43 -0800 (PST), Amit Kumar
wrote:

On Feb 20, 10:37*am, marcus wrote:
Hi Amit

All of the information to complete this project is available online
through searches within Google. *Being a student research should be
second nature to you and gleaning the information to perform this
simple task should be straight forward.

I mean no disrespect and sincerely hope you get the answer you are
looking for through your own endeavours. *VBA is a very intuitive
language and completing this project yourself with be liberating
rather than taking someone else's work and presenting it as your own.

Take care

Marcus

@all i understand that macro is intutive language but the thing is
that i don't know much about the vb
and its my assignment for which i had been given 3 days.
regarding the project i have created the button and have somewhat
figured out to sort the data but my problem is
1)how to connect the sheet 2 parameters to sheet1
2) how to attach macro to the button so that when it is pressed it
sorts the data out

if any of you have any idea how to do that
and don't preach,its my marks that matter.
i know there must be some subjects you don't know for ex.


@Marcus :- if someone asks you to give the biosyntheis of The aspirin
i bet nobody in the net can do this.
please understand when the subject is alien mere understanding doesn't
help
and i am not asking for readymade help at least make another macro for
attaching any simple code to a button and tell me hw you connected
themacro to button
i will figure it out then and will apply to my case
\
Right click on the button and select hyperlink. Then select the link
parameters and point it to a macro. Then work on the macro. Or do the
macro first, then point to it with the button. Either way same result.

You should be familiar with Windows too. Right clicking any object or
screen element can very often provide choices that take you where you
desire to go. Getting to know these sub menus as you use them in your
experience with getting familiar with the application is how you gain the
capacity to create workbooks that will process and display and report on
your data in the most efficient, professional way. It optimizes your
abilities along the way.

Since you only have 3 days, I can see your need. You might get what
you need, but you should remember that you studies cannot all be about
your major. You have to take in the little details about all the other
stuff too. Even if that means that you are not one of the 'see and be
seen' crowd out partying on the weekends.

If you record a macro where you right click on a pivot table and select
"refresh data", and then save the macro, you should be able to examine
the macro code to see what the pivot table update code segment is.