Re: $$Excel-Macros$$ Datavalidation

2013-08-27 Thread Smitha S R
Hi , Please help.. On Tue, Aug 27, 2013 at 11:53 AM, Smitha S R wrote: > Hi, > > Please suggest option to prevent copy paste in cells with data validation . > Please suggest other than macros > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?

$$Excel-Macros$$ Datavalidation

2013-08-26 Thread Smitha S R
Hi, Please suggest option to prevent copy paste in cells with data validation . Please suggest other than macros -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Total of values

2013-07-18 Thread Smitha S R
* **Thats All (^.^)* > > After we know the main concept of that formulas, we can solve your next > question with this formula > * > =SUM(IFERROR((Sheet1!$A$3:$G$6=$A4)*(Sheet1!$C$3:$I$6),0)) => *Red Value > Shifted 2 Column* > ** > *Rgds, > [dp] > > > Pada 18/07/20

Re: $$Excel-Macros$$ Total of values

2013-07-18 Thread Smitha S R
Hi Dileep, Thanks for your suggestion, but if there is lot of columns to be summed up, applying formula one by one column will be hectic On Thu, Jul 18, 2013 at 6:07 PM, Dileep Kumar wrote: > Hi Smitha, > > if your format your data in table form which includes date column then

Re: $$Excel-Macros$$ Total of values

2013-07-18 Thread Smitha S R
Hi premor, Please help On Thu, Jul 18, 2013 at 5:33 PM, Smitha S R wrote: > > Hi, > > PFA the attachement, I have applied the formula suggested by De Premor, > but after including one more column. Now the formula is not working. > Please help. > > > On T

Re: $$Excel-Macros$$ Total of values

2013-07-18 Thread Smitha S R
Hi, PFA the attachement, I have applied the formula suggested by De Premor, but after including one more column. Now the formula is not working. Please help. On Thu, Jul 18, 2013 at 4:25 PM, P.VIJAYKUMAR wrote: > Respected Smitha, > > Array formulas do not allow adding or deletin

Re: $$Excel-Macros$$ Total of values

2013-07-18 Thread Smitha S R
Thanks a lot Vijay, Applying the formula suggested by Premor works. but if I insert one column in between before values. values becomes zero. Please help out. On Thu, Jul 18, 2013 at 4:07 PM, P.VIJAYKUMAR wrote: > Respected Smitha, > > The braces appear by pressing Ctrl+Shift+E

Re: $$Excel-Macros$$ Total of values

