Re: $$Excel-Macros$$ Doubt MBA

Hey I have a template through which you can send email via Outlook, refer att. Do let us know if you need any help. Cheers!! On Fri, Aug 22, 2014 at 6:34 AM, Marcio Bandeira wrote: > i forgot something very importante. I need a extra collum to say if I send > the file to this cliente or not.

Re: Fwd: $$Excel-Macros$$ Doubt MBA

means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > >*From:* Marcio Bandeira > *To:* excel-macros@googlegroups.com > *S

Re: Fwd: $$Excel-Macros$$ Doubt MBA

> From: Marcio Bandeira >To: excel-macros@googlegroups.com >Sent: Thursday, August 21, 2014 9:04 PM >Subject: Fwd: $$Excel-Macros$$ Doubt MBA > > > >i forgot something very importante. I need a extra collum to say if I send the >file to this cliente or not. New example. Tks!!!

Fwd: $$Excel-Macros$$ Doubt MBA

i forgot something very importante. I need a extra collum to say if I send the file to this cliente or not. New example. Tks!!! Hi. I need a help. I have a worksheet and I need to build a macro that send a file, with the name is in collum B to the e-mails at collum c. THere is a Excel attached to

$$Excel-Macros$$ Doubt MBA

Hi. I need a help. I have a worksheet and I need to build a macro that send a file, with the name is in collum B to the e-mails at collum c. THere is a Excel attached to explain. I apreciate any help. Thank you very much Marcio. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do yo

Re: $$Excel-Macros$$ doubt in extracting worksheet balances to sheet1 with other sheet names

hai Vaibhavji thank you so much regards shankar sb On Thu, Aug 7, 2014 at 12:03 PM, Vaibhav Joshi wrote: > Hi > > PFA > > Cheers!! > > > On Thu, Aug 7, 2014 at 11:21 AM, Shankar Bheema > wrote: > >> Hai friends >> >> I am attaching an Excel workbook for an apartment maintenance. >> >> sheet1

Re: $$Excel-Macros$$ doubt in extracting worksheet balances to sheet1 with other sheet names

Hi PFA Cheers!! On Thu, Aug 7, 2014 at 11:21 AM, Shankar Bheema wrote: > Hai friends > > I am attaching an Excel workbook for an apartment maintenance. > > sheet1 i considered as Main page, > > sheet2, sheet3 will hold individual accounts and their balances > > when the extract ba

$$Excel-Macros$$ doubt in extracting worksheet balances to sheet1 with other sheet names

Hai friends I am attaching an Excel workbook for an apartment maintenance. sheet1 i considered as Main page, sheet2, sheet3 will hold individual accounts and their balances when the extract balances button pressed on the sheet1 page, the names of the remaining worksheets should come

Re: $$Excel-Macros$$ Doubt in Duplicates

