Re: A question about VBA in Excel

From: KOBE (cheung81_at_hotmail.com)
Date: 01/22/05 

Date: Sat, 22 Jan 2005 09:44:30 +0800

thx for your help
I will search those command in google
and study how to use them

"George Nicholson" <JunkGeorgeN@msn.com> ¦b¶l¥ó
news:uT4Nre%23$EHA.2540@TK2MSFTNGP09.phx.gbl ¤¤¼¶¼g...
> If you can do it manually, you can automate it with VBA. So, the question
> becomes, how would you do it manually?
>
> One approach:
>
> Apply AutoFilter to ***("david")
> Criteria: Date >= 01/01/05 and < 02/01/05
> Copy results
> Paste results to ***("January")
> Repeat for may , eva , john , mary
>
> To get started, you might try turning on the MacroRecorder and do one step
> manually.
> The macro recorder produces incredibly verbose and very simplistic code
but
> you can learn a lot from viewing and "cleaning up" the results. If
nothing
> else, it would give you some clues as to what you need to "research"
> further: loops, dynamic ranges, etc.
>
> HTH,
>
> --
> George Nicholson
>
> Remove 'Junk' from return address.
>
>
> "KOBE" <cheung81@hotmail.com> wrote in message
> news:uWyD1O3$EHA.3504@TK2MSFTNGP12.phx.gbl...
> > if I have a Excel file which contain 5 ***
> > each *** have a different name
> >
> > david , may , eva , john , mary
> >
> > each *** contain some information about useage of money
> >
> > record in the fellow field : Date , Item , Amount
> > date mean the date of money used
> > item mean what is the money used for
> > amount is the amount of money used
> >
> > each *** record each person used how much money in 5 month
> >
> > now if I want to make a monthly report to show those 5 person's money
> > useage
> > such as create a new *** called "Jan" , and this *** will contain
> > david
> > , may , eva , john , mary these 5 person useage of monry in january
> > then frbruary , march april etc..
> > depend on the date in original ***
> >
> > now I want to ask , is it possible if I use VBA to do it ?
> > then if it is possible , which topic I need to search in VBA
> > I want to study it , but I don't know which kind of information that I
> > need
> > to search in google
> >
> > if you know , please tell me
> >
> > thx
> >
> >
> >
> >
> >
> >
> >
> > --
> >
> >
> >
>
>