Paul Schreiner,
Thank you so much for your help.
Its working now. Thanks again
Ramesh
On Nov 4, 8:43 pm, Paul Schreiner wrote:
> sorry, my fault...
> I normally have the Status bar show me a "% complete" status
> ever 5-10%... but I removed it from this one
> since you probably aren't process
Hi,
I have various drop downs on a worksheet. What I want to do is if the
value of B3 is 2 then unhide rows 4 & 5 along with drop down 7 and
drop down 8. If the value of B3 isn't 2 then hide the rows and drop
downs. I also want to do the same thing with rows 15-18 and drop downs
3, 4,5 if the val
Hi Friends,
I am Ram, working with an MNC company. My project leader asked me to
design the project documents for VBA. Since I am new to development
project, I don't know how to design the documents. Please let me know
what are we need to prepare.
And also I need code and study documents on A
sorry, my fault...
I normally have the Status bar show me a "% complete" status
ever 5-10%... but I removed it from this one
since you probably aren't processing 40,000 records!
But left one line in.
comment out (or remove) the line with:
If (R Mod modcnt = 0) Then ...
it should work then.
P
In Office 2007 SP2, you can copy an Excel chart and paste (default)
into PowerPoint. In PowerPoint, a Smart Tag appears next to the
pasted chart that lets you choose from 3 paste options. The one I
want is "Excel Chart (entire workbook)" so that the underlying data is
included in the presentatio
Thank you so much for your help.
I am afraid to tell you that, the 1st procedure "Sub Segregate_Data()
" is returning me an error, and the error is "Division by Zero".
Request you to do the needful
Thank you,
Ramesh
On Nov 4, 7:09 pm, Paul Schreiner wrote:
> Ramesh,
>
> I agree with you.
> I
Thank you so much for your help.
I am afraid to tell you that, the 1st procedure "Sub Segregate_Data()
" is returning me an error, and the error is "Division by Zero".
Request you to do the needful
Thank you,
Ramesh
On Nov 3, 8:01 pm, Paul Schreiner wrote:
> sure,
>
> these macros should wor
I cannot recall thje exact format, but if you type something like
application or worksheet function followed by a period and then the
excel function name, it will then use the excel function
On Nov 4, 7:49 am, Howie wrote:
> I am developing an application which imports data from Excel. A few
> c
Hi Karthikeyan,
You need to clean up the data before preparing Pivot Table. If the data set
is going to be similar in future as well, then I would suggest to use VBA
macro code. If the data is differrent always or is extracted using
different columns and rows then you might want to do the data c
Dear Nagendra,
You can use SUBTOTOL function to count or sum the filtered data, but if you
want to give number (or serial number) to the filtered rows, then you might
want to go for VBA coding.
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.
Hi Sudhir,
Achieving this task through Functions is difficult. Alternatively, you
should go for VBA - Macros.
Internet is full of these types of VBA codes which you can refer. One
example is given below:-
http://www.ozgrid.com/VBA/ValueToWords.htm
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B
Hi Mahesh,
Offset function is explained with required examples in the attached
workbook. Thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Wed, Nov 4, 2009 at 10:02 AM, Mahesh wrote:
> Hi Friends,
>
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 Wed, Nov 4, 2009 at 7:30 PM, Jai Deo Tiwari wrote:
> Thank you sir
> --
> j...@i Deo t...@ri
> |||
Ramesh,
I agree with you.
I have 40,000 lines of records to be distributed to 60 individuals
they only need the records that pertain to themselves,
so I split the data into separate sheets and send them only
their data.
Were you able to try the macro i sent?
Paul
___
Hi,
Try below mentioned options:-
1) Select the cell which has #NAME in it, press F2 and then press Enter.
OR,
2) Check if the formula / function required ATP (Analysis Tool Pack) to be
installed. Go to Tools -> Add-Ins -> and check both the options for ATP,
click ok and it should be done. OR,
3)
Dear Umesh,
Use below formula and format it as percentage.
=ABS((C2-C3)/C3).
The above formula assumes the profit figures are in C2 and C3 respectively
for 2002 and 2001.
Attached workbook with the given scenario is also attached with this email.
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B
Hi Karthikeyan,
Check if the data which you are attempting to paste, is matching up with the
format / validation. It has to be same as per the validation done.
For better explanation, attach the workbook with two different worksheets
having required data to test.
Best Regards,
--
DILIP KUMAR P
Dear Jai,
Today() will change when the system date changes, follow any of the below
approach if you want it to be static:-
1) Before closing the workbook, paste -special formula of Today() as
values, if it suits you practically :)
2) If feasible, use Alt + ; key combination to enter date.
3) Us
I am developing an application which imports data from Excel. A few
cells contain formulas and the imported value of these is returned as
#NAME? . Is there any way I can programatically perform the formula to
return the cell value?
Thanks.
--~--~-~--~~~---~--~~
--
Thank you so much for your message:)
I agree with u, and i like the concept of keep a main database from
where we can perform all the required analysis, but in some instances,
i have to segregate the data by manager, and update the managers with
their respective details, moreover this is a continu
hI ALL
pLEAE TELL ME INSTITUTE OF ADV. EXCEL WHICH
IS PROVIDE WEEKEN CLASES IN DELHI.
--
sudhir
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutoria
-- Forwarded message --
From: Lavprasad Kori
Date: Wed, Nov 4, 2009 at 5:13 PM
Subject: Re: $$Excel-Macros$$ Fwd: Help for formula ti pick up rate
To: vidyut more
Yes, it will work in 2003.
Please use ISERROR instead of _xlfn.IFERROR.
On Wed, Nov 4, 2009 at 3:46 PM, vidyut m
Hi Vidyut,
Just answered this one few seconds ago. Let me know if you do not find the
respective email.
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Wed, Nov 4, 2009 at 1:15 PM, vidyut more
not clear
On Nov 2, 2:00 pm, 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 room, so if U see
> darkness in Ur life b
24 matches
Mail list logo