Dear Ganesh, Thank you... Now i understood... On Wed, Apr 30, 2014 at 11:33 AM, Ganesh N wrote: > HI Kannan, > > There is In-build option in excel to show the duplicates. Please find the > below steps. > > Home->conditional formatting->highlight cells rules->Duplicate value (you > can create

Re: $$Excel-Macros$$ Doubt in Duplicates

I think Ganesh reply is correct if you just want to show the duplicates. On Wednesday, 30 April 2014 11:33:55 UTC+5:30, Ganesh N wrote: > > HI Kannan, > > There is In-build option in excel to show the duplicates. Please find the > below steps. > > Home->conditional formatting->highlight cells rul

Re: $$Excel-Macros$$ Doubt in Duplicates

HI Kannan, There is In-build option in excel to show the duplicates. Please find the below steps. Home->conditional formatting->highlight cells rules->Duplicate value (you can create whatever format u want to show the duplicate values) Thanks & Regards, Ganesh N On Wed, Apr 30, 2014 at 11:27 A

$$Excel-Macros$$ Doubt in Duplicates

Dear Friends, Please find the attached file of excel, I have a doubt in that excel. I checked the excel there is no formula and VBA coding but it is showing duplicates. How to do this in other excel... Please help me -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

Re: $$Excel-Macros$$ doubt with regard to change event of the combo

Dear Abhishek thank u for replying. if for example i selected gp 1900 then the value of paycode is 06 and payband code as B1 On Mon, Jul 22, 2013 at 12:58 PM, Abhishek Jain wrote: > What is your criteria? > > Suppose I select one value in gp combo, what values should be selected in > the other

Re: $$Excel-Macros$$ doubt with regard to change event of the combo

Hi,   Simply put your code in change event of GB combobox. From: Abhishek Jain To: excel-macros@googlegroups.com Sent: Monday, July 22, 2013 12:58 PM Subject: Re: $$Excel-Macros$$ doubt with regard to change event of the combo What is your criteria

Re: $$Excel-Macros$$ doubt with regard to change event of the combo

Respected Bheema Shakar, Please check the links which will help with your problem. http://www.contextures.com/exceluserformdependentcomboboxes.html http://www.youtube.com/watch?v=eJslb49T0Bk Regards, VIjaykuar On Mon, Jul 22, 2013 at 12:20 PM, Shankar Bheema wrote: > Hai everyone > > I attache

Re: $$Excel-Macros$$ doubt with regard to change event of the combo

What is your criteria? Suppose I select one value in gp combo, what values should be selected in the other two? On Mon, Jul 22, 2013 at 12:20 PM, Shankar Bheema wrote: > Hai everyone > > I attached an excel sheet which contains a form. In that I placed three > nos. of combo boxes. Each have it

$$Excel-Macros$$ doubt with regard to change event of the combo

Hai everyone I attached an excel sheet which contains a form. In that I placed three nos. of combo boxes. Each have its values. when I change the gp combo value the remaining two combo values should automatically change. I tried in many ways but failed. please help me out. regards shankar sb

$$Excel-Macros$$ Doubt

Hi team, Need example for how to insert specific column values from excel to sql table. using vb.net Thanks, Sharma -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread ti

Re: $$Excel-Macros$$ doubt

n Guillett >> Microsoft MVP Excel >> SalesAid Software >> dguille...@gmail.com >> >> *From:* vijayajith VA >> *Sent:* Saturday, May 26, 2012 5:44 AM >> *To:* excel-macros@googlegroups.com >> *Subject:* $$Excel-Macros$$ doubt >> >> Hi all, >>

Re: $$Excel-Macros$$ doubt

as in the > attached file. > > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguille...@gmail.com > > *From:* vijayajith VA > *Sent:* Saturday, May 26, 2012 5:44 AM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ doubt > > Hi al

Re: $$Excel-Macros$$ doubt

: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ doubt Hi all, Please find the attached query..Thanks -- 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

Re: $$Excel-Macros$$ doubt

; *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *vijayajith VA > *Sent:* 26 May 2012 4:15 > *To:* excel-macros@googlegroups.com > *Subjec

RE: $$Excel-Macros$$ doubt

6 May 2012 4:15 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ doubt Hi all, Please find the attached query..Thanks -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula

Re: $$Excel-Macros$$ doubt

Try the below condition and see the attached sheet. =SUMPRODUCT(($K$2:$K$48=E5)*($L$2:$L$48=$F$4)*($P$2:$P$48)) Ashish On Sat, May 26, 2012 at 4:14 PM, vijayajith VA wrote: > Hi all, > > Please find the attached query..Thanks > > -- > FORUM RULES (986+ members already BANNED for violation) > >

$$Excel-Macros$$ doubt

Hi all, Please find the attached query..Thanks -- 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

Re: $$Excel-Macros$$ doubt with setfocus

thank you for solution On Tue, Feb 21, 2012 at 3:24 PM, Prajakt Pande wrote: > Dear shankar, > > I tried to solve your problem > > PFA > > On Tue, Feb 21, 2012 at 12:47 PM, Shankar Bheema > wrote: > >> Dear Experts >> >> I am enclosing the attachment which was solved by NOORAIN. but when I >> a

RE: $$Excel-Macros$$ doubt with setfocus

e mouse on another control or hit the tab or enter keys). Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Shankar Bheema Sent: Tuesday, February 21, 2012 12:48 AM To: excel-macros@googlegroups.com; NOORAIN ANSARI Subject: $$Excel-Macros$$ doubt with setfocus

$$Excel-Macros$$ doubt with setfocus

Dear Experts I am enclosing the attachment which was solved by NOORAIN. but when I add third textbox to the userform, the code is not working. Please guide me. regards shankar sb -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread tit

Re: $$Excel-Macros$$ doubt with prefix

