Hi Nikhil,
Please keep group email in all your communications.
You may send us sample data and we will prepare a pivot for you.
Best regards,
Ayush Jain
On Fri, Jun 11, 2010 at 9:31 AM, Nikhil Shah wrote:
> Hi Ayush,
>
> Recd you e-mail.But I do not have any knowledge how to use pivot table.
Hi Nikhil,
Use Pivot tables to get this done...Let us know if any further help is
required.
Best regards,
Ayush Jain
On Jun 11, 1:09 am, Nikhil Shah wrote:
> Hi Friends,
>
> Here I am posting Query, pl help.
>
> Name Amt
>
> Bill 1,000
> Gopal 1,500
> Bill 3,000
> Ashok 4
Hi Friends,
Here I am posting Query, pl help.
Name Amt
Bill1,000
Gopal1,500
Bill3,000
Ashok 4,500
Bill2,000
Gopal 500
Now I want the Answer : Bill 6,000 3
Gopal 2,000 2.
Thanks
Nikhil
--
-
Criteria1:=ActiveCell.Value
TO TAKE THE PHOTO PRESS "printscreen" or"prt scr" button and goto ms
paint press ctrl +v or paste it then cut the image and send it
On Thu, Jun 10, 2010 at 5:00 PM, big smile wrote:
> Hellow Gorup Masters,
>
> I want the help to write the macro as follows.
>
Hi Swapnil,
My question is related to charts, i thought you may have some
knowledge about it:
1) Is it possible to identify a new chart name, if we copy an existing
chart available on the same sheet i.e. if i have a chart named
"Chart1" on Sheet1, i copy Chart1 and paste it on Sheet1 again, is
th
the problem is that you can change the cell formatting to make it LOOK like
"***"
but you'll see the actual value in the toolbar at the top, which isn't good!!!
P
From: Rajesh Bedse
To: MS EXCEL AND VBA MACROS
Sent: Thu, June 10, 2010 6:35:28 AM
Subject: $$E
try this macro:
Sub NewFilter()
On Error Resume Next
ActiveSheet.ShowAllData
Selection.AutoFilter field:=14, Criteria1:=ActiveCell.Value
On Error GoTo 0
End Sub
however, if you want the COLUMN of the selected cell filtered, then you can use:
Sub NewFilterRecord()
On Error Re
Err, the link doesn't show up completely in this e-mail. It is the
Test_DeleteByNumberName file in the list of uploaded files.
On Jun 9, 12:25 pm, molinari wrote:
> Thanks a lot, Deepak.
>
> Here's the
> file:http://groups.google.com/group/excel-macros/web/Test_DeleteByNumberNa...
>
> (I'm und
How do I define and implement an interface in VBA?
I would like to keep the implementation flexible but the interface
should stay stable.
Lars
--
--
Some important links for excel users:
1. Follow us on TWITTER for
Hi friends,
I want to display a cell content as password (i.e. like )
but the data should exist there.. so that I can use the same data in
macro for login purpose.
~ Rajesh
--
--
Some important links for excel u
Hellow Gorup Masters,
I want the help to write the macro as follows.
Sub Macro2()
'
' Macro2 Macro
' FILTER LIKE THIS
'
' Keyboard Shortcut: Ctrl+Shift+F
'
ActiveSheet.Range("$A$3:$IX$681").AutoFilter Field:=1, Criteria1:= _
"CURRENT CELL CONTENT "
End Sub
when ever i select the pa
run it select the notepad file and click on ok
On Thu, Jun 10, 2010 at 9:59 AM, Mahesh wrote:
> Hi Ashish,
>
> Thank for the codes but i m not able to use them,
>
> Can u give my the process how to start and how to end the same.
>
>
>
> On Tue, Jun 8, 2010 at 7:14 PM, ashish koul wrote:
>
>>
Stuart,
Thank you for going to all the trouble to build this. I do have a
problem. I just found out that they are indeed free floating
checkboxes that are not attached to cells.
Are we just out of luck here?
On Jun 10, 5:08 am, Stuart Redmann wrote:
> On 9 Jun., 16:15, Rod Urand wrote:
>
> >
I want to know if some one has done prior programming in VBA for
performing the tacheometric calculations in excel .
We take data in form of horizontal and vertical angles , apply
formula and calculate the X,Y,Z coordinates . All I want to do is
automate the task . VBA routine asks for
On 9 Jun., 16:15, Rod Urand wrote:
> I have a client who has created a rather large Excel workbook with
> checkbox form controls.
>
> Unfortunately, each form control was not set to have a cell link.
>
> The client would like to now tabulate the results of the checkboxes
> (to determine how many
Hi Mr. Modi,
Here is your answer:
- First of all create graph
- Now what we want to do is that whenever we move cursor over data, graph
should display and when we move out cursoer from data, graph should get
hide.
- To do this we have to capture mouse move event. You cannot captur
Hi,
I am newbie to Macro's, can someone help me with where to find the correct
source of information for macro's or any material as such.
Many thanks in advance.
Regards
Sreeji
17 matches
Mail list logo