2013-07-18 Thread Smitha S R
Hi Premor, Thanks for the support, how the {, braces appear there? and by removing that formala is not working On Thu, Jul 18, 2013 at 1:46 PM, De Premor wrote: > Is like attached ? > > > On 18/07/2013 14:52, Smitha S R wrote: > > Hi Team, > > Any one please hel

Re: $$Excel-Macros$$ Total of values

2013-07-18 Thread Smitha S R
Hi Team, Any one please help on this, as I am stuck with one report and can move forward only after solving this. On Thu, Jul 18, 2013 at 12:57 PM, Smitha S R wrote: > Hi Team, > > PFA the work book, I have to get the total values in all the column in > another sheet wherever t

$$Excel-Macros$$ Total of values

2013-07-18 Thread Smitha S R
Hi Team, PFA the work book, I have to get the total values in all the column in another sheet wherever the same name appears. Please see the attachment and help it at the earliest. Assume that the values are there for 30 columns. Thanks Smitha -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel

Re: $$Excel-Macros$$ selecting the word from a list with the first letter.

2013-04-23 Thread Smitha S R
Hi, I am sure that this is possible, but don't know how to work out. On Tue, Apr 23, 2013 at 1:39 PM, priti verma wrote: > Hi Smitha, > This is not possible.erma > thanks > Priti v > > > > On Tue, Apr 23, 2013 at 1:25 PM, Smitha S R wrot

Re: $$Excel-Macros$$ Excel Add-in (that enables Auto-complete)

2013-04-23 Thread Smitha S R
what is the option for the same in Excel 2007 On Mon, Apr 22, 2013 at 1:13 PM, ravinder negi wrote: > you can use auto corrrect feature which will replace off into Office > Supplies. > > Just go to file->option->proofing->autocorrect, type off in replace box > and office Supplies in with box. >

Re: $$Excel-Macros$$ selecting the word from a list with the first letter.

2013-04-23 Thread Smitha S R
Hi, Please help.. -- Forwarded message -- From: Smitha S R Date: Mon, Apr 22, 2013 at 5:08 PM Subject: Fwd: $$Excel-Macros$$ selecting the word from a list with the first letter. To: excel-macros@googlegroups.com Hi, Anyone please help in this regard. -- Forwarded

Fwd: $$Excel-Macros$$ selecting the word from a list with the first letter.

2013-04-22 Thread Smitha S R
Hi, Anyone please help in this regard. -- Forwarded message -- From: Smitha S R Date: Mon, Apr 22, 2013 at 3:54 PM Subject: Re: $$Excel-Macros$$ selecting the word from a list with the first letter. To: excel-macros@googlegroups.com Hi, PFA the updated list, where in one

Re: $$Excel-Macros$$ selecting the word from a list with the first letter.

2013-04-22 Thread Smitha S R
his > > > On Mon, Apr 22, 2013 at 3:34 PM, Smitha S R wrote: > >> Hi. >> >> Please help me in selecting the word from a list as soon as I start >> entering the first letter. >> >> I have a list of Stationery items. PFA the list. >> >> &g

$$Excel-Macros$$ selecting the word from a list with the first letter.

2013-04-22 Thread Smitha S R
Hi. Please help me in selecting the word from a list as soon as I start entering the first letter. I have a list of Stationery items. PFA the list. Please solve this without a macro if possible. Thanks Smitha -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

Re: $$Excel-Macros$$ Count

2013-02-07 Thread Smitha S R
Hi, Required is : Count of names matching product 'A' and Id '1S' is 4 and count of names matching product 'A' and ID '2B' is 4 On Thu, Feb 7, 2013 at 2:40 PM, Aamir Shahzad wrote: > check now > > =COUNTIFS($A$2:$A$10,A5,$B$2:$B$10,B5,$C$2:$C$10

Re: $$Excel-Macros$$ Count

2013-02-07 Thread Smitha S R
Hi, This formula does not suit my requirement. I have to count the names matching the product and ID. On Thu, Feb 7, 2013 at 2:09 PM, Aamir Shahzad wrote: > You can use: > > =COUNTIFS($A$2:$A$10,A2,$B$2:$B$10,B2) > > Aamir Shahzad > > On Thu, Feb 7, 2013 at 1:36 PM, Smith

$$Excel-Macros$$ Count

2013-02-07 Thread Smitha S R
Hi, Please help me in finding the count of unique values matching criteria as in the attachment. Regard Smitha -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ please correct the formula

2013-01-13 Thread Smitha S R
))-INDIRECT("'sheet1'!"&"C"&MATCH(B2,Sheet1!$B$1:$B$5,0)))" > or check attachment. > > On Sun, Jan 13, 2013 at 2:21 PM, Smitha S R wrote: > >> Hi, >> >> PFA the statement and correct the formula I have used. >> Its showi

Re: $$Excel-Macros$$ please correct the formula

2013-01-13 Thread Smitha S R
why we have to press CTRL+SHIFT+ENTER. Its taking a lot of time to process the same. On Sun, Jan 13, 2013 at 2:46 PM, ashish koul wrote: > try attached workbook > > > On Sun, Jan 13, 2013 at 2:31 PM, Smitha S R wrote: > >> HI, >> Tried but returns #VALUE >> &

Re: $$Excel-Macros$$ Re: Prince Kumar - Most Helpful Member December'12

2013-01-13 Thread Smitha S R
Congrats Prince. I too want to learn excel in depth, advance, want to become excel expert. I always search net for excel materials, but cannot make a step by step study. Please help me and advice me to complete my wish, also suggest any materials so that I can buy from the shop, which is useful a

