hi Dilip ji
Congratulations to you and Hatsoff u
On Mon, Jan 3, 2011 at 3:35 PM, bhavya khanna wrote:
> Hi Dilip Sir,
>
> Congratulations to you . That is good news on new year 2011. and where is
> treat ?
>
>
> On Mon, Jan 3, 2011 at 3:31 PM, Ayush wrote:
>
>> Dear Group,
>>
>> I am very very
-- Forwarded message --
From: vidyut more
Date: Sun, Dec 19, 2010 at 10:46 AM
Subject: $$Excel-Macros$$ Excel userform & Vlookup List iteam help
To: excel-macros@googlegroups.com
Dear experts
I want use userform and in that a list iwant to use iteam from that
list.More i wan
Dear experts
I want use userform and in that a list iwant to use iteam from that
list.More i want to use vlookup function or similar code when in list box we
enter known iteam then by vlookup its info shold populated on user form and
that data should copy to another sheet.
Thanks
--
On 12/18/10, Richard wrote:
> Is is possible to require a specific entry in a cell, or nothing?
>
> If someone makes an entry in a cell, I want it to be ABC (all upper
> case) and nothing else. It's OK for the cell to be blank.
> How can I do it?
>
> Thanks in advance.
>
> Rich
>
> --
> -
On Thu, Dec 2, 2010 at 12:53 PM, Nikhil Shah wrote:
> Dear All Members,
>
> Here I am postin excel sheet..
>
> *I used vlookup formula plz see attchmt
> *
>
> --
>
> --
> Some important links for excel users:
> 1. Fol
if u try to uncheck zero values from tools option zero value
On Sat, Jul 31, 2010 at 2:02 PM, zp18 wrote:
> I have a bunch of cells that may or may not have numbers in them.
>
> Kind of like this: Sum(e35:e44) , but with no number in e44, I get the
> #Value error. What should be in a "empty" cel
Hi Hari look at this attd file
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/gro
-- Forwarded message --
From: vidyut more
Date: Thu, Jul 22, 2010 at 6:45 PM
Subject: Re: $$Excel-Macros$$ RE: Need macro for attd workbook
To: excel-macros@googlegroups.com
Sir i stuck in your macro. 1 ) filter is not working 2) I have
usecanother macro for that sheet then
Sir i stuck in your macro. 1 ) filter is not working 2) I have
usecanother macro for that sheet then where should i put ur macro. my
macro as follows
'Private Sub Worksheet_Change(ByVal Target As Range)
Dim Cell As Range
Dim pcNum As Long
Dim party As String
Dim prod As String
Dim ws As Worksheet
Thank you so much sir "Dave Bonallack". Its what i was looking for. Thanks again
On Thu, Jul 22, 2010 at 5:37 PM, Dave Bonallack
wrote:
> Hi,
> Have a look at the attached.
> The macro prevents the selection of multiple cells.
> If the selected cell contains data, it will be locked.
> If the sele
Hi respected members.
i want ur help in macro. i v attd sample workbook, in that i want
macro that can protect rows which is not empty and unprotect empty
rows
--
--
Some important links for excel users:
1. Follow us
gt;
> On Mon, Jun 14, 2010 at 12:04 PM, vidyut more wrote:
>>
>> hi
>> it can be done by using sumif and counif formula.plz see attchment
>>
>> --
>>
>> --
>> Some import
sorry i cant get your meaning
On Mon, Jun 14, 2010 at 2:29 PM, Dharmesh Shah wrote:
> Hi
>
> how to display "formula" n yellow box as u done in this sheet?
>
> Dharmesh Shah
>
> On Mon, Jun 14, 2010 at 12:04 PM, vidyut more wrote:
>>
>> hi
hi
it can be done by using sumif and counif formula.plz see attchment
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our Linke
lumn a
> then the entire row mey be edited else will be restricted.
>
> Thanks
> Deepak Kumar
>
> On Wed, May 19, 2010 at 12:53 PM, vidyut more wrote:
>>
>> ------ Forwarded message --
>> From: vidyut more
>> Date: Tue, May 18, 2010 at 10:53 AM
-- Forwarded message --
From: vidyut more
Date: Tue, May 18, 2010 at 10:53 AM
Subject: $$Excel-Macros$$ Need macro
To: excel-macros@googlegroups.com
Hi Dear Member
i want macro code for in excel sheet in which data is entered in any
cell all rows will protected and empty rows
Hi Dear Member
i want macro code for in excel sheet in which data is entered in any
cell all rows will protected and empty rows will unprotected. Plz send
me macro code.
--
--
Some important links for excel users:
1.
I have saved some imgaes,Photos in excel sheet. Can i fetch that by
using VLookup formula.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldaily
59 PM
> To: excel-macros@googlegroups.com
> Subject: Re: $$Excel-Macros$$ Need Help to pickup Rate List for formula
>
>
>
> check the attachment
>
> On Wed, May 5, 2010 at 6:56 PM, vidyut more wrote:
>
> I have at
I have attached sample file. I want formula for picking up rate from
excel sheets. Thanks in advance
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com
I have excel file. Its calculation in option always go Manual from
automatic mode. So all calculation to be made manually. any solution.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tr
you can us counif formula in data validation and use to restrict dulicateentry.
On Sun, Dec 27, 2009 at 3:55 PM, Abdul Rasheed wrote:
>
>
> Can some body tell me that how can we avoid duplication of any Number or
> Alpha-numeric data in any column of excel file.
>
> Waiting for an early response.
To
MRafique
On Sun, Dec 27, 2009 at 2:50 PM, vidyut more wrote:
> U can use this formula. =if(B2=0,0,A1+1)
> I am attacing Excel file.
--
--
Some important links for excel users:
1. Follow us in TWITTER fo
U can use this formula. =if(B2=0,0,A1+1)
--
--
Some important links for excel users:
1. Follow us in TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Fr
-- 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
Wish u Happy Diwali
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Ex
use mround formula for output plz find attachment
>
>
> Input120=mround,5)121122123124125126127128129130
>
>
>
> i want output in this way by using round formula
>
> output120120120125125125125125130130130
>
>
> plz send solution of this problem
> Thanx in advance
>
> Regards,
> Abdul Rasheed
>
Hi,
Dilip I have another query for you. I am attaching excel sheet. in
that sheet i want formula that will look last PC No. of quality no and
add last pc no +1 in new entry. I know it can done by VBA. but iwant
to know can it possible in excel.Thanks in advance.
--~--~-~--~~---
-- Forwarded message --
From: vidyut more
Date: Mon, Aug 31, 2009 at 1:27 PM
Subject: Auto complete list popup windo in excel
To: dilipan...@gmail.com, excel-macros@googlegroups.com
Hi,
Dilip
i know i am taking your time. I want to know is it possible in excel
auto popup windo
Hi,
Dilip
i know i am taking your time. I want to know is it possible in excel
auto popup windo when we type some party name which will appaer like
Tally and other program. I know data validation. but in that we have
to select. any solution. Thanks in advance.
--~--~-~--~~---
Hi Anish
can i use this formula to another sheet extract data from another sheet.
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Tex
,
Attached please find the worksheet wid formula. I just used Data
Validation to create the list of your Q.No. and used below formula..
Hope it Helps.
=SUMPRODUCT(($A$2:$A$211=$F$219)*($C$2:$C$211=G217)*($H$2:$H$211))
Cheers!!
ANISH
On Tue, Aug 25, 2009 at 2:23 PM, vidyut more wrote:
>
&g
Hi
Anish Shrivastava.
its cool
Thnaks a lot
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://
plz find attd. excel file. i want formula for particular q.No. Mtrs on
particular date.
txn in advance.
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tu
hi
can any body give me macro that will lock enire row after entering
data automaticaly.
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video
-- Forwarded message --
From: vidyut more
Date: Sat, Jun 27, 2009 at 10:44 AM
Subject: $$Excel-Macros$$ Fwd: Need help regarding formula
To: excel-macros@googlegroups.com
-- Forwarded message --
From: vidyut more
Date: Wed, Jun 24, 2009 at 2:47 PM
Subject: Need
Hi
Tertius.
-- Forwarded message --
From: TERTIUS KOSHY THOMAS
Date: Mon, Jun 29, 2009 at 6:52 AM
Subject: $$Excel-Macros$$ Condition Checking
To: excel-macros@googlegroups.com
Hi all,
Can you help me with a small query regarding a condition checking
using formula.
Please f
-- Forwarded message --
From: vidyut more
Date: Wed, Jun 24, 2009 at 2:47 PM
Subject: Need help regarding formula
To: mac...@googlegroups.com, karthikb...@rediffmail.com, vidyut
Hi
i need formula in worksheet i have attached. that could automaticly
serach last Pc No of
38 matches
Mail list logo
