RE: $$Excel-Macros$$ how to get month Occurrence in no.
Thanks! Not my own though. Learnt it on another group. Happy to pass it on. Regards - Dave Date: Tue, 28 Dec 2010 17:44:51 +0530 Subject: Re: $$Excel-Macros$$ how to get month Occurrence in no. From: dilipan...@gmail.com To: excel-macros@googlegroups.com Impressive ..!! Good show Dave, Siti, STDEV :) Best Regards, DILIPandey On Tue, Dec 28, 2010 at 4:13 PM, Dave Bonallack davebonall...@hotmail.com wrote: Hi, A shorter version would be: =MONTH(--(1A1)) This works for 3-lettered abbreviatios (eg Mar, Oct) as well as extended abbreviations (eg Sept) and also unabbreviated (eg June, November) Regards - Dave. Date: Tue, 28 Dec 2010 15:34:01 +0700 Subject: Re: $$Excel-Macros$$ how to get month Occurrence in no. From: villager.g...@gmail.com To: excel-macros@googlegroups.com If the word April or another month name is type correctly in cell A1 try this formula in B1 =TEXT(DATEVALUE(1 A1 2010),M) On Tue, Dec 28, 2010 at 1:56 PM, Rohan Young rohan.j...@gmail.com wrote: Hi experts, is there any formula, if i only type in cell April and the other cell return the value 4, remember if i type simply April not 04/01/2010 etc. etc. please provide your feedback thanks regards ROHAN 9818247278, 8860567680 -- -- 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/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India -- -- 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/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
RE: $$Excel-Macros$$ Nested IF functions?
Hi, To just do the 3 levels you asked about, try: =IF(B16500,3.5,IF(B161000,2.75,2.25)) Regards - Dave. Date: Tue, 28 Dec 2010 20:18:30 +0530 Subject: Re: $$Excel-Macros$$ Nested IF functions? From: dilipan...@gmail.com To: excel-macros@googlegroups.com Hi J D, á It would be really appreciable if you can share a test file on this.á Help us to help you :) á Best Regards, DILIPandey On Tue, Dec 28, 2010 at 7:36 AM, J D springer...@gmail.com wrote: I am a concrete estimator who is trying to create some cut and paste Estimate line items I can just grab from one spread sheet and paste in to my estimate. I was refining one and tried to use the IF function to pick the number of labor hours based on sq footage. áMore s.f. and we are more productive therefore less hours per s.f. I was trying to say if less that 500 s.f. then .035 hrs/s.f. á500 to 1,000 then .0275 hrs/s.f. 1,000 s.f. then .0225 hours/s.f. I could get one working but wanted to know how to get more going choises out of one formula. áAttached is the assembly and the formula below it. Form, place and finish ~ (__) s.f. of 4 broom swept finish concrete sidewalk. áConcrete to be 3,500 psi and reinforced with 6 x 6 , w1.4/ w1.4 wwf. á á á á á á á á á á á á á á á á á á á á á á á á á á á á á á á á á á á $4,410.00 á á á áArea á á990 á á s.f. á áPerimeter á á á 114 á á l.f. Concrete á á á á990 á á 0.33 á á1.03 á á336.501 12.463 á13 á á á145 á á 1885 Labor á 13 á á á0.4 á á 5.2 á á á á á á á á á á 5.2 á á 40 á á á208 wwf á á 990 á á 40 á á á24.75 á á á á á á á á á 25 á á á7 á á á 175 2 SB á 990 á á 0.26 á á257.4 á á á á á á á á á 260 á á 0.49 á á127.4 Labor á 990 á á 0.003 á 2.97 á á á á á á á á á á3 á á á 40 á á á120 Poly á á990 á á 1800 á á0.55 á á á á á á á á á á0.6 á á 85 á á á51 Labor á 990 á á 0.002 á 1.98 á á á á á á á á á á2 á á á 40 á á á80 Expansion á á á 990 á á 0.25 á á247.5 á 100 á á 2.475 á 2.5 á á 31.64 á 79.1 Labor á 250 á á 0.01 á á2.5 á á á á á á á á á á 2.5 á á 40 á á á100 Curing á640 á á 350 á á 1.828571429 á á 5 á á á 0.365714286 á á 0.4 á á 55 á á á22 Labor á 990 á á 0.003 á 2.97 á á á á á á á á á á3 á á á 40 á á á120 2 x 4 á 114 á á 16 á á á7.125 á á á á á á á á á 8 á á á 5.81 á á46.48 Labor á 114 á á 0.33 á á37.62 á 0.2 á á 7.524 á 7.6 á á 40 á á á304 Finish á990 á á 100 á á 9.9 á á 2.75 á á27.225 á27.3 á á40 á á á1092 á á á á á á á á á á á á á á á á á á á á á á á á á á á á á á á á4409.98 =IF(B16500,3.5,2.75) -- -- 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/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- Thanks Regards, DILIP KUMAR PANDEYá á MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India -- -- 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/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
$$Excel-Macros$$ Re: Learning Macro
Hi Anand, Thanks for your valuable suggestion. Pls fwd me the link for ebook. I want ebook on Excel VBA. Thanks in advance !! :) Regds, Manish Pansari On Dec 9, 12:28 pm, anandydr anand...@gmail.com wrote: Hi, If you do a google search for the term MS Excel VBA tutorials you will find a lot of websites for that. The best way would be to take a task that you do repeatedly and start creating a macro for it. Learning from one project you will eventually learn how to automate a lot of tasks. In case you need ebooks or further help on problems you encounter feel free to post on the group or mail me at anand...@gmail.com Hope that helps, Anand Kumar On Dec 9, 10:31 am, balbirkumar . balbirku...@sify.com wrote: Dear Friends, I dont know how create macros in excel and how and what codes are used for its creation. But, I am interested in Knowing them. Please suggest me from where i could learn. With Thanks Regards -- Balbir Kumar- Hide quoted text - - Show quoted text - -- -- 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/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Nested IF functions?
done using vlookup.. refer attached file On Tue, Dec 28, 2010 at 8:18 PM, Dilip Pandey dilipan...@gmail.com wrote: Hi J D, It would be really appreciable if you can share a test file on this. Help us to help you :) Best Regards, DILIPandey On Tue, Dec 28, 2010 at 7:36 AM, J D springer...@gmail.com wrote: I am a concrete estimator who is trying to create some cut and paste Estimate line items I can just grab from one spread sheet and paste in to my estimate. I was refining one and tried to use the IF function to pick the number of labor hours based on sq footage. More s.f. and we are more productive therefore less hours per s.f. I was trying to say if less that 500 s.f. then .035 hrs/s.f. 500 to 1,000 then .0275 hrs/s.f. 1,000 s.f. then .0225 hours/s.f. I could get one working but wanted to know how to get more going choises out of one formula. Attached is the assembly and the formula below it. Form, place and finish ~ (__) s.f. of 4 broom swept finish concrete sidewalk. Concrete to be 3,500 psi and reinforced with 6 x 6 , w1.4/ w1.4 wwf. $4,410.00 Area990 s.f.Perimeter 114 l.f. Concrete990 0.331.03336.501 12.463 13 145 1885 Labor 13 0.4 5.2 5.2 40 208 wwf 990 40 24.75 25 7 175 2 SB 990 0.26257.4 260 0.49127.4 Labor 990 0.003 2.973 40 120 Poly990 18000.550.6 85 51 Labor 990 0.002 1.982 40 80 Expansion 990 0.25247.5 100 2.475 2.5 31.64 79.1 Labor 250 0.012.5 2.5 40 100 Curing 640 350 1.828571429 5 0.365714286 0.4 55 22 Labor 990 0.003 2.973 40 120 2 x 4 114 16 7.125 8 5.8146.48 Labor 114 0.3337.62 0.2 7.524 7.6 40 304 Finish 990 100 9.9 2.7527.225 27.340 1092 4409.98 =IF(B16500,3.5,2.75) -- -- 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/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India -- -- 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/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- Srinivasan Ethirajalu, +919677042736 -- -- 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/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts sft.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ How to hide/filter rows?
Hello, so i have this 1+ rows excel sheet. Each row containins a name and a price - each in its own column. A name may appear various times. How can i filter the rows in order to display only one row for a given name. The one row i'd like to display is the one with the highest price. How can this be done in excel? Thanks, W. -- -- 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/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Nested IF functions?
Thanks. I have the Syntax correct now but how do I end it. I want to write a formula that would return the right answer for the below. if A3 500 value will be 3.5 if 500A31000 then value will be 3 if A31000 then value will be 2.5 I entered =IF(A3500,3.5,IF(500A31000,3,IF(A31000,2.5 and got False for an answer. I want to type into A3 a s.f. number and have the formula kick out one of the 3 or more possibilities so I can use the correct value in the next equation. Hope this is clearer. Thanks On Dec 28, 4:29 am, hanumant shinde arsfan2...@yahoo.co.in wrote: i dont understand what u mean exactly but i will jus tell u abt nested if in excel. let me know if you wanna know nesed if for Macro. it is if else function. so write if and give some value if is its true and in place of else write another if. if you wanna know the syntax refer help in excel. just type in IF and you will get everything there. e.g. =IF(A3=3,Equal,IF(A33,Less,IF(A33,Greater))) explaination if A3 = 3 value wil be Equal if A33 then value will be Less if A33 then value will be Greater - Original Message From: J D springer...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Tue, 28 December, 2010 7:36:57 AM Subject: $$Excel-Macros$$ Nested IF functions? I am a concrete estimator who is trying to create some cut and paste Estimate line items I can just grab from one spread sheet and paste in to my estimate. I was refining one and tried to use the IF function to pick the number of labor hours based on sq footage. More s.f. and we are more productive therefore less hours per s.f. I was trying to say if less that 500 s.f. then .035 hrs/s.f. 500 to 1,000 then .0275 hrs/s.f. 1,000 s.f. then .0225 hours/s.f. I could get one working but wanted to know how to get more going choises out of one formula. Attached is the assembly and the formula below it. Form, place and finish ~ (__) s.f. of 4 broom swept finish concrete sidewalk. Concrete to be 3,500 psi and reinforced with 6 x 6 , w1.4/ w1.4 wwf. $4,410.00 Area 990 s.f. Perimeter 114 l.f. Concrete 990 0.33 1.03 336.501 12.463 13 145 1885 Labor 13 0.4 5.2 5.2 40 208 wwf 990 40 24.75 25 7 175 2 SB 990 0.26 257.4 260 0.49 127.4 Labor 990 0.003 2.97 3 40 120 Poly 990 1800 0.55 0.6 85 51 Labor 990 0.002 1.98 2 40 80 Expansion 990 0.25 247.5 100 2.475 2.5 31.64 79.1 Labor 250 0.01 2.5 2.5 40 100 Curing 640 350 1.828571429 5 0.365714286 0.4 55 22 Labor 990 0.003 2.97 3 40 120 2 x 4 114 16 7.125 8 5.81 46.48 Labor 114 0.33 37.62 0.2 7.524 7.6 40 304 Finish 990 100 9.9 2.75 27.225 27.3 40 1092 4409.98 =IF(B16500,3.5,2.75) -- -- - 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/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall...- Hide quoted text - - Show quoted text - -- -- 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/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ how to get month Occurrence in no.
Really Impressive! Let me know how this formula works On Tue, Dec 28, 2010 at 3:43 PM, Dave Bonallack davebonall...@hotmail.comwrote: Hi, A shorter version would be: =MONTH(--(1A1)) This works for 3-lettered abbreviatios (eg Mar, Oct) as well as extended abbreviations (eg Sept) and also unabbreviated (eg June, November) Regards - Dave. -- Date: Tue, 28 Dec 2010 15:34:01 +0700 Subject: Re: $$Excel-Macros$$ how to get month Occurrence in no. From: villager.g...@gmail.com To: excel-macros@googlegroups.com If the word April or *another month name *is type correctly in cell A1 try this formula in B1 =TEXT(DATEVALUE(1 A1 2010),M) On Tue, Dec 28, 2010 at 1:56 PM, Rohan Young rohan.j...@gmail.com wrote: Hi experts, is there any formula, if i only type in cell April and the other cell return the value 4, remember if i type simply April not 04/01/2010 etc. etc. please provide your feedback thanks regards ROHAN 9818247278, 8860567680 -- -- 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/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Amount Format
Good. On Tue, Dec 28, 2010 at 7:39 PM, Daniel dcolarde...@free.fr wrote: Please, see attached file. Regards. Daniel -Message d'origine- De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De la part de Rajiv Kumar Envoyé : lundi 20 décembre 2010 15:11 À : excel-macros@googlegroups.com Objet : $$Excel-Macros$$ Amount Format Dear sir how can I write excel sheet dis format 1,85,000 in excel. It yes then please give me tips. Awating your positive replay… Raj -- -- 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/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Nested IF functions?
Tried to but was blocked from doing so. That is why I pasted what i could. On Dec 28, 9:48 am, Dilip Pandey dilipan...@gmail.com wrote: Hi J D, It would be really appreciable if you can share a test file on this. Help us to help you :) Best Regards, DILIPandey On Tue, Dec 28, 2010 at 7:36 AM, J D springer...@gmail.com wrote: I am a concrete estimator who is trying to create some cut and paste Estimate line items I can just grab from one spread sheet and paste in to my estimate. I was refining one and tried to use the IF function to pick the number of labor hours based on sq footage. More s.f. and we are more productive therefore less hours per s.f. I was trying to say if less that 500 s.f. then .035 hrs/s.f. 500 to 1,000 then .0275 hrs/s.f. 1,000 s.f. then .0225 hours/s.f. I could get one working but wanted to know how to get more going choises out of one formula. Attached is the assembly and the formula below it. Form, place and finish ~ (__) s.f. of 4 broom swept finish concrete sidewalk. Concrete to be 3,500 psi and reinforced with 6 x 6 , w1.4/ w1.4 wwf. $4,410.00 Area 990 s.f. Perimeter 114 l.f. Concrete 990 0.33 1.03 336.501 12.463 13 145 1885 Labor 13 0.4 5.2 5.2 40 208 wwf 990 40 24.75 25 7 175 2 SB 990 0.26 257.4 260 0.49 127.4 Labor 990 0.003 2.97 3 40 120 Poly 990 1800 0.55 0.6 85 51 Labor 990 0.002 1.98 2 40 80 Expansion 990 0.25 247.5 100 2.475 2.5 31.64 79.1 Labor 250 0.01 2.5 2.5 40 100 Curing 640 350 1.828571429 5 0.365714286 0.4 55 22 Labor 990 0.003 2.97 3 40 120 2 x 4 114 16 7.125 8 5.81 46.48 Labor 114 0.33 37.62 0.2 7.524 7.6 40 304 Finish 990 100 9.9 2.75 27.225 27.3 40 1092 4409.98 =IF(B16500,3.5,2.75) -- ------ 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/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall;... -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India- Hide quoted text - - Show quoted text - -- -- 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/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
$$Excel-Macros$$ Make generic copy down/right and then back up 1 line
My code is like the below but I want it to be more generic so if I add lines, I don't have to reset the range: Range(N77).Select Range(Selection, Selection.End(xlToRight)).Select Range(N77:Y77).Select Range(Selection, Selection.End(xlDown)).Select Range(N77:Y81).Select Application.CutCopyMode = False Selection.Copy Sheets(Department Expense).Select Range(O81).Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Sheets(EB).Select -- -- 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/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
$$Excel-Macros$$ If the data is in different sheets how can get the highest lowest value.
Hi Thanks, if the data is in different sheets can get the min high values,Pls check the attached file. Regards Rajesh Kainikkara On 12/27/10, Ms-Exl-Learner . ms.exl.lear...@gmail.com wrote: Hi, In addition to the above post I would like to remove the helper column and we make the formula to do the work. Have a look in the attached file. --- Ms.Exl.Learner --- On Sun, Dec 26, 2010 at 6:29 PM, ashish koul koul.ash...@gmail.com wrote: check the attachment On Sun, Dec 26, 2010 at 3:15 PM, Rajesh K R rajeshkainikk...@gmail.comwrote: Hi experts Wish you happy new year I have worksheet like this Column A - Date Column B - Amt Column C - Name of Month Column D - For highest value of each month Column E - For lowest value of each month Pls check the attached file tell me what is the formula for finding the highest lowest value. Regards Rajesh Kainikkara -- -- 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/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- 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/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- -- 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/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts High Low.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ How to lock cell based on condition
Dear EE, Is it possible to lock the entire row/selected cell based on condition in particular Cell. for example, I want to lock the row based on value in column A. If macro found value yes in cell A1 A5, Macro will lock the row 1 row 5. I hope its possible in macro. Pls suggest me the code. Thnxs, Manish -- -- 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/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
$$Excel-Macros$$ How to attach the file on group???
There is no option available. :( pls suggest... Regds, Manish Pansari -- -- 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/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
RE: $$Excel-Macros$$ how to get month Occurrence in no.
Hi, XL is always looking for the opportunity to convert something to a date. In my region, where we use day, month, year, and with A1 containing the word 'July': =--(1A1) XL reads this as the 1st day of July, then adds the current year as a default. It returns 40360, which if the cell is formatted as date, shows 1 July 2010 Interestingly, =--(A11) also works. XL reads this as July 2001, and provides a default day of 1, returning the same date as above. In either event, now that XL has been provided an actual date, we can apply the MONTH thingy, which then returns 7 Regards - Dave. Date: Wed, 29 Dec 2010 12:12:16 +0500 Subject: Re: $$Excel-Macros$$ how to get month Occurrence in no. From: sajidmansooral...@gmail.com To: excel-macros@googlegroups.com Really Impressive! Let me know how this formula works On Tue, Dec 28, 2010 at 3:43 PM, Dave Bonallack davebonall...@hotmail.com wrote: Hi, A shorter version would be: =MONTH(--(1A1)) This works for 3-lettered abbreviatios (eg Mar, Oct) as well as extended abbreviations (eg Sept) and also unabbreviated (eg June, November) Regards - Dave. Date: Tue, 28 Dec 2010 15:34:01 +0700 Subject: Re: $$Excel-Macros$$ how to get month Occurrence in no. From: villager.g...@gmail.com To: excel-macros@googlegroups.com If the word April or another month name is type correctly in cell A1 try this formula in B1 =TEXT(DATEVALUE(1 A1 2010),M) On Tue, Dec 28, 2010 at 1:56 PM, Rohan Young rohan.j...@gmail.com wrote: Hi experts, is there any formula, if i only type in cell April and the other cell return the value 4, remember if i type simply April not 04/01/2010 etc. etc. please provide your feedback thanks regards ROHAN 9818247278, 8860567680 -- -- 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/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Formula required to find the highest lowest values in each month
Hi Thank You Regards Rajesh Kainikkara On 12/27/10, Ms-Exl-Learner . ms.exl.lear...@gmail.com wrote: Hi, In addition to the above post I would like to remove the helper column and we make the formula to do the work. Have a look in the attached file. --- Ms.Exl.Learner --- On Sun, Dec 26, 2010 at 6:29 PM, ashish koul koul.ash...@gmail.com wrote: check the attachment On Sun, Dec 26, 2010 at 3:15 PM, Rajesh K R rajeshkainikk...@gmail.comwrote: Hi experts Wish you happy new year I have worksheet like this Column A - Date Column B - Amt Column C - Name of Month Column D - For highest value of each month Column E - For lowest value of each month Pls check the attached file tell me what is the formula for finding the highest lowest value. Regards Rajesh Kainikkara -- -- 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/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- 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/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- -- 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/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Nested IF functions?
Yes it's very clear now. Try any one of the below formula which will do the trick. =IF(ISNUMBER(A3),IF(A31000,2.5,IF(A3=500,3,IF(A3500,3.5,))),) OR =IF(ISNUMBER(A3),IF(A3500,3.5,IF(AND(A3=500,A3=1000),3,IF(A31000,2.5,))),) At the same time herewith I have attached a sample file for your reference. --- Ms.Exl.Learner --- On Wed, Dec 29, 2010 at 11:13 AM, J D springer...@gmail.com wrote: Thanks. I have the Syntax correct now but how do I end it. I want to write a formula that would return the right answer for the below. if A3 500 value will be 3.5 if 500A31000 then value will be 3 if A31000 then value will be 2.5 I entered =IF(A3500,3.5,IF(500A31000,3,IF(A31000,2.5 and got False for an answer. I want to type into A3 a s.f. number and have the formula kick out one of the 3 or more possibilities so I can use the correct value in the next equation. Hope this is clearer. Thanks On Dec 28, 4:29 am, hanumant shinde arsfan2...@yahoo.co.in wrote: i dont understand what u mean exactly but i will jus tell u abt nested if in excel. let me know if you wanna know nesed if for Macro. it is if else function. so write if and give some value if is its true and in place of else write another if. if you wanna know the syntax refer help in excel. just type in IF and you will get everything there. e.g. =IF(A3=3,Equal,IF(A33,Less,IF(A33,Greater))) explaination if A3 = 3 value wil be Equal if A33 then value will be Less if A33 then value will be Greater - Original Message From: J D springer...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Tue, 28 December, 2010 7:36:57 AM Subject: $$Excel-Macros$$ Nested IF functions? I am a concrete estimator who is trying to create some cut and paste Estimate line items I can just grab from one spread sheet and paste in to my estimate. I was refining one and tried to use the IF function to pick the number of labor hours based on sq footage. More s.f. and we are more productive therefore less hours per s.f. I was trying to say if less that 500 s.f. then .035 hrs/s.f. 500 to 1,000 then .0275 hrs/s.f. 1,000 s.f. then .0225 hours/s.f. I could get one working but wanted to know how to get more going choises out of one formula. Attached is the assembly and the formula below it. Form, place and finish ~ (__) s.f. of 4 broom swept finish concrete sidewalk. Concrete to be 3,500 psi and reinforced with 6 x 6 , w1.4/ w1.4 wwf. $4,410.00 Area990 s.f.Perimeter114 l.f. Concrete9900.33 1.03336.50112.463 13145 1885 Labor 130.45.2 5.240 208 wwf99040 24.75 257175 2 SB 9900.26257.4 260 0.49127.4 Labor990 0.0032.97 340 120 Poly9901800 0.55 0.68551 Labor 9900.0021.98 240 80 Expansion9900.25 247.51002.475 2.531.64 79.1 Labor 2500.012.5 2.540 100 Curing640350 1.82857142950.365714286 0.455 22 Labor 9900.0032.97 340 120 2 x 411416 7.125 85.8146.48 Labor 1140.3337.62 0.27.5247.6 40304 Finish990 1009.92.75 27.22527.340 1092 4409.98 =IF(B16500,3.5,2.75) -- -- - 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/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall...-Hide quoted text - - Show quoted text - -- -- 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/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to
RE: $$Excel-Macros$$ How to hide/filter rows?
Hello, Consider pivot table. I may post a sample file. Just tell what your Excel version is. Regards. Daniel -Message d'origine- De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De la part de Walter Moser Envoyé : mardi 28 décembre 2010 17:04 À : MS EXCEL AND VBA MACROS Objet : $$Excel-Macros$$ How to hide/filter rows? Hello, so i have this 1+ rows excel sheet. Each row containins a name and a price - each in its own column. A name may appear various times. How can i filter the rows in order to display only one row for a given name. The one row i'd like to display is the one with the highest price. How can this be done in excel? Thanks, W. -- -- 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/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
$$Excel-Macros$$ Excel Expert - Opening in Pune
Hi Guys, Anyone looking for a job ? We need one Excel expert having knowledge on VB scripting in Pune. If interested .. drop me a mail. Thanks, Rajesh -- -- 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/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
$$Excel-Macros$$ how to draw a graph with two variables on y axis
Hi, i want to a graph which is a combination of two graphs. eg: x axis: date. y axis:rainfall : 800mm,900mm,750mm,925mm,825mm.etc. change with respect to sea lvl: 5mm,8mm,9mm,8.5mmetc. could anyone help me on this? Thanks Regards, Kenil Gala -- -- 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/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
$$Excel-Macros$$ Re: How to attach the file on group???
login group and then click on upload file then browse your file then click on I'm attached my file then ok. On Dec 29, 3:09 pm, Manish pansari.man...@gmail.com wrote: There is no option available. :( pls suggest... Regds, Manish Pansari -- -- 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/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Re: Lock the Object
Hello, Thank you very much Regards, Chandra Shekar On Sun, Dec 26, 2010 at 2:23 AM, hanumant shinde hanumant_5...@yahoo.co.inwrote: simply select E12:J22 cells lock them then protect sheet using password so nobody can unprotect it. see the attached file n let me know if it works for u. -- *From:* Chandra Shekar chandrashekarb@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Thu, 23 December, 2010 3:48:40 PM *Subject:* Re: $$Excel-Macros$$ Re: Lock the Object Hello, Thank you for ur reply. If we right click mouse on the object we can edit the object. Please check it out. On Wed, Dec 22, 2010 at 8:06 PM, JsinSk jsin...@gmail.com wrote: I believe you just need to set the locked object on your item (already done in your sheet), and then put protection on the sheet. (Tools| Protection|Protect Sheet) On Dec 22, 7:08 am, Chandra Shekar chandrashekarb@gmail.com wrote: Hello, How to lock the object? User should not edit the object or delete the object. Please find attached file. Thanks Chandra Shekar Object_Lock.xls 25KViewDownload -- -- 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/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
$$Excel-Macros$$ insert a sheet into right side short cut?
Normally(Shift+F11), when we insert a worksheet in Excel, it will appear left to the current sheet. Is it possible to insert a worksheet to the right side? -- -- 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/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Nested IF functions?
dude here you go. there wont be any ans if u type 500 in A3. for rest there will b proper ans. =IF(A3500,3.5,IF(AND(500A3,A31000),3,IF(A31000,2.5))) let me know if you require anythig else happy new year in advance. - Original Message From: J D springer...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Wed, 29 December, 2010 11:13:24 AM Subject: Re: $$Excel-Macros$$ Nested IF functions? Thanks. I have the Syntax correct now but how do I end it. I want to write a formula that would return the right answer for the below. if A3 500 value will be 3.5 if 500A31000 then value will be 3 if A31000 then value will be 2.5 I entered =IF(A3500,3.5,IF(500A31000,3,IF(A31000,2.5 and got False for an answer. I want to type into A3 a s.f. number and have the formula kick out one of the 3 or more possibilities so I can use the correct value in the next equation. Hope this is clearer. Thanks On Dec 28, 4:29 am, hanumant shinde arsfan2...@yahoo.co.in wrote: i dont understand what u mean exactly but i will jus tell u abt nested if in excel. let me know if you wanna know nesed if for Macro. it is if else function. so write if and give some value if is its true and in place of else write another if. if you wanna know the syntax refer help in excel. just type in IF and you will get everything there. e.g. =IF(A3=3,Equal,IF(A33,Less,IF(A33,Greater))) explaination if A3 = 3 value wil be Equal if A33 then value will be Less if A33 then value will be Greater - Original Message From: J D springer...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Tue, 28 December, 2010 7:36:57 AM Subject: $$Excel-Macros$$ Nested IF functions? I am a concrete estimator who is trying to create some cut and paste Estimate line items I can just grab from one spread sheet and paste in to my estimate. I was refining one and tried to use the IF function to pick the number of labor hours based on sq footage. More s.f. and we are more productive therefore less hours per s.f. I was trying to say if less that 500 s.f. then .035 hrs/s.f. 500 to 1,000 then .0275 hrs/s.f. 1,000 s.f. then .0225 hours/s.f. I could get one working but wanted to know how to get more going choises out of one formula. Attached is the assembly and the formula below it. Form, place and finish ~ (__) s.f. of 4 broom swept finish concrete sidewalk. Concrete to be 3,500 psi and reinforced with 6 x 6 , w1.4/ w1.4 wwf. $4,410.00 Area990 s.f.Perimeter114 l.f. Concrete990 0.33 1.03336.50112.463 13145 1885 Labor 130.45.2 5.240 208 wwf99040 24.75 257175 2 SB 9900.26257.4 260 0.49127.4 Labor990 0.0032.97 340 120 Poly9901800 0.55 0.6 8551 Labor 9900.0021.98 240 80 Expansion9900.25 247.51002.475 2.5 31.64 79.1 Labor 2500.012.5 2.540 100 Curing640350 1.82857142950.365714286 0.455 22 Labor 9900.0032.97 340 120 2 x 411416 7.125 85.81 46.48 Labor 1140.3337.62 0.27.5247.6 40304 Finish990 1009.92.75 27.22527.3 40 1092 4409.98 =IF(B16500,3.5,2.75) -- -- - 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/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall...- Hide quoted text - - Show quoted text - -- -- - 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/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at
$$Excel-Macros$$ need macro for dyanmic sms through excel via bluetoooth
dear friends, i saw some web based sms companies have excel plugin it will sent dynamic sms via web (*dynamic sms* :-excel sheet 1 column is mobile no 2 column is message it will send each number each different message) like that any macro is there for sent same dynamic sms via bluetooth and sim need our team people help in this matter thanking you regards mohanraj shunmugam -- -- 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/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Nested IF functions?
Thanks, got it to work finally. On Dec 29, 3:51 am, Dave Bonallack davebonall...@hotmail.com wrote: Hi, To just do the 3 levels you asked about, try: =IF(B16500,3.5,IF(B161000,2.75,2.25)) Regards - Dave. Date: Tue, 28 Dec 2010 20:18:30 +0530 Subject: Re: $$Excel-Macros$$ Nested IF functions? From: dilipan...@gmail.com To: excel-macros@googlegroups.com Hi J D, á It would be really appreciable if you can share a test file on this.á Help us to help you :) á Best Regards, DILIPandey On Tue, Dec 28, 2010 at 7:36 AM, J D springer...@gmail.com wrote: I am a concrete estimator who is trying to create some cut and paste Estimate line items I can just grab from one spread sheet and paste in to my estimate. I was refining one and tried to use the IF function to pick the number of labor hours based on sq footage. áMore s.f. and we are more productive therefore less hours per s.f. I was trying to say if less that 500 s.f. then .035 hrs/s.f. á500 to 1,000 then .0275 hrs/s.f. 1,000 s.f. then .0225 hours/s.f. I could get one working but wanted to know how to get more going choises out of one formula. áAttached is the assembly and the formula below it. Form, place and finish ~ (__) s.f. of 4 broom swept finish concrete sidewalk. áConcrete to be 3,500 psi and reinforced with 6 x 6 , w1.4/ w1.4 wwf. á á á á á á á á á á á á á á á á á á á á á á á á á á á á á á á á á á á $4,410.00 á á á áArea á á990 á á s.f. á áPerimeter á á á 114 á á l.f. Concrete á á á á990 á á 0.33 á á1.03 á á336.501 12.463 á13 á á á145 á á 1885 Labor á 13 á á á0.4 á á 5.2 á á á á á á á á á á 5.2 á á 40 á á á208 wwf á á 990 á á 40 á á á24.75 á á á á á á á á á 25 á á á7 á á á 175 2 SB á 990 á á 0.26 á á257.4 á á á á á á á á á 260 á á 0.49 á á127.4 Labor á 990 á á 0.003 á 2.97 á á á á á á á á á á3 á á á 40 á á á120 Poly á á990 á á 1800 á á0.55 á á á á á á á á á á0.6 á á 85 á á á51 Labor á 990 á á 0.002 á 1.98 á á á á á á á á á á2 á á á 40 á á á80 Expansion á á á 990 á á 0.25 á á247.5 á 100 á á 2.475 á 2.5 á á 31.64 á 79.1 Labor á 250 á á 0.01 á á2.5 á á á á á á á á á á 2.5 á á 40 á á á100 Curing á640 á á 350 á á 1.828571429 á á 5 á á á 0.365714286 á á 0.4 á á 55 á á á22 Labor á 990 á á 0.003 á 2.97 á á á á á á á á á á3 á á á 40 á á á120 2 x 4 á 114 á á 16 á á á7.125 á á á á á á á á á 8 á á á 5.81 á á46.48 Labor á 114 á á 0.33 á á37.62 á 0.2 á á 7.524 á 7.6 á á 40 á á á304 Finish á990 á á 100 á á 9.9 á á 2.75 á á27.225 á27.3 á á40 á á á1092 á á á á á á á á á á á á á á á á á á á á á á á á á á á á á á á á4409.98 =IF(B16500,3.5,2.75) -- ------ 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/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below linkhttp://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall;... -- Thanks Regards, DILIP KUMAR PANDEYá á MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India -- ------ 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/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below linkhttp://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall;... -- -- 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/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
$$Excel-Macros$$ Help for starter
Hi, I am very new to VBA. I know C++.I have few questions related to Excel programming. 1) I have two xls files Rate.xls and Bill.xls. Rate.xls file contains two columns which has heading ItemNo and ItemRate.Now I want that in bill.xls when I enter ItemNo and quantity then final price should be calculated. For this I need that when I enter ItemNo it takes its rate from Rate.xls (I mean program should search itemNo and take row number so same number can be used to find rate from second column by giving proper cell ref) and multiply with quantity and put final price in next column.So how to do this?I dont need to make rate.xls visible to user(if possible). 2)Where shound I find complete documentation of All APIs.I didnt find good book which covers some functionalities like finding particular value in xls file and return row or column or cell ref for that, find first empty row and column. 3)How to use C# for excel programming. What should be installed for this. I have visual studio 2008 and Office 2003. Apart from that what I need to install.I heard about Office Tools,but I dont know how to install. If these questions are already answered then pls send me link to that post so I can read and understand it. I hope some expert will reply asap. One can also send reply to premalpanc...@gmail.com Thak you very much in advance. -- -- 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/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
$$Excel-Macros$$ Learning Macros
Hi Experts, Kindly suggest me regarding of learning macros with VBA codding Thanx for your support in advance -- -- 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/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
$$Excel-Macros$$ Re: How to lock cell based on condition
Any help/suggestion ??? Thanks, Manish On Dec 29, 3:03 pm, Manish Pansari pansari.man...@gmail.com wrote: Dear EE, Is it possible to lock the entire row/selected cell based on condition in particular Cell. for example, I want to lock the row based on value in column A. If macro found value yes in cell A1 A5, Macro will lock the row 1 row 5. I hope its possible in macro. Pls suggest me the code. Thnxs, Manish -- -- 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/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ insert a sheet into right side short cut?
Sub InsertWorksheetAfter() ActiveWorkbook.Worksheets.Add After:=ActiveSheet End Sub On Wed, Dec 29, 2010 at 8:31 PM, renuka chari jva.ch...@gmail.com wrote: Normally(Shift+F11), when we insert a worksheet in Excel, it will appear left to the current sheet. Is it possible to insert a worksheet to the right side? -- -- 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/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- 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/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Re: How to lock cell based on condition
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 1 Then 'target.column =3 because column c is no 3 column 'you can change password ashish and choose your own ActiveSheet.Unprotect Password:=ashish If Not IsEmpty(Target.Value) And Target.Value = Yes Then Rows(Target.Row : Target.Row).Select Selection.Locked = True End If ActiveSheet.Protect Password:=ashish Else: End If End Sub check this http://akoul.blogspot.com/2010/06/lock-cell-after-data-entry-from-editing.html On Thu, Dec 30, 2010 at 10:38 AM, Manish pansari.man...@gmail.com wrote: Any help/suggestion ??? Thanks, Manish On Dec 29, 3:03 pm, Manish Pansari pansari.man...@gmail.com wrote: Dear EE, Is it possible to lock the entire row/selected cell based on condition in particular Cell. for example, I want to lock the row based on value in column A. If macro found value yes in cell A1 A5, Macro will lock the row 1 row 5. I hope its possible in macro. Pls suggest me the code. Thnxs, Manish -- -- 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/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- 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/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts testlock.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Help for starter
Hi Premal, Today, i uploaded one new file on our group Excel_tutor.xls Try this, it will help you... Regds, Manish On Dec 30, 9:32 am, Premal premalpanc...@gmail.com wrote: Hi, I am very new to VBA. I know C++.I have few questions related to Excel programming. 1) I have two xls files Rate.xls and Bill.xls. Rate.xls file contains two columns which has heading ItemNo and ItemRate.Now I want that in bill.xls when I enter ItemNo and quantity then final price should be calculated. For this I need that when I enter ItemNo it takes its rate from Rate.xls (I mean program should search itemNo and take row number so same number can be used to find rate from second column by giving proper cell ref) and multiply with quantity and put final price in next column.So how to do this?I dont need to make rate.xls visible to user(if possible). 2)Where shound I find complete documentation of All APIs.I didnt find good book which covers some functionalities like finding particular value in xls file and return row or column or cell ref for that, find first empty row and column. 3)How to use C# for excel programming. What should be installed for this. I have visual studio 2008 and Office 2003. Apart from that what I need to install.I heard about Office Tools,but I dont know how to install. If these questions are already answered then pls send me link to that post so I can read and understand it. I hope some expert will reply asap. One can also send reply to premalpanc...@gmail.com Thak you very much in advance. -- -- 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/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Re: How to lock cell based on condition
Thanks Ashish, This is perfect as i want. I need some more help, If i want to lock only column B to G (not want to lock entire row) than what will the code. I want to understand the diff in codes. :) Thanks once again for your help. Regds, Manish On Dec 30, 10:31 am, ashish koul koul.ash...@gmail.com wrote: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 1 Then 'target.column =3 because column c is no 3 column 'you can change password ashish and choose your own ActiveSheet.Unprotect Password:=ashish If Not IsEmpty(Target.Value) And Target.Value = Yes Then Rows(Target.Row : Target.Row).Select Selection.Locked = True End If ActiveSheet.Protect Password:=ashish Else: End If End Sub check this http://akoul.blogspot.com/2010/06/lock-cell-after-data-entry-from-edi... On Thu, Dec 30, 2010 at 10:38 AM, Manish pansari.man...@gmail.com wrote: Any help/suggestion ??? Thanks, Manish On Dec 29, 3:03 pm, Manish Pansari pansari.man...@gmail.com wrote: Dear EE, Is it possible to lock the entire row/selected cell based on condition in particular Cell. for example, I want to lock the row based on value in column A. If macro found value yes in cell A1 A5, Macro will lock the row 1 row 5. I hope its possible in macro. Pls suggest me the code. Thnxs, Manish -- ------ 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/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall;... -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. testlock.xls 45KViewDownload- Hide quoted text - - Show quoted text - -- -- 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/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