Re: $$Excel-Macros$$ please correct the formula

2013-01-13 Thread Smitha S R
) > > > press CTRL+SHIFT+ENTER > > > On Sun, Jan 13, 2013 at 2:21 PM, Smitha S R wrote: > >> Hi, >> >> PFA the statement and correct the formula I have used. >> Its showing sum errors >> >> -- >> Join official Facebook page of this for

Re: $$Excel-Macros$$ merge data

2013-01-13 Thread Smitha S R
Hi, Can you explain the macro used On Fri, Jan 11, 2013 at 1:19 PM, Prince wrote: > hi Smitha, > > > please get this > > Public Sub CombineData() > > Public Sub CombineData() > > Dim wks As Worksheet > > For Each wks In ThisWorkbook.Worksheet

$$Excel-Macros$$ please correct the formula

2013-01-13 Thread Smitha S R
Hi, PFA the statement and correct the formula I have used. Its showing sum errors -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem,

Re: $$Excel-Macros$$ Probability

2013-01-13 Thread Smitha S R
thanks a lot On Sat, Jan 12, 2013 at 8:55 PM, >>Excel Beginner<< wrote: > Hi, > > Please find the attachment. > > > > > -- > *Regards,* > * > * > *Excel Beginner* > On Thu, Jan 10, 2013 at 2:52 PM, Smitha S R wrote: > >>

Re: $$Excel-Macros$$ merge data

2013-01-10 Thread Smitha S R
chin/excel-macros/merge/excel-macros/8T3EPECvA10/Y3vwNk6wM-YJ> > > > On Friday, January 11, 2013 12:20:39 PM UTC+5:30, Smitha S R wrote: > >> NO,PLEASE send it once more >> >> On Fri, Jan 11, 2013 at 12:14 PM, Prince wrote: >> >>> dear >>

Re: $$Excel-Macros$$ merge data

2013-01-10 Thread Smitha S R
Hi, Any one please help me in combining the data in two different work sheets in to another worksheet. Its really urgent. On Fri, Jan 11, 2013 at 12:30 PM, Smitha S R wrote: > It not working, run time error 1004 appears > > On Fri, Jan 11, 2013 at 12:23 PM, Prince wrote: &

Re: $$Excel-Macros$$ merge data

2013-01-10 Thread Smitha S R
NO,PLEASE send it once more On Fri, Jan 11, 2013 at 12:14 PM, Prince wrote: > dear > > have you seen that lik i have provided > > > > On Friday, January 11, 2013 11:58:33 AM UTC+5:30, Smitha S R wrote: > >> HI, >> >> is this possible.. >> >&g

Re: $$Excel-Macros$$ merge data

2013-01-10 Thread Smitha S R
HI, is this possible.. On Fri, Jan 11, 2013 at 11:28 AM, Smitha S R wrote: > Hi, > > Please help > > > On Fri, Jan 11, 2013 at 11:14 AM, Smitha S R wrote: > >> HI, >> >> Is this possible without macros >> >> On Fri, Jan 11, 2013 at 11:12

Re: $$Excel-Macros$$ merge data

2013-01-10 Thread Smitha S R
Hi, Please help On Fri, Jan 11, 2013 at 11:14 AM, Smitha S R wrote: > HI, > > Is this possible without macros > > On Fri, Jan 11, 2013 at 11:12 AM, ashish koul wrote: > >> Try this >> >> Sub merge1() >> Dim i As Long, z As Long >> ' add ne

Re: $$Excel-Macros$$ merge data

2013-01-10 Thread Smitha S R
Sheets("Merge").Range("a" & > Sheets("Merge").Range("a1048576").End(xlUp).Row + 1) > End If > Next > End Sub > > > > On Fri, Jan 11, 2013 at 11:05 AM, NOORAIN ANSARI > wrote: > >> Hi Smitha, >> >> can shar

Re: $$Excel-Macros$$ merge data

