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:
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
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
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
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 the
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
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 purpose.
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,
Attached
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 vinod.ma...@gmail.com
HI Team,
Need a VBA code for doing pivot - below condition is needed
1
Z F C
I am eliminating these
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:
10 matches
Mail list logo