Dear Pooja Jee,
Let me first thank you for the confidence you have showered on me.
Further, the solution is attached for your kind consideration.
Regards,
Kumar
_
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Pooja Sharma
Sent: M
LookAt:=xlWhole back to LookAt:=xlPart
When running my macro what doing it job, preparing the copy area the
"LookAt:=xlWhole" stays in place.
When I do a find with ctrl+f and try a quick search with a part of a
word, I must not forget to deactivate manually the identical option.
Question how to
Hi
I did not understand what you want to accomplish with a VBA code.
But can i pls know why you hate recorded macros?
Hemant Hegde
2009/11/2 vinod rao
> HI Team,
>
> Need a VBA code for doing pivot - below condition is needed
>
>
>
>
> 1
> Z F C
> I am eliminating these from pivot ta
Hi Kumar,
Thanks for the help, but still two difficulties are there, which is
mentioned in the sheet itself. I think you can and will resolve these
problems too.
Regards,
Pooja
On Mon, Nov 2, 2009 at 1:05 PM, Chandra Gupt Kumar <
kumar.bemlmum...@gmail.com> wrote:
> Dear Pooja Jee,
>
>
>
> Att
Really thanks C.G.Kumar its really helpful to me.
On Mon, Nov 2, 2009 at 3:42 PM, Chandra Gupt Kumar <
kumar.bemlmum...@gmail.com> wrote:
> Since you conveyed that you required the result only in specified area, I
> have amended the solution to suit your requirement.
>
> Hope it serves the purpo
Hi Rolf,
Futher to this post, a couple of quick questions:
1. How do I assign the form to a ctrl+key so that when the user wants
to select a macro to run on the form that is the first thing that pops
up?
2. How do I call a form from a macro in a module? This way if I want
to get input from a
Hi Rolf,
Thanks for the help with this. I will play around with it and
hopefully get it to work.
Am I right in saying that the value in ListBox1.AddItem ("Macro1") is
Macro1, and it will automatically know which sub to use in the regular
module? If I have 3 Modules, how can I indicate that th
Copy the macro listed below into a standard VBA module in your
workbook and give it a try. The macro will parse the data on the
'Data' worksheet and create another worksheet named 'CleanedUpData'.
You can then setup the PivotTable you want on that worksheet.
Sub ExtractData()
Dim strTransact
HI Team,
Need a VBA code for doing pivot - below condition is needed
1
Z F C
I am eliminating these from pivot table, see pivot for more details
2
if name k is available it should be considered in pivot
3
I don’t want recorded vba macro
Second simple macro on vlookup. See attache
Not clear what you mean. Please provide an example.
On Nov 2, 1:00 am, Nagendra Modupalli wrote:
> Hi Team,
>
> Is there any formula to give cells continuous number for filter one.Thanks
> in advance.
>
> --
> Thanks&Regards
> Nagendra.M
>
> "Beautiful photos are developed by negatives in a dark
* Employee Resignation*
The name is good, the brand is big
But the work I do is that of a pig
The work or the brand; what is my way?
I don't know if I should stay.
To work, they have set their own way
Nobody will care to hear what I say
My will be NULL, they wont change their way
I don't know i
Hi Team,
Is there any formula to give cells continuous number for filter one.Thanks
in advance.
--
Thanks&Regards
Nagendra.M
"Beautiful photos are developed by negatives in a dark room, so if U see
darkness in Ur life believe that God is making a beautiful future for U !!!
--~--~-~--~
Dear Pooja Jee,
Attached the solution. Hope it serves the purpose.
Regards,
Kumar
_
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Hemant Hegde
Sent: Sunday, November 01, 2009 11:49 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-
Hi Deepak,
You have provide good solution but when I drag the list it shows #NAME? .
Further you have used .xlfn in your formulae , may you please tell what it
is exactly and what it does.
Regards,
Kumar
_
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroup
14 matches
Mail list logo
