TOUGH MACRO - DARE TO CODE IT

[Amit Kumar]

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

 

[Tim Williams]

Why not post the code you have so far ?

Tim

 

[marcus]

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

 

[Gary Keramidas]

probably did.

--


Gary Keramidas
Excel 2003

Why not post the code you have so far ?

Tim

 

[Amit Kumar]

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
\

 

[Skiffle]

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

Amit,

Everyone who responded has been rather polite. I would advise you to reread
Marcus' response. Now, I guess I'll be the bad guy. Given your last
response, you don't seem to get it. No one here is going to do your
homework for you.

,,, i don't know much about the vb

How do you expect to learn VB if you are simply given the answers. It is
your research and attempts (right or wrong) that will help you learn. Were
you given reference materials, a textbook for this course or assignment ?

and its my assignment for which i had been given 3 days.

Better get crackin' !

... and don't preach,its my marks that matter.

No, *you* only care about your marks. When you're out of school, other
people really don't care what your grades were. It is your knowledge and
intelligence that matter. Those qualities will help you in life.

i know there must be some subjects you don't know for ex.

That is true for everybody but he's not asking for someone else to do his
homework. I'm having some time with particle physics at the present time
but, in a few weeks, no problem.

@Marcus :- if someone asks you to give the biosyntheis of The aspirin i
bet nobody in the net can do this.

Actually, you are wrong. Aspirin is quite easy to synthesize. Even if this
was true, I can find out how to make aspirin through the internet. It took
all of 0.53 seconds Amit.
http://science.csustan.edu/nhuy/chem1002/aspirin.htm

i am not asking for readymade help

Yes you are

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

Again, do your own homework. Learn.

Skiffle

 

[Don Guillett]

We don't do homework. However, google is your friend, ie:
excel: pivot table

 

[marcus]

Hi Amit

Your course directors have put this course on your agenda as they
think it is important and that you and your fellow students have the
grey matter and research skills to pull it off. We could solve this
for you in no time. But we are doing you a favour. Don even told you
where to look and Skiffle in essence said that knowledge is what is
really important. This will become very apparent when you leave
school and employers start asking more about what you have done rather
than what grades you got.