2013-01-10 Thread Smitha S R
HI, Data for the first jan is in one sheet and data for second jan is another sheet. I have to get data in another worksheet for both dates. On Fri, Jan 11, 2013 at 11:05 AM, NOORAIN ANSARI wrote: > Hi Smitha, > > can share a sample with group. > > > > On Fri, Jan 11, 2013

$$Excel-Macros$$ merge data

2013-01-10 Thread Smitha S R
Hi, How to merge data in two excel worksheets to another work sheet -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem,

Fwd: $$Excel-Macros$$ Probability

2013-01-10 Thread Smitha S R
Hi Noorain Can you please help me on this. -- Forwarded message -- From: Smitha S R Date: Thu, Jan 10, 2013 at 5:18 PM Subject: Re: $$Excel-Macros$$ Probability To: excel-macros@googlegroups.com Hi, I need mix of all the places with the kms derived from the data table for eg

Re: $$Excel-Macros$$ Probability

2013-01-10 Thread Smitha S R
C > A D > B A > B C > B D > B Ending Place > C A > C B > C D > C Ending Place > D A > D B > D C > D Ending Place > > Regards, > Lalit Mohan > > > On Thursday, 10 January 2013 16:04:59 UTC+5:30, Smitha S R wrote: > >> Hi, >> >

Fwd: $$Excel-Macros$$ Probability

2013-01-10 Thread Smitha S R
Hi, Can any one help on this -- Forwarded message -- From: Smitha S R Date: Thu, Jan 10, 2013 at 2:52 PM Subject: $$Excel-Macros$$ Probability To: excel-macros@googlegroups.com Hi, PFA the file which shows distance in KMS between different places. First Table 'Data'

$$Excel-Macros$$ Probability

2013-01-10 Thread Smitha S R
irst table 'data'. Please help in solving this Regards Smitha -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Prob

Re: $$Excel-Macros$$ office stationery template

2013-01-06 Thread Smitha S R
Hi, Anyone please send me some good excel template to maintain the office stationery items, their consumption, opening stock , closing stock, and reports on monthly basis and daily basis On Sun, Jan 6, 2013 at 1:40 PM, Smitha S R wrote: > Hi, > Anyone please send me ome good excel templ

Re: $$Excel-Macros$$ office stationery template

2013-01-06 Thread Smitha S R
no attachment found On Sun, Jan 6, 2013 at 2:09 PM, wrote: > ** > Google.com > Sent from BlackBerry® on Airtel > -- > *From: * Smitha S R > *Sender: * excel-macros@googlegroups.com > *Date: *Sun, 6 Jan 2013 13:40:51 +0530 > *To: * &g

Re: $$Excel-Macros$$ office stationery template

2013-01-06 Thread Smitha S R
Hi, Anyone please send me ome good excel template to maintain the office stationery items, their consumption, opening stock , closing stock, and reports on monthly basis and daily basis On Sun, Jan 6, 2013 at 9:30 AM, Smitha S R wrote: > HI, > > Can anyone send some good excel te

$$Excel-Macros$$ office stationery template

2013-01-05 Thread Smitha S R
HI, Can anyone send some good excel template to maintain the office stationery items, their consumption, opening stock , closing stock, and reports on monthly basis and daily basis -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise,

$$Excel-Macros$$ Using VBA Macros to create a Purchase order form

2012-12-10 Thread Smitha Ambekar
Hi - I am creating a purchase order form on excel and want to use macros to automate the process of saving and sending emails to supervisors for purchase order approval. I am new to Macros and vba and would want some help to get this process. Thanks. -- Join official Facebook page of this f

Re: $$Excel-Macros$$ conditional formatting

2012-08-20 Thread Smitha S R
please help me On Mon, Aug 20, 2012 at 1:59 PM, Smitha S R wrote: > Hi Ashish, > I apply the said formula, its counting 'Not Ok" also and filling the same > colour. > > > On Mon, Aug 20, 2012 at 12:40 PM, ashish koul wrote: > >> >> >> select ra

Re: $$Excel-Macros$$ conditional formatting

