Dear Deepak,
Thanks a ton !!
Iqbal
On 8/11/09, Deepak Rai wrote:
>
> Hi,
>
> In the Developer Tools click on More Controls & then select Calender
> Control 12.0.
> Please follow the below steps to get the Calender Control:
>
> 1. Right Click on Menu Bar
> 2. Select "Customize Quick Access
Hi,
We have a file which is downloaded from HTML page.
The data looks like below
A. Raman Industries
I. Rajesh Industries
III. Manoj Polymers
Rakesh Printers
Now i want to extract only the names of the suppliers, I dont want A.,
I. etc, Because i maintian another file which has correct suppl
Dear All,
Greetings of the day,
I want to develop a user form with following condition.
a) PO#.
b) Po validity. e.g from (31/7/2009 to 25/4/2010)
c) Po Amount.
d) PO Description. e.g (this po is generated for work so on.)
e) Search PO (eg by Po Number )
F) po STATUS ( e.g Closed or open on
hello friends
i dont know much about vba
i had bring calender to my sheet, but don't know how to proceed
further,can anybody guide me
i had written the code
my query is how to insert the date by using calendar, i can see only
embedded calendar on my sheet
Have A Nice Time & Enjoy Life
Regards:
C
Vivek,
Sorry to bother.
Can we create drafts with attachement of New workbook generate by below macro
as per client.
Regards,
Shrinivas
Query Unit
Securities Services
Global Transaction Services - India.
Ph: +91-80-41446339
E-Mail: shrinivas.chidur...@citi.com
-Original Message-
Fro
Hi,
If you will have a "." and space separating the supplier name, you can
try: =RIGHT(A1,(LEN(A1)-FIND(CHAR(46),A1,1)-1)) where A1 is the cell
with the supplier name.
Hope it helps!
CC
On Aug 11, 3:43 am, Suhas wrote:
> Hi,
>
> We have a file which is downloaded from HTML page.
>
> The data
Can someone help?
I have a user form that i created in a spreadsheet to automatically
launch when the workbook is opened. Can anyone tell me what code i can
use to prevent the workbook from being displayed when i open it and
only display the user form? Also where i need to place this.
Also what
Hi Ruchi,
Attached workbook has two solutions for this problem. Thanks
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Tue, Aug 11, 2009 at 4:57 PM, Ruchi Saxena wrote:
> Hi Friends,
>
> I have data in thr
Hi Giorgio,
Solved workbook is attached. Thanks,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Mon, Aug 10, 2009 at 3:09 PM, Giorgio wrote:
>
> Hi all,
> I have a series of % values that can be either 0
Hi Sandeep,
I have given two ways in the following worksheet.
Note:- If you have any test scenario, pls share.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Mon, Aug 10, 2009 at 10:37 AM, Sandeep wrote:
Hi All,
I have selected A1 to A5 and given some name(In Named Range).
Now I want to remove it. Anyone know how to do it???
Regards,
Suresh
--~--~-~--~~~---~--~~
--
Some important link
Most one knows..(Joke.)
Simply go to Insert->Name->Define.
Select the given name and click "delete" ( if you are using excel 2003)
OR
Go to Formulas->Name Manager.
Select the given name and click "delete" (if you are using excel 2007)
Regards,
Upendra Singh
+91-9910227325, +91-9
Hi Ruchi,
Sorry, correction:
=A1&CHAR(10)&A2&CHAR(10)&A3
Regards - Dave.
From: davebonall...@hotmail.com
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Hii..
Date: Wed, 12 Aug 2009 09:42:40 +0800
Hi Ruchi,
I think you need the following formula:
=A1&CHAR(13)&A2&CHAR(13)&A3
Hi Ruchi,
I think you need the following formula:
=A1&CHAR(13)&A2&CHAR(13)&A3
The cell format needs the Text Wrap option selected.
Regards - Dave.
Date: Tue, 11 Aug 2009 19:33:25 +0530
Subject: $$Excel-Macros$$ Re: Hii..
From: dilipan...@gmail.com
To: excel-macros@googlegroups.com
Hi Ruc
Thanks Dilip, but this is not what I want.
This is the Attached file I want to solve the rank as per the criteria in a
single cell without using any additional cell as I used Column K values.
Is there is any way to combine and use array values as range in any formula?
This is just a deep step i
yes, please email me at fahe...@gmail.com thanks
On Aug 7, 1:06 am, fongie wrote:
> Hi Osiso
>
> You sent me an email today with another query.
>
> I tried to send back to paraport email but got mail server rejections.
>
> Is there another email I can email you on?
>
> Alvin
>
> On Aug 6, 3:05 a
thank for the reply. But I do not want to use excel to send email. May
I know if there is a work around to automatically fill subject line,
TO and CC field whenever I click on reply or forward?
Regards
On Aug 2, 7:10 pm, mahesh parab wrote:
> Hi Sahil
>
> below mention link will help you.
>
> h
Hi,
Check the attached sheet to find how to use concatenate. For vertical look
select "wrap text" in alignment tab in format cells.
Anurag
On Tue, Aug 11, 2009 at 4:57 PM, Ruchi Saxena wrote:
> Hi Friends,
>
> I have data in three cell
>
> A1= My Name
> A2= is
> A3= Ruchi
>
> can i have a formu
Hi,
If I understand, you might solve it by doing:
Your Data New Column
Column A Column B
-0.01 =IF(A2=0,0,B1+1)
0 =IF(A3=0,0,B2+1)
-0.002 =IF(A4=0,0,B3+1)
-0.005 =IF(A5=0,0,B4+1)
-0.01 =IF(A6=0,0,B5+1)
-0.004 =IF(A7=0,0,B6+1)
0 =IF(A8=0,0,B7+1)
-0.003 =IF(A9=0,
Hi Ruchi
Here is formula for your reference
=A1&" "&A2&" "&A3
On Aug 11, 4:27 pm, Ruchi Saxena wrote:
> Hi Friends,
>
> I have data in three cell
>
> A1= My Name
> A2= is
> A3= Ruchi
>
> can i have a formula wherein the below info in cell A1,A2 & A3 appears
> in *single
> cell *
>
> i.e. it
20 matches
Mail list logo