Please don’t disrespect the altruistic hard work that people do in
this forum. From my own experience very few people say thank you but
it is a bit rich when someone is critical when all we do is try to
help. In your case (though you don't see it this way) helping is
telling you to go and do some research and try and crack this
yourself. I would point you to Don’s post and ask you to look at the
question and use that as criteria in the most powerful library ever
created, the Internet.

Take care

Marcus

 

[CellShocked]

@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.

 

[CellShocked]

We don't do homework. However, google is your friend, ie:
excel: pivot table

Or "Windows interface basics".

Step: Right click and examine available menu options.

He said he placed the button, but can't get it to do anything.

I think there is a slight lack of user familiarity with basic Windows
human interface paradigms here. I see a LOT of this in today's world.
Lots of slackers that just can't figure out why they can't find what they
want, but did not even pay attention to the person that they got to do it
for them, right in front of them. Desktop/Operating System familiarity
is tantamount to being able to utilize computers in your educational and
career choices optimally. Any lack causes your work efficiency level to
cost others their time and ends up degrading office/school
operational/educational efficiency/efficacy.

Einstein said that we should not commit to memory anything that we can
look up in a table or book. IF we merely commit to memory, the
operational parameters of our computers, we can make his statement true
with the vast cloud of information that is out there. Those that fail to
perform this basic need will always be tugging away at other to help out.

My mind is free because I can find anything out there. All these years
of doing that means I AM familiar with this machine, and folks that are
unaware of a simple right click menu function are really sport more
serious character flaws in many cases.

We see here one such flaw resulting in excuses like deadlines, etc.

He only has 3 days, but how long has this assignment sat on his schedule
sheet? OR how does this teacher have an expectation of familiarity with
this application? What is the class, is the question? Is it an Office
suite class, or is it some data management class? What?

Doesn't matter. He should learn it. However, if he thought hard
enough, finding out here is easy enough. MS has user submitted templates
with tables and buttons like he wants, where he could easily sub in his
criteria, and do so legally, since the sheets are submitted as being
public domain, free to edit works.

You have to learn it at some point, and there is no time like the
present.

 

[Amit Kumar]

Amit,

Everyone who responded has been rather polite.  I would advise you to reread
Marcus' response.  Now, I guess I'll be the bad guy.  Given your last
response, you don't seem to get it.  No one here is going to do your
homework for you.


How do you expect to learn VB if you are simply given the answers.  It is
your research and attempts (right or wrong) that will help you learn.  Were
you given reference materials, a textbook for this course or assignment ?


Better get crackin' !


No, *you* only care about your marks.  When you're out of school, other
people really don't care what your grades were.  It is your knowledge and
intelligence that matter.  Those qualities will help you in life.


That is true for everybody but he's not asking for someone else to do his
homework.  I'm having some time with particle physics at the present time
but, in a few weeks, no problem.


Actually, you are wrong.  Aspirin is quite easy to synthesize.  Even if this
was true, I can find out how to make aspirin through the internet.  It took
all of 0.53 seconds Amit.http://science.csustan.edu/nhuy/chem1002/aspirin..htm


Yes you are


Again, do your own homework.  Learn.

Skiffle- Hide quoted text -

- Show quoted text -

@skiffle : had it been your intelligence i bet i would have given you
0 on this remark
@Marcus :- if someone asks you to give the biosyntheis of The aspirin
i

Actually, you are wrong. Aspirin is quite easy to synthesize. Even if this
was true, I can find out how to make aspirin through the internet. It took
all of 0.53 seconds Amit.http://science.csustan.edu/nhuy/chem1002/aspirin..htm

reason: cause you don't know the differnce between synthesis and
biosynthesis and i bet again you take 0.53s or take 53 days you wont
make it because it requires basics of chemistry biology and of course
intelligence

i know you may be genius in excel cos thats your field but the one i
mentioned is my field
anyways no disrespect meant for you at all but thats no way to talk to
a person who saw computer after 20 years of his life and has taken VBA
as a 3 month course elective just to complete my credits at the age of
22. Had it been in my control i wouldn't have taken it
but i kinda got interested in it. thats not my majors its just a
course i have finance, marketing ,ops and other subjects which require
more hard work and mean more to my career . hope you would have
understand that.

and btw i cracked the code happy now .....
3 days for a subject which you hardly know in 3 months and that too
which you are not going to use at least not very much is very very
hard so pls never give such answers .if you dont want to help dont
reply it creates hope in mind of asker and then they crash very hard
hope u understand now

@ cell shock
i couldnt understand wat u wanted to say but of course it was near to
sympathy like something .anyways work was lieing for 2 days 1 day went
with you on forum 2nd day i set out for it 3rd day it was done of
course with a little help and i reiterate little i made the activex
button and sheet is very much working fine . i am modifying it to
glitter it . tommorow submission and i have passed in this course btw
i am not learning this course as i have no interest abd also no back
ground and experience of computers let alone excel and macros .
would post the code after giving this code to my sir




hey btw @skiffle
ha ha ha 0.53 s search hey boy its chemical synthesis not biosynthesis
first see meaning of biosynthesis
hmm k
little help for you to gwt the biosynthesis right
first get the biosynthesis mind it biosynthesus of shikimic acid then
something you would get by this a new biosynthetic pathway would give
you new acid and this will be used bya abacteria named ------ which
will convert this to salicylic acid . next one more biosynthetic
pathway new compound . culture a bacteria E.----- / K.-------- get the
aspirin
i am a chemist had it been so simple i wouldnt have quoted it , at
least put your mind at work if you ever be able to complete the
pathway tell me i bet i will learn with anyway u like ..........