Pls clear your question & make excel sheet with your data & query and attach
with this mail.
Vir
2009/11/25 subhash tambe
> Dear all,
>
>
> How to compile to excel pivot table ,
> ( B Column Count 5 to 15 )
>
> A B C D E F G H
> 1
> 2 10
> 3 25
>
Hi Guys,
I am not sure whether I should ask it here or not because as the subject
suggests, this is a non-excel query.
What is the scenario -
I have two locations:
1. D:\My Collection
2. E:\My Collection
Under both these folders I have like 500 subfolders. *All the subfolders are
named exactly
Dear all,
How to compile to excel pivot table ,
( B Column Count 5 to 15 )
A B C D E F G H
1
2 10
3 25
4 27
5 15
6 13
7 12
8 7
9 9
& tell me other formula & trick
Thanx
Please reply me
-
thanks for the reply
I am using If(Value>0,"a",0). And Now i want to change "a" with say
"m". is it possible. The formula is used for 3000 times on my single
sheet. When i tried it offered me to save in anouther new sheet. which
i cannt do.
On Nov 24, 10:56 pm, RolfJ wrote:
> You should provid
Hi Om,
We can sort this using VBA in the same way I summed them, but I don't think
it's possible to sort them without VBA.
We can get VBA to re-write the data, so that all the Cr's are copied to one
column, and all the Dr's are copied to another.
Then you can use worksheet functions on those
Hello
Please help me in giving the address of a good Excel and VBA tutorial around
Ghatkopar, Mumbai.
Thanks
Nandkumar
On Tue, Nov 24, 2009 at 12:58 PM, Nandkumar kakvipure <
nandkumar.hindust...@gmail.com> wrote:
> Hello,
> Please Help me
> my system generate date format 14/10/09 this type but
Hello Pals,
I am very much grateful for the solution you all had provided for my
problem.
Thanks
Nandkumar
On Tue, Nov 24, 2009 at 12:58 PM, Nandkumar kakvipure <
nandkumar.hindust...@gmail.com> wrote:
> Hello,
> Please Help me
> my system generate date format 14/10/09 this type but i need 14 Oct
Dear Experts,
Can u help to sort the number on the basis of format cell . File attached
--
Regards,
O.P.Sharma
Executive Manager- Accounts
M/S UBIO CHEMICALS LIMITED
VILL : AHMADPURA,ATRAULI
ALIGARH-U.P.
+91-9675202525
--
---
Hi yalters,
I couldn't see any other way of doing it, considering the format of the
original data. But I'm open to anything (simpler) that works.
Regards - Dave.
> Date: Tue, 24 Nov 2009 08:24:08 -0800
> Subject: Re: $$Excel-Macros$$ SUM ON BASIS OF FORAMAT
> From: yalt...@gmail.com
> To: exc
Where I work they are going to be ugrading Office 2003 to 2007
version. I am an Excel 2003 Power User you could say. I have many
drop down menus that I have customized and tons of macros and macro
buttons and these took years to develop over time. I am able to
"perform my magic" as my boss would
That is cool! Thanks Sir :)
On 24/11/2009, Dilip Pandey wrote:
>
> you are welcome..!!
>
> Best Regards,
> --
> DILIP KUMAR PANDEY
>MBA-HR,B COM(Hons.),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 110062
>
>
> On 11/20/09, Umed Singh wrote:
>>
>>
I wish I would understand what you want. actually Someone should
understand what you want.
On Nov 18, 9:27 pm, kunal wrote:
> Hi All,
>
> Please help me in the second query that i have asked before,
> Lets suppose i am adding some rows after row 20th, it should take the
> 1st inserted row i.e. r
I'm really wondering why are we using custom number formating and vba
for this task.
On Nov 24, 3:49 am, Dave Bonallack wrote:
> Hi Om,
> Have a look at the attached. It uses a macro to sum your column, based on the
> 2 different formats you've used.
> I don't know how to do this with worksheet
Here is another code I wrote but could not make much use of it
In the attached excel file, I have a frame inside a sheet which I wanted to
be able to move by drag and drop...
It is working fine.
See if you can use that in you application
--
-
Hi Luke,
I hadn't seen Koul's solution, but it seems to be looking for blanks or single
spaces or double spaces, which all return one space. If there is data, it
returns that data, then goes on to the next cell. If there is data in 2 or 3
cells sonsecutively, then those datas would be concatin
I can't think of any Excel-intrinsic method that would do this.
However a VBA macro could. If I was to assume that your colored cells
are the ONLY data on active worksheet, give this macro a try:
Sub ExtractNonZeroCells()
Dim db As Range
Set db = ActiveSheet.UsedRange
'First results of
You should provide a bit more detail. What's the formula? Which
characters do you need to change?
On Nov 24, 2:51 am, nikhil deshpande wrote:
> Dear all,
>
> I need to change characters used to show results in (IF ELSE ) formula.
>
> I tried ctrl F- replace. but it is disturbing mu sheet and aski
Dear Mahavir
U can use following formula:-
=OR(TEXT(A1,"DDD")="Fri",TEXT(A1,"DDD")="Sat")
& apply it till last data in the column.
Solved file is also attached.
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New D
you are welcome..!!
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On 11/20/09, Umed Singh wrote:
>
> Thanks.
>
> On 11/19/09, Dilip Pandey wrote:
> > Hi Umed,
> >
> > Please find the solution
Hi everyone
Sorry for the delay:
'This is a function which I wrote for displaying and adjusting the form size
for my project:
Public Sub mZoom(ByRef Form As Object, Optional Hzoom As Integer, Optional
Vzoom As Integer)
If Vzoom = 0 Or Hzoom = 0 Then
Hzoom = Application.Width / Form.Width * 100
V
Hi,
Refer to attached solution.
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On 11/20/09, Mahavir Bhardwaj wrote:
>
>
> Pls see attachment
>
>
> --
> -
> --
>
> (¨`•.•´¨) Always
> `•.¸(¨
Dear Anil,
Sorry for late reply.
Two options which you can use:-
1) As suggested earlier, you can use lookup function OR,
2) If you do not want to use formula to be already housed in the result
area, then you can use worksheet_change event to enter same formula.
Best Regards,
--
DILIP KUMAR PAND
hi
all experts and learners
Please note that your queries and answers should type
in attachement alos. and it benefits for users to solve question
later than during net surfing.
--
sudhir
--
--
Some important link
Hi everyone there,
I would like to know about a Guy who is going for a Job Interview with the
following Job Description, what is that one have to prepare himself to make
it successful for getting Selected.* Plzzz Guide me As Soon as
possible, Eagerly waiting for PROMPT REPLY:*
Det
Thanks a lot for the help.
-Original Message-
From: RolfJ [mailto:r...@pacificsound.us]
Sent: Tuesday, November 24, 2009 7:24 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Re: Excel check list
If I correctly understand what you are trying to do you could add a
UserForm to your
I am looking for something similar so can you send me a workbook with the
example as i am not familiar with VBA
THanks,
Dharmesh
On Mon, Nov 23, 2009 at 9:08 PM, RolfJ wrote:
> Here is a slight correction to my previous response. The eventhandlers
> in the ThisWorkbook VBA module need to be
Dear all,
I need to change characters used to show results in (IF ELSE ) formula.
I tried ctrl F- replace. but it is disturbing mu sheet and askin g to save
some where else.
Kindly guide.
--
Nikhil
--
--
Some imp
Out of interest what was wrong with Koul's 'concatenate' example with
nested IF's ... ? This is the route I would have gone, although I
would update it slightly like so ...
=CONCATENATE(IF(OR(ISBLANK(A1), A1=" ", A1=" "),"
",A1),IF(OR(ISBLANK(B1), B1=" ", B1=" ")," ",B1),IF(OR(ISBLANK(C1),
hi,
do as following
Select the column in which date is there, press ALT+D then E, convert text
to column will appear press next then next once again, select date option
then finish.
thanks
vir
2009/11/24 Nandkumar kakvipure
> Hello,
> Please Help me
> my system generate date format 14/10/09
Hi Mahesh,
Please insert a Module and add the above code...
The usage is as follows:
Assuming the value is in Cell A1 and we want the Text in Cell B1
Then in B1 type :
=CurrencyToWord(A1)
Regards,
Andy
On Tue, Nov 24, 2009 at 4:48 PM, Mahesh wrote:
> Hi Aindri,
>
> Please also share how t
Hi Aindri,
Please also share how to use this code.
i mean to say how to start it after writing it.
On Mon, Nov 23, 2009 at 9:12 AM, Aindril De wrote:
> Great Idea Hemant!!
>
> Here goes my code!!
> The following code is to Convert Currency to Words(Indian Style)
>
>
>
> 'Please make a Module a
Dave, i tried doing that, but here the concern is with cells having a wrong
date as per US format.. foe example the cell where you have the date of
27/12/2002 will not be chnaged into the required date format at all, for
excel this is a wrong date.. i had to disintegrate and then concatenate in
the
Hi,
If you double click in the first cell, then press Enter, the cell is displayed
as you require.
You can either do this in each cell manually, or you can write a macro to do it
for you.
Regards - Dave.
Date: Tue, 24 Nov 2009 12:58:32 +0530
Subject: $$Excel-Macros$$ Change Date Format
From: na
Hi Steve,
If you use the suggested =B4 & " " &C4 & " " & D4 etc, the result will be
double spaces for each blank cell.
You can get rid of these using the TRIM function.
=TRIM(B4 & " " &C4 & " " & D4)
Regards = Dave.
> Date: Mon, 23 Nov 2009 20:23:33 -0800
> Subject: Re: $$Excel-Macros$$ Concat
Hi Om,
Have a look at the attached. It uses a macro to sum your column, based on the 2
different formats you've used.
I don't know how to do this with worksheet functions, but we could add an event
macro that re-sums every time there is a change in the data, if you need. Or
you can just do it m
Hi Mike,
Thanks for the feedback
Dave.
> Date: Mon, 23 Nov 2009 14:56:57 -0800
> Subject: Re: $$Excel-Macros$$ Add a column of matching numbers
> From: mwillia...@socal.rr.com
> To: excel-macros@googlegroups.com
>
> Dave,
> Your soultion was spot on.
> It executed immediately.
>
> THANKS THANK
36 matches
Mail list logo
