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
function for > filtered range with help of subtotal > > =subtotal(109,D2:D7) > > > > 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

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
> > On Thu, Jul 18, 2013 at 4:11 PM, Smitha S R wrote: > >> 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 Th

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

2013-07-18 Thread Smitha S R
ormulas-excel.php. > > There are also many other sites just google for array formulas or CSE > formulas. > > Regards, > VijayKumar > > > > On Thu, Jul 18, 2013 at 3:36 PM, Smitha S R wrote: > >> Hi Premor, >> >> Thanks for the support, how the {,

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 =TIM

Re: $$Excel-Macros$$ Count

2013-02-07 Thread Smitha S R
>>> 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, Smitha S R wrote: >>> >>>> Hi, >>>> >>>> Please help me in findi

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
; > Rows.Count).End(xlUp).Row).PasteSpecial > End With > Application.CutCopyMode = False > End If > lbl: > Next > End Sub > > note: please insert 1 sheets in ur workbook "OutPut" output sheet will > hold all the data of

$$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
Hi, PFA the file which shows distance in KMS between different places. First Table 'Data' mentions the kms from one place to another and total kms from starting place to ending place. Is it possible to get all probabilities of places in the second table with the kms derived from the first table

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,

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
> > > > On Mon, Aug 20, 2012 at 12:36 PM, Smitha S R wrote: > >> 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

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
gt; Kuldeep Singh > Phone.: +91-120-4763789, Extn.: 789 > naukrikuld...@gmail.com || www.naukri.com > *Please* *Consider the environment. Please don't print this e-mail unless > you really need to.* > > On Thu, Jul 26, 2012 at 11:44 AM, Smitha S R wrote: > >> Hi, >

$$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 violat

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

2012-06-14 Thread Smitha S R
n P* > > > > > > 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, 2012 at 11:1

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
Is it possible to include the items in one sheet to a combo box in other sheet. For example, if in sheet 1 there is names and in the second sheet there is combo box with the heading names. Shall I get the names of other sheet in the combo box as and when I go on adding the names in the first She

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
Hi, I have a drop down list which is created using menu 'data validation'. Is it possible to get the items in the first line in the drop down while start entering the letters of the items. Eg: Item Pen, pencils, Notepad is there in my drop down list, if I start entering P itself Pen and pencils

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
Hi, I have a drop down list which is created using menu 'data validation'. Is it possible to get the items in the first line in the drop down while start entering the letters of the items. Eg: Item Pen, pencils, Notepad is there in my drop down list, if I start entering P itself Pen and pencils

$$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. Poor

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
Hi, PFA the attachment. Office stock consumption statement is attached where I need the help on solving the explained below: .. I need the closing stock of the relevant items from the other work sheet 'closing st n Utlzn-Apr 2012' in the column 'Qty' of the work sheet 'May 2012' if the particul

$$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
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 as Opening stock I need toe get the closing stock of that Particular item, else for Purchase and Issue I have to manually ente