2012-08-20 Thread Smitha S R
Hi Ashish, I apply the said formula, its counting 'Not Ok" also and filling the same colour. On Mon, Aug 20, 2012 at 12:40 PM, ashish koul wrote: > > > select range a2:d2 then use > =COUNTIF($A$2:$D$2,"ok")>=1 > > > > > [image: Inline image 1]

Re: $$Excel-Macros$$ conditional formatting

2012-08-20 Thread Smitha S R
HI, some one please help me on this. On Mon, Aug 20, 2012 at 12:20 PM, Smitha S R wrote: > Hi, > > If one cell contain a specific Text "On", the whole row from A2 to D2 > should be filled with yellow colour. How can it be? > > -- > Join official facebo

$$Excel-Macros$$ conditional formatting

2012-08-19 Thread Smitha S R
Hi, If one cell contain a specific Text "On", the whole row from A2 to D2 should be filled with yellow colour. How can it be? -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate

$$Excel-Macros$$ conditional formatting

2012-08-19 Thread Smitha S R
Hi, If one cell contain a specific Text "On", the whole row from A2 to D2 should be filled with yellow colour. How can it be? -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate

Re: $$Excel-Macros$$ conditional formatting

2012-08-19 Thread Smitha S R
Hi, If one cell value is a specific text like "On", the whole row from A2 to D2 should be filled with yellow colour. How can it be? On Thu, Jul 26, 2012 at 12:25 PM, Kuldeep Singh wrote: > > Dear Smitha, > > Please try this. (Sheet - 1 & Sheet - 2) > > Regards, &

$$Excel-Macros$$ conditional formatting

2012-07-25 Thread Smitha S R
Hi, Please help in conditional formatting or use of if formula in the following case. Excel attached. Closing Stock Verification stock required 1 1 if closing Stock=Verification Stock blue colour should be filled in cell B3 5 4 if closing Stock>Verification Stock green colour should be fille

Re: $$Excel-Macros$$ Merge cells in table

2012-06-20 Thread Smitha S R
ase* *Consider the environment. Please don't print this e-mail unless > you really need to.* > > > On Wed, Jun 20, 2012 at 5:40 PM, Smitha S R wrote: > >> How to merge cells in a table. >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >

$$Excel-Macros$$ Merge cells in table

2012-06-20 Thread Smitha S R
How to merge cells in a table. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don

$$Excel-Macros$$ vlookup -please help on the attachment