Dear Shankar, > > Please check once again > > > -- > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogspot.com/* > *http://noorain-ansari.blogspot.com/* > > On Fri, Jan 27, 2012 at 4:20 PM, Shankar Bheema wr

Re: $$Excel-Macros$$ doubt with prefix

thank you noorain bhai On Fri, Jan 27, 2012 at 2:59 PM, NOORAIN ANSARI wrote: > Dear Shankar, > > Please see attached sheet and use code format for your coding. > > > On Fri, Jan 27, 2012 at 2:23 PM, Shankar Bheema wrote: > >> Dear experts >> >> I attached an userform, in which, frame2 contains t

Re: $$Excel-Macros$$ doubt with prefix

Dear Shankar, Please see attached sheet and use code format for your coding. On Fri, Jan 27, 2012 at 2:23 PM, Shankar Bheema wrote: > Dear experts > > I attached an userform, in which, frame2 contains total service. Which > obtains by deducting date of joining from date of retirement. > > where

Re: $$Excel-Macros$$ doubt with rounding off and change event in excel vba

gt; excel-macros@googlegroups.com] *On Behalf Of *Shankar Bheema > *Sent:* Jan/Thu/2012 12:31 > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ doubt with rounding off and change event in > excel vba > > ** ** > > Dear Experts > > I am attaching a

RE: $$Excel-Macros$$ doubt with rounding off and change event in excel vba

Use Mround Function See the attached file Regards Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Shankar Bheema Sent: Jan/Thu/2012 12:31 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ doubt with rounding off and change event

$$Excel-Macros$$ doubt with rounding off and change event in excel vba

Dear Experts I am attaching an excel vba file. In which I am facing a problem with change event. the addition of textbox2.text + textbox3.text values with the value of 3% of the value of the above both. That 3% value if exceeds 1 rupee it should be rounded off to the next nearest 10 rs. eg: i

Re: $$Excel-Macros$$ doubt with rounding off and totalling of the amounts

thank you very much ansari bhai. wil try and get back to you. On Fri, Dec 16, 2011 at 9:53 PM, NOORAIN ANSARI wrote: > Dear Shankar, > > Please see attachement.hope it will help to u > -- > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogspot.com/*

Re: $$Excel-Macros$$ doubt with msaccess 2003

thank you so much for your response. I will try and get back to you with the result. If possible pls clarify my rest of doubts put in our community. On Tue, Dec 13, 2011 at 4:06 PM, Maries wrote: > > Hi, > > use the below code. It will work. > > Private Sub cmdnetser_Click() > Dim year1 As

Re: $$Excel-Macros$$ doubt with msaccess 2003

Hi, use the below code. It will work. Private Sub cmdnetser_Click() Dim year1 As Double Dim year2 As Double Dim yearresult As Double Dim month1 As Double Dim month2 As Double Dim monthresult As Double Dim day1 As Double Dim day2 As Double Dim dayresult As Dou

Re: $$Excel-Macros$$ doubt

You could always use the data in Excel as a linked table in Access, and create reports as from a normal access database table. Sam On Fri, Oct 28, 2011 at 1:16 PM, Shankar Bheema wrote: > Hai All, > > I created a calculation form in EXCEL 2003 VBA. I placed save, update and > etc commands on th

$$Excel-Macros$$ doubt

Hai All, I created a calculation form in EXCEL 2003 VBA. I placed save, update and etc commands on the VBA form. The data which I enter will save in excel format. Is it possible to prepare reports using MSACCESS 2003 for generating reports using the stored data in excel ? -- FORUM RULES (925+

Re: $$Excel-Macros$$ Doubt

Dear Bheema, Please try through below Link.. http://www.control.com/thread/1026218679 -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Thu, Oct 20, 2011

Re: $$Excel-Macros$$ Doubt

I am using 2003 office. On Thu, Oct 20, 2011 at 7:05 PM, NOORAIN ANSARI wrote: > Dear Bheema, > > It is possible,,, > In MS Access 2007 > > Goto : *Database Tools*-*Visual Basic*-In Right part Collaspe all > fields-Right Click and Project Properties-Protection and Set password with > Che

Re: $$Excel-Macros$$ Doubt

You cannot make the file/database an executable. However, like Noorain mentioned, you can password protect your VBA modules. None of the VBA environments in office (at least till 2011) has the feature to create an executable file like VB. Regards, Sam Mathai Chacko (GL) On Thu, Oct 20, 2011 at

Re: $$Excel-Macros$$ Doubt

Dear Bheema, It is possible,,, In MS Access 2007 Goto : *Database Tools*-*Visual Basic*-In Right part Collaspe all fields-Right Click and Project Properties-Protection and Set password with Checked Lock Project for viewing. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.b

$$Excel-Macros$$ Doubt

Hai all. My query relates to MS ACCESS. Friends, how to make the MSACCESS designed form application an executable one. means how to hide code part. Because I made a form and want to give other users in my office. If anything went wrong my effort will goes to waste. So, I want to hide the code p

$$Excel-Macros$$ doubt in report generation

I am trying to design report with crystal report 9. It is not having to design in FORM VIEW. All designs are in columner form. Pls do help me. -- -- Some important links for excel users: 1. Follow us on TWITTER for

$$Excel-Macros$$ Doubt

1)Can anybody suggest me how tomopen multiple worksheets in Excel by using single command 2) Could you please provide Interview questions on Advanced Ms-excel and VBA Thank you Sumanth. --~--~-~--~~~---~--~~ ---

$$Excel-Macros$$ Doubt on using vlookup function from another sheet

Hi Dear members, I have a doubt on Using vlookup, fill in the values in Sheet "2" by referring to the values in Sheet "1". I have attached a file for reference. Thanks&Regards Ramesh --~--~-~--~~~---~--~~ -

$$Excel-Macros$$ Doubt on data range

Dear Members, My question seems to be very simple, please don't laugh at me. I have 2 columns that are A1 contains Names and B1 contains Sex of employee. When finding no. of males and females using countif() function. When I copied the function I am getting range difference. For ex: =countif(a

$$Excel-Macros$$ doubt

Hi.. I am back again with another doubt.. what is the difference between A$2 $A2 $A$2 .. what is the significance of this dollar sign..pls reply.. --~--~-~--~~~---~--~~ - Some impor