2012-06-17 Thread Smitha S R
Hi, PFA my vlookup table. If I select the nature of expenses, corresponding expenses main head should come from the second worksheet anemd data2. But the main head coming in the first work sheet is wrong. Please help on this. Regards Smitha -- FORUM RULES (986+ members already BANNED for

Re: $$Excel-Macros$$ delete blank columns

2012-06-14 Thread Smitha S R
HI, Please help on this without any macros. On Fri, Jun 15, 2012 at 11:33 AM, Deba Ranjan wrote: > Hi Smitha, > > Please find the attached sample file. it will help you out. i have got > this file from my e-book sample file. > > > Thanks & Regards, > *Deba Ranja

Re: $$Excel-Macros$$ delete blank columns

2012-06-14 Thread Smitha S R
Hi Noorain, Can you please tell me how to delete blank columns in data sheet? On Fri, Jun 15, 2012 at 11:27 AM, Smitha S R wrote: > Hi, > > Any one please help me in deleting all blank columns in a data report with > many filled rows and columns. > > > On Fri, Jun 15, 201

Re: $$Excel-Macros$$ delete blank columns

2012-06-14 Thread Smitha S R
Hi, Any one please help me in deleting all blank columns in a data report with many filled rows and columns. On Fri, Jun 15, 2012 at 11:11 AM, Smitha S R wrote: > How to delete all blank columns arising between various rows and columns? > > -- > FORUM RULES (986+ members alread

$$Excel-Macros$$ delete blank columns

2012-06-14 Thread Smitha S R
How to delete all blank columns arising between various rows and columns? -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quic

Re: $$Excel-Macros$$ Combo box

2012-06-14 Thread Smitha S R
, Smitha S R wrote: > Thanks Noorain. Its working. > > Shall I get the codes or basics to study on these codes so that I can use > the controls in excel and make them working in a simple way. > Please do send me any material with the basics of codes, so that I can > understand the u

Re: $$Excel-Macros$$ Combo box

2012-06-14 Thread Smitha S R
x27;t have any experience in programming or else... On Thu, Jun 14, 2012 at 3:13 PM, NOORAIN ANSARI wrote: > Hi Smitha, > > Check this one.. > > > On Thu, Jun 14, 2012 at 3:09 PM, Smitha S R wrote: > >> Hi, >> >> Its not working. >> >> >

Re: $$Excel-Macros$$ Combo box

2012-06-14 Thread Smitha S R
Hi, Its not working. On Thu, Jun 14, 2012 at 3:01 PM, NOORAIN ANSARI wrote: > Hi Smitha, > > Please see atached sheet.- > > > > - > Thanks & regards, > Noorain Ansari > www.noorainansari.com > www.excelmacroworld.blogspot.com > > On Thu, Jun 14, 201

$$Excel-Macros$$ Combo box

2012-06-14 Thread Smitha S R
Sheet? Regards Smitha -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't p

Re: $$Excel-Macros$$ Need a file on commonly used Formulas and Functions for MS Excel 2010

2012-06-06 Thread Smitha S R
Hi Noorain, How did you make the Home page for this . I too want to make a similar one for showing reports. If I click on one tab, it show the details of the item shown in the tab. Please help me in doing such a similar home page. On Wed, Jun 6, 2012 at 10:54 PM, NOORAIN ANSARI wrote: > Hi Poo

Re: $$Excel-Macros$$ Graph

2012-06-05 Thread Smitha S R
ma* > > *+91 7838100659 [IM-Gtalk]* > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Smitha S R > *Sent:* 05 June 2012 3:25 > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Graph > > ** ** &

Re: $$Excel-Macros$$ Graph

2012-06-05 Thread Smitha S R
Please help on the graph preparation On Tue, Jun 5, 2012 at 3:25 PM, Smitha S R wrote: > Hi, > > Please help me in drawing the graph, as per the attachment. > Need a graph , month wise where the employee growth, cost wise growth and > team could be identified . > >

$$Excel-Macros$$ Graph

2012-06-05 Thread Smitha S R
Hi, Please help me in drawing the graph, as per the attachment. Need a graph , month wise where the employee growth, cost wise growth and team could be identified . -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please

$$Excel-Macros$$ combo box in excel

2012-05-29 Thread Smitha S R
How we can place a combo box in excel work sheet? -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not b

Re: $$Excel-Macros$$ Drop down list

2012-05-29 Thread Smitha S R
Hi anil, How you placed the combo box in Excel? On Fri, May 25, 2012 at 1:27 PM, Smitha S R wrote: > Is this possible in dropdown list as you have prepared using combo box? > > > On Tue, May 22, 2012 at 10:05 AM, Anil Gawli wrote: > >> your attached file is corrupte

$$Excel-Macros$$ Please help on the data validation

2012-05-29 Thread Smitha S R
nd pencils should come in the first line. Please help on this, if this is possible in data validation Thanks Smitha -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Co

Re: $$Excel-Macros$$ Drop down list

2012-05-25 Thread Smitha S R
t;> >> >> 2012/5/21 Anil Gawli >> >>> with data validation i don't think so, i have prepared in combo box >>> control. >>> Is it Ok? >>> >>> >>> >>> On Mon, May 21, 2012 at 3:53 PM, Smitha S R wrote: >>>

Re: $$Excel-Macros$$ Drop down list

2012-05-21 Thread Smitha S R
start entering P itself Pen and pencils should come in the first line.) On Mon, May 21, 2012 at 2:28 PM, Anil Gawli wrote: > File attached FYI > > > On Mon, May 21, 2012 at 1:50 PM, Smitha S R wrote: > >> Hi, >> >> I have a drop down list which is created using me

$$Excel-Macros$$ Drop down list

2012-05-21 Thread Smitha S R
nd pencils should come in the first line. Please help on this Thanks Smitha -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not

$$Excel-Macros$$ IF Function

2012-05-16 Thread Smitha S R
How can we add so many conditions in IF function? -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not

Re: $$Excel-Macros$$ suggest a formula on this attachement

2012-05-16 Thread Smitha S R
Hi, Please correct my formula on this attachment. On Wed, May 16, 2012 at 2:31 PM, Smitha S R wrote: > Hi, > > Please suggest a formula on this attachment. > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles.

$$Excel-Macros$$ suggest a formula on this attachement

2012-05-16 Thread Smitha S R
Hi, Please suggest a formula on this attachment. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not b

$$Excel-Macros$$ Office stock

2012-05-09 Thread Smitha S R
Hi PFA the stock statement where I need help in the Dashboard. If I select, the item I need the relevant closing stock in the next cell. My formula is not working. Please help. Thanks Smitha -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles

Re: $$Excel-Macros$$ office stock-help

2012-05-09 Thread Smitha S R
Thanks alot On Wed, May 9, 2012 at 3:25 PM, Maries wrote: > I think MACRO IS NOT ENABLED. When you open file, Security warning show > under Ribbon. Click options ==> Select Enable this content ==> Press ok. > > Try now... > > On Wed, May 9, 2012 at 11:57 AM, Sm

Re: $$Excel-Macros$$ office stock-help

2012-05-09 Thread Smitha S R
Or Target.Column <> 2 Then Exit Sub > If Target.Value = "Opening Stock" Then > Target.Offset(0, 3) = "=VLOOKUP(RC[-1],'Closing St n Utlzn-Apr > 2012'!R2C1:R65C3,3,FALSE)" > Else > Target.Offset(0, 3) = "" > End If > End Sub > > R

Re: $$Excel-Macros$$ office stock-help

2012-05-08 Thread Smitha S R
ing datas... > > =VLOOKUP(D2,'Closing St n Utlzn-Apr 2012'!$A$2:$C$65,3,FALSE) > > Regards, > > MARIES. > > > On Tue, May 8, 2012 at 9:31 PM, Smitha S R wrote: > >> Hi, >> >> PFA the attachment. >> >> Office stock consumption statement is

$$Excel-Macros$$ office stock-help

2012-05-08 Thread Smitha S R
t 'May 2012' if the particulars is selected as Opening stock in the same work sheet and if its selected as Purchase or issue, I have to manually enter the quantity -- Please help at the earliest. Thanks& Regards Smitha -- FORUM RULES (986+ members already BANNED for violation) 1) U

$$Excel-Macros$$ Office stock consumption - formula needed to solve the attached.

2012-05-06 Thread Smitha S R
On Sun, May 6, 2012 at 2:37 PM, Smitha S R wrote: > Hi, > > > > Any one please help: > > > > PFA the attachment of office stock. > > > > One sheet shows the closing stock of stationery items. > > > > In the second sheet, if I select particulars

$$Excel-Macros$$

2012-05-06 Thread Smitha S R
enter the quantity, no need of closing stock from the first sheet, Please help on this as my formula on the sheet is not working. Regards Smitha -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent

RE: $$Excel-Macros$$ Formula to sum a range of cells satisfying a particular criteria

2011-11-29 Thread smitha
easy solution would be Sumif Function. See attached. Regards, Manish On Tue, Nov 29, 2011 at 2:53 PM, smitha.kumari wrote: Hi, PFA the expense sheet and suggest a formula to solve the problem as mentioned in the attachment. Regards Smitha -- FORUM RULES (934+ members

RE: $$Excel-Macros$$ stop receiving mail in this mail id

2011-11-29 Thread smitha
/excel-macros/subscribe click on unsubscribe On Tue, Nov 29, 2011 at 1:06 PM, smitha.kumari wrote: Sorry, I didn't find the way to unsubscribe. Please help Regards Smitha From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI