Re: $$Excel-Macros$$ hi

hi On Sun, Jun 26, 2016 at 10:37 AM, Grkrishna Naidu wrote: > add me in group > > -- > 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 > > FORUM RULES > > 1) Use

Re: $$Excel-Macros$$ hi all

Hi Sunil, PFA.!! Regards Ashish -- 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 FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, l

Re: $$Excel-Macros$$ hi all

HI Where you will enter value i? Sheet Name & Cell No. Which area of Sheet you want to compare? Sheet Name? Range Name>? What msg you want? + *I did not do this for you. God is here working through me for you.* On Thu, Sep 18, 2014 at 2:21 PM, sunil lobo wrote: > hi i have a value in s

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

Is there any opening in MIS executive profile?. Actually i also looking the job in same field. Regards, Kapil Gupta On Tuesday, August 2, 2011 7:13:55 AM UTC+5:30, krishna mummina wrote: > > Sam > > Are you asking me or to whom you are referring to call you? Here is my > number : 09866902757

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

My Mail Id : surya.i...@gmail.com On Thursday, May 8, 2014 1:49:39 AM UTC+5:30, Surya Narayanan PV wrote: > > Hi sir I am currently working as Junior Software engineer/MIS for the past > 2.5 years. My role includes coding in Vb 6.0, SQL server 2005. I do also > generate reports as per the requir

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

Hi sir I am currently working as Junior Software engineer/MIS for the past 2.5 years. My role includes coding in Vb 6.0, SQL server 2005. I do also generate reports as per the requirement, so do have an average knowledge in Excel. But I have to set my future career in MIS dept. so I would like

Re: $$Excel-Macros$$ hi

HELLO SATENDER, WELCOME TO THIS GROUP AND SHARE YOUR QUERY On Fri, Feb 14, 2014 at 9:03 AM, Satender Rawat wrote: > > -- > 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/disc

Re: $$Excel-Macros$$ hi all***need code to attacha file in outlook and send it to respective email id***

Hi ashish, Thanks your very much, it solved my query. On Sat, Mar 30, 2013 at 10:03 AM, ashish koul wrote: > try the attachment .. see if it helps > > > > On Fri, Mar 29, 2013 at 10:37 PM, maksood alam <786maks...@gmail.com>wrote: > >> Hi all >> >> please send me the code to attach a file i

Re: $$Excel-Macros$$ hi all***need code to attacha file in outlook and send it to respective email id***

try the attachment .. see if it helps On Fri, Mar 29, 2013 at 10:37 PM, maksood alam <786maks...@gmail.com> wrote: > Hi all > > please send me the code to attach a file in outlook and send it to > respective email address. > > > Thanks > Maksood alam > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT

Re: $$Excel-Macros$$ hi there

sir, pl accept my apology i m begineer in the group, and not familier with excel progarmming too. i need customer recoed database. Thanks NIK. On Thu, Mar 7, 2013 at 11:10 PM, xlstime wrote: > Hi Nik > > first of all please use proper subject line and which type database format > you want i

Re: $$Excel-Macros$$ hi there

Hi Nik first of all please use proper subject line and which type database format you want i..e... Finance or customer record database type please specify . Enjoy Team XLS On Thu, Mar 7, 2013 at 10:26 PM, nm wrote: > Sir, > > i m into real estate business and want

Re: $$Excel-Macros$$ hi friends i want courier management data format in excel

Hi Gawli Anil, Please check all mails. It's Kannan (kannan.ex...@gmail.com) Query. I have no query. I am happy to help. Regards, Kuldeep Singh Info Edge India Limited (naukri.com) Phone.: +91-0120-4841100, Extn.: 2467, 9716615535 naukrikuld...@gmail.com || www.naukri.com *Please* *Consider the en

Re: $$Excel-Macros$$ hi friends i want courier management data format in excel

Dear Kuldeep, Pl provide proper query. What do you want?? Warm Regards, Gawli Anil On Wed, Mar 6, 2013 at 2:54 PM, Kuldeep Singh wrote: > > Hi Kannan, > > PFA.. > > Regards, > Kuldeep Singh > Info Edge India Limited (naukri.com) > Phone.: +91-0120-4841100, Extn.: 2467, 9716615535 >

Re: $$Excel-Macros$$ hi friends i want courier management data format in excel

Hi Kannan, PFA.. Regards, Kuldeep Singh Info Edge India Limited (naukri.com) Phone.: +91-0120-4841100, Extn.: 2467, 9716615535 naukrikuld...@gmail.com || www.naukri.com *Please* *Consider the environment. Please don't print this e-mail unless you really need to.* On Wed, Mar 6, 2013 at 2

Re: $$Excel-Macros$$ hi friends i want courier management data format in excel

pls share the data On Wed, Mar 6, 2013 at 2:45 PM, xlstime wrote: > please share required field > > > . > > Enjoy > Team XLS > > > > On Wed, Mar 6, 2013 at 2:09 PM, kannan excel wrote: > >> hi friends i want courier management data format in excel >> >> >> regards >> kann

Re: $$Excel-Macros$$ hi friends i want courier management data format in excel

please share required field . Enjoy Team XLS On Wed, Mar 6, 2013 at 2:09 PM, kannan excel wrote: > hi friends i want courier management data format in excel > > > regards > kannan > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =T

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

Hi Sir, Myself sundar from chennai, First i would appreciate on your brief explanation for MIS role, it is very clear to understand. i have been working as HR for past 3 Years, but my role as HR is not satisfying me. I was looking for a change where i don't interact with people much, and so i

Re: $$Excel-Macros$$ Hi

Dear Rajat, You have been added successfully in excel-macros group, Please check and confirm. -- With Regards, Noorain Ansari http:// noorainansari.com http:// excelvbaclinic.com

Re: $$Excel-Macros$$ Hi

Mihael, Please post ur excel macro query On Thu, Jun 14, 2012 at 8:39 AM, Michael Brumby wrote: > > this is crazy you should check the out > http://www.business15canews.net/work/?read=5074813 > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titl

RE: $$Excel-Macros$$ Hi all Experts Cna u share a Macro for outlook emails sending Specific Templet With Attachments formats of .PDF & .htm

Yes, you can give comma separated email list. Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Deba Ranjan Sent: 31 May 2012 10:14 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Hi

Re: $$Excel-Macros$$ Hi all Experts Cna u share a Macro for outlook emails sending Specific Templet With Attachments formats of .PDF & .htm

xcel-macros@googlegroups.com] *On Behalf Of *Deba Ranjan > *Sent:* 30 May 2012 9:56 > > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Hi all Experts Cna u share a Macro for > outlook emails sending Specific Templet With Attachments formats of .PDF & > .htm*

Re: $$Excel-Macros$$ Hi all Experts Cna u share a Macro for outlook emails sending Specific Templet With Attachments formats of .PDF & .htm

googlegroups.com] *On Behalf Of *Deba Ranjan > *Sent:* 29 May 2012 10:11 > > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Hi all Experts Cna u share a Macro for > outlook emails sending Specific Templet With Attachments formats of .PDF & > .htm >

RE: $$Excel-Macros$$ Hi all Experts Cna u share a Macro for outlook emails sending Specific Templet With Attachments formats of .PDF & .htm

-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Hi all Experts Cna u share a Macro for outlook emails sending Specific Templet With Attachments formats of .PDF & .htm Dear Rajan, The file that you have shared is quite awesome. Can you please share us the coding too as you have protect

Re: $$Excel-Macros$$ Hi all Experts Cna u share a Macro for outlook emails sending Specific Templet With Attachments formats of .PDF & .htm

7838100659 [IM-Gtalk]* > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *t vinay > *Sent:* 28 May 2012 7:47 > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Hi all Experts Cna u share a M

RE: $$Excel-Macros$$ Hi all Experts Cna u share a Macro for outlook emails sending Specific Templet With Attachments formats of .PDF & .htm

@googlegroups.com Subject: Re: $$Excel-Macros$$ Hi all Experts Cna u share a Macro for outlook emails sending Specific Templet With Attachments formats of .PDF & .htm Hi Rajan, this is excellent, can you help with the code that you have used. as my requirement is on the same line. On 17

Re: $$Excel-Macros$$ Hi all Experts Cna u share a Macro for outlook emails sending Specific Templet With Attachments formats of .PDF & .htm

Hi Rajan, this is excellent, can you help with the code that you have used. as my requirement is on the same line. On 17 May 2012 18:44, Rajan_Verma wrote: > Try My Excel Outlook J > > ** ** > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > ** ** > > *From:* excel-

Re: $$Excel-Macros$$ Hi Expert- please spend your few minute only on this question.

yeah, that is true. Google is our universal friend. but it will be awesome if group members got list of real time problem, or difference expert faces during use of different versions of excel. Divaker On Mon, Mar 5, 2012 at 8:43 PM, dguillett1 wrote: > Google is your friend. > > excel ve

Re: $$Excel-Macros$$ Hi Expert- please spend your few minute only on this question.

Google is your friend. excel version differences Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Divaker Pandey Sent: Monday, March 05, 2012 8:53 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Hi Expert- please spend your few minute only on this q

Re: $$Excel-Macros$$ Hi, Friends I have a ?

Agree fully on the subject line. It is a problem with this group. sub runallmacros() call macro1 call macro2 call macro3 end sub Don Guillett SalesAid Software dguille...@gmail.com From: xlstime Sent: Monday, February 20, 2012 2:54 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel

RE: $$Excel-Macros$$ Hi, Friend I have a ? (I did not express properly in my previous mail - so let us have it right now)....

Hope this helps. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of xlstime Sent: Monday, February 20, 2012 12:50 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Hi, Friend I have a ? (I did not express properly in my previous mail

Re: $$Excel-Macros$$ Hi, Friends I have a ?

Hi Mohammed Muneer, you must be use proper subject line or Use concise, accurate thread titles. for get quick attention or answered. On Mon, Feb 20, 2012 at 12:22 PM, Mohammed Muneer wrote: > How to merge the Multiple Macro’s in single program? > > ** ** > > ** ** > > > > ** ** > > **

Re: $$Excel-Macros$$ Hi, Friend I have a ? (I did not express properly in my previous mail - so let us have it right now)....

if i am not wrong u can use CALL macro function On Mon, Feb 20, 2012 at 12:44 PM, Mohammed Muneer wrote: > How to merge the Multiple Macro’s in single program? > > My question is little jovial – but still it is trying to learn some thing > from u masters. Thanx anyway > > **

Re: $$Excel-Macros$$ Hi friends, now its clear.....

Just a thought. Are you trying to say that if there is a common word in all the lines, you need to know that word? Example I let you go Let me in Who let the dogs out To let and you need the value in your first column to be '*let*'? I'd say caramba! if that's the case And Excel_Lover, you nee

Re: $$Excel-Macros$$ hi can you solve this

Hi Renuka, Please find the attached file. I have used the below formula to solve. =SMALL(IF(D2:D11<=G2,D2:D11),{7,6,5,4,3,2}) Regards, MARIES. On Thu, Dec 8, 2011 at 5:40 PM, NOORAIN ANSARI wrote: > Hi Renuka, > > Can you more explain your query.. > > > Thanks & regards, > Noorain Ansari > *

Re: $$Excel-Macros$$ hi can you solve this

Hi Renuka, Can you more explain your query.. Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Thu, Dec 8, 2011 at 6:56 PM, Renukachari Kasee wrote: > > *

RE: $$Excel-Macros$$ Hi

You can Visit these sites : www.ozgrid.com www.cpearson.com http://akoul.wordpress.com/2011/05/28/excel-video-tutorials/ www.akoul.blogspot.com www.excelpoweruser.com www.ozgrid.com akoul.posterous.com www.mrexcel.com www.contextures.com www.rondebruin.nl peltiertech.com chandoo.org www.mvps.org/

Re: $$Excel-Macros$$ Hi

Hi, See below links.. http://www.excel-vba.com/ http://www.ozgrid.com/VBA/ http://excelvbatutor.com/ *Best Regards,* *Venkat * *Chennai* * * On Fri, Aug 26, 2011 at 8:54 PM, Mohamed Youssouf < youssouf.mohame...@gmail.com> wrote: > I'd like to learn how ti use MACRO > > -- > > -

Re: $$Excel-Macros$$ Hi

http://chrisrae.com/vba/whatisvba.html http://www.excel-vba.com/ http://www.excel-vba-easy.com/ http://www.youtube.com/watch?v=t1vdt0FddsE On Fri, Aug 26, 2011 at 10:24 PM, Mohamed Youssouf < youssouf.mohame...@gmail.com> wrote: > I'd like to learn how ti use MACRO -- -

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

Sam Are you asking me or to whom you are referring to call you? Here is my number : 09866902757 On Tue, Aug 2, 2011 at 5:25 AM, Sam K wrote: > give me call at 12 tomorrow; or leave sms 028482 > > On Mon, Jul 25, 2011 at 7:00 PM, krishna mummina > wrote: > >> Hi Group, >> >> My Name is kris

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

give me call at 12 tomorrow; or leave sms 028482 On Mon, Jul 25, 2011 at 7:00 PM, krishna mummina wrote: > Hi Group, > > My Name is krishna, Working as a Data Analyst from the last 3 years. My > daily work includes working with excel, Creating General Reports, Pdf to > Excel Conversion, Data

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

Welcome Krish On Sat, Jul 30, 2011 at 10:01 PM, krishna mummina wrote: > vijaykumar and venkat > > thank you very much for your valuable input. > > > On Sat, Jul 30, 2011 at 8:23 PM, P.VIJAYKUMAR wrote: > >> Dear Krishna, >> >> >> The profile of MIS Executive changes with the type organisatio

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

vijaykumar and venkat thank you very much for your valuable input. On Sat, Jul 30, 2011 at 8:23 PM, P.VIJAYKUMAR wrote: > Dear Krishna, > > > The profile of MIS Executive changes with the type organisation.If it is a > small organisation MIS Executive role would be to prepare normal reports >

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

Dear Krishna, The profile of MIS Executive changes with the type organisation.If it is a small organisation MIS Executive role would be to prepare normal reports like the work you do.If it is a big and reputed organisation your role in addition to normal report preparation would be to do fianaci

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

Hi Kirish, Just go to Linked in and search MIS Executive and see what are all responsibilities and then you may get clear Picture what they are doing... *Best Regards,* *Venkat* *Chennai* On Sat, Jul 30, 2011 at 11:41 AM, krishna mummina wrote: > Thank you very much for the links. Most of them

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

Thank you very much for the links. Most of them are just a normal reports like using the basic formulas. Is this is all about MIS Executive role to create the reports like this? Waiting for your reply - krrish On Sat, Jul 30, 2011 at 12:06 AM, XLS S wrote: > Please find the below links > > http

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

Please find the below links http://www.citesales.com/ http://www.ksde.org/Default.aspx?tabid=2836 On Fri, Jul 29, 2011 at 9:05 PM, krishna mummina wrote: > Thank you very much for the total input guys. > > Now, I just want to see some of the example reports and some excel sheets. > Is there any

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

Thank you very much for the total input guys. Now, I just want to see some of the example reports and some excel sheets. Is there any site to find those reports etc..? Waiting for your kind reply - krrish On Wed, Jul 27, 2011 at 10:24 AM, Venkatesh Srinivas < venkateshs@gmail.com> wrote: >

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

I some how feel he need to know a bit of database basics... - Clean and organize the database before working on it... - Ensure to know the compatible formula- other features based on version and its disadvantages Regards Venkatesh +91 9841969353 On Wed, Jul 27, 2011 at 9:41 AM, XLS S

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

Thank you Very much. On Wed, Jul 27, 2011 at 9:41 AM, XLS S wrote: > Hey > > Please find below link > > http://en.wikipedia.org/wiki/Management_information_system > > On Mon, Jul 25, 2011 at 7:00 PM, krishna mummina > wrote: > >> Hi Group, >> >> My Name is krishna, Working as a Data Analyst f

Re: $$Excel-Macros$$ Hi Everybody

yes Dilip sir, its really very good sit for all type hr related document... On Wed, Jul 27, 2011 at 9:46 AM, Dilip Pandey wrote: > Nice portal and it is offering more solutions related to HR, not just > MIS reports.. > > Thanks, > DILIPandey > > On 7/27/11, XLS S wrote: > > He

Re: $$Excel-Macros$$ Hi Everybody

Nice portal and it is offering more solutions related to HR, not just MIS reports.. Thanks, DILIPandey On 7/27/11, XLS S wrote: > Hey, > > Please register and download any HR related MIS report > > http://www.citehr.com/ > > On Tue, Jul 26, 2011 at 5:29 PM, Sanjay Maurya > wrote: > >> Hi >> >> A

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

Hey Please find below link http://en.wikipedia.org/wiki/Management_information_system On Mon, Jul 25, 2011 at 7:00 PM, krishna mummina wrote: > Hi Group, > > My Name is krishna, Working as a Data Analyst from the last 3 years. My > daily work includes working with excel, Creating General Repor

Re: $$Excel-Macros$$ Hi Everybody

Hey, Please register and download any HR related MIS report http://www.citehr.com/ On Tue, Jul 26, 2011 at 5:29 PM, Sanjay Maurya wrote: > Hi > > All friends if u have these type others MIS Report file for Sales > Department and Finance Department Please forward me. > > -- > ***Thanks > Sanjay

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

Thank you very much sir, Really very detailed explanation. Once again Thank you very much. On Tue, Jul 26, 2011 at 4:28 PM, anandydr wrote: > Hi, > > In case of MIS Executives the kind of the data sets is very rigid. The > data is always in the same format. Mostly the amount of data would > als

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

Hi, In case of MIS Executives the kind of the data sets is very rigid. The data is always in the same format. Mostly the amount of data would also be the same every day/week. The frequency of reports would be also same for them, i.e. the MIS is generated on a weekly, daily or 15 days or quarterly

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

Thank you venkat, Report Generation and Data Management? If you have some examples, can you please provide those? Thanks in advance, Krrish On Tue, Jul 26, 2011 at 11:57 AM, Venkat CV wrote: > Hi Krish, > > MIS Executive Role also Same kind of role as you now doing...Reports > generation & D

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

Hi Krish, MIS Executive Role also Same kind of role as you now doing...Reports generation & Data Management activities *Best Regards,* *Venkat* *Chennai* On Mon, Jul 25, 2011 at 7:00 PM, krishna mummina wrote: > Hi Group, > > My Name is krishna, Working as a Data Analyst from the last 3 y

Re: $$Excel-Macros$$ HI --help me

Hello All, Thank You very much.. On Mon, Jul 25, 2011 at 12:20 PM, Cab Boose wrote: > Hi > > Get the PUP V3 utility on the J-Walk site. Do all errors on whole sheet > in one click. Magic. > > Charlie > > > > > > > > On Mon, Jul 25, 2011 at 6:36 PM, NOORAIN ANSARI > wrote: > >> >> >> De

Re: $$Excel-Macros$$ HI --help me

Hi Get the PUP V3 utility on the J-Walk site. Do all errors on whole sheet in one click. Magic. Charlie On Mon, Jul 25, 2011 at 6:36 PM, NOORAIN ANSARI wrote: > > > Dear Vijay, > > Please find Error remover technique. > > * Errors-World* Error Type > Erro

Re: $$Excel-Macros$$ HI --help me

Dear Vijay, Please find Error remover technique. * Errors-World* Error Type Error Remover Functions *ISNA()* *ISREF()* *ISERR()* *ISERROR()* *IFERROR()* #N/A YES YES NO YES YES #ISREF NO YES YES YES YES #NULL NO YES YES YES YES #DIV/0! NO YES YE

Re: $$Excel-Macros$$ HI --help me

use formula =IF(iserror(ur formula),"",ur formula)) On Sun, Jul 24, 2011 at 5:50 PM, vijayajith VA wrote: > Hi, > > > I have one questions.Usually while doing reports what are errors you will > get ? > > > Thanks > > -- > > -

RE: $$Excel-Macros$$ HI --help me

1) Duplicate Unique Key 2) Blank Cells 3) Wrong Data/time format 4) Wrong Data Type (Number to String) 5) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of vijayajith VA Sent: Sunday, July 24, 2011 5:51 PM To: excel-macros@goo

Re: $$Excel-Macros$$ HI --help me

It depends upon the mistakes u do. On 7/24/11, vijayajith VA wrote: > Hi, > > > I have one questions.Usually while doing reports what are errors you will > get ? > > > Thanks > > -- > -- > Some important links for exc

Re: $$Excel-Macros$$ HI --help me

Hi Vijayajith, It depends which report having what kind of formula / function / macros you are working on. I have came across following errors so far:- 1) Excel Function errors -> Can be corrected using ISError function(s) 2) VBA Macros -> Can be prevented using Error handlers 3) Linking errors

Re: $$Excel-Macros$$ HI --help me

http://www.ozgrid.com/Excel/formula-errors.htm http://chandoo.org/wp/2009/04/20/excel-formula-errors/ On Sun, Jul 24, 2011 at 6:12 PM, Venkat CV wrote: > Hi Vijay, > > In Excel You May get errors are > > #NULL!, #DIV/0!, #VALUE!,#REF!,#NAME?, #NUM! and #N/A > if u want avoid this Tou may us IF

Re: $$Excel-Macros$$ HI --help me

Hi Vijay, In Excel You May get errors are #NULL!, #DIV/0!, #VALUE!,#REF!,#NAME?, #NUM! and #N/A if u want avoid this Tou may us IFERROR or IFERROR ISERROR Function *Best Regards,* *Venkat* On Sun, Jul 24, 2011 at 5:50 PM, vijayajith VA wrote: > Hi, > > > I have one questions.Usually while do

Re: $$Excel-Macros$$ Hi I need your help , Please explain it with example.

Thanks a lot On Fri, Jul 15, 2011 at 9:44 PM, STDEV(i) wrote: > *1. > **Worksheet.Change Event* > * > *Occurs when cells on the worksheet are changed by the user or by an > external link. > This event doesn't occur when cells change during a recalculation. Use the > Calculate event to trap a she

Re: $$Excel-Macros$$ Hi I need your help , Please explain it with example.

*1. **Worksheet.Change Event* * *Occurs when cells on the worksheet are changed by the user or by an external link. This event doesn't occur when cells change during a recalculation. Use the Calculate event to trap a sheet recalculation. This example changes the color of changed cells to blue. Pri

RE: $$Excel-Macros$$ Hi I need your help , Please explain it with example.

juillet 2011 18:07 À : excel-macros@googlegroups.com Objet : RE: $$Excel-Macros$$ Hi I need your help , Please explain it with example. Hi, Private Sub Worksheet_Change(ByVal Target As Range) is fired when you enter a value into a cell Private Sub Worksheet_SelectionChange(ByVal Target

RE: $$Excel-Macros$$ Hi I need your help , Please explain it with example.

Hi, Private Sub Worksheet_Change(ByVal Target As Range) is fired when you enter a value into a cell Private Sub Worksheet_SelectionChange(ByVal Target As Range) is fired when you select another cell or if you change the current selection. In both cases, “Target” represents the

Re: $$Excel-Macros$$ Hi - Number need to fill randomly

Pls find the attached... Regards, Manoj Kumar On Wed, Dec 8, 2010 at 12:34 PM, Manjunath C wrote: > Hi Team, > > I need to fill the highlighted(brown) coloumn with numbers 1 to 90 randomly > by clicking the button "Press" each time. > Finally we need the data as highlighted in yellow. > > Thank

Re: $$Excel-Macros$$ Hi Experts, Urgent

hi Pankaj, Can you please tell what formula you are looking for. Could you please express your query in brief. Thanks, Raj On Tue, Oct 5, 2010 at 8:23 PM, Pankaj Kumar wrote: > Hi, Experts Its urgent basis i need u r help, i have a Name list A-Z, I > have sorting Name list A-Z in

Re: $$Excel-Macros$$ Hi

PFA Vaibhav J www.excel.blog.com Sent on my BlackBerry® from Vodafone -Original Message- From: Pankaj Kumar Sender: excel-macros@googlegroups.com Date: Thu, 30 Sep 2010 21:15:12 To: excel-macros Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Hi Hi, exper it urgent i

Re: $$Excel-Macros$$ Hi

Hi Pankaj, Please find attached excel for solution. Regards, Swapnil. On Thu, Sep 30, 2010 at 9:15 PM, Pankaj Kumar wrote: > Hi, exper it urgent i need u r help i attached my excel sheet > > -- > *Warm Regards > Pankaj kumar > M: 9899816107 > e-mail: rajputpanka...@gmail.com >rajp

Re: $$Excel-Macros$$ Hi

Hi Pankaj, In your attached example put the following formula in cell C2 and copy it down: =IF(NOT(ISERROR(VLOOKUP(B2,$A$2:$A$8,1,0))),"Match","Mismatch") The above formula matches the entries in the Column B with the column A. Pl let me know if this works for you. Regards, Andy On Thu, Sep 3

Re: $$Excel-Macros$$ hi-- how to transpose data in the similar gap from notepad to excel

Hi Vijay I want the format as it is in the notepad eg if there is 2 spacebar distance between the columns , and we transfer that to excel it should take the same distance so that if we want to save this excel to notepad again ( after calculation) the same distance of space ber should be maintained

Re: $$Excel-Macros$$ hi-- how to transpose data in the similar gap from notepad to excel

If you need the more shortcut then I can develop a macro for that On Wed, Sep 22, 2010 at 4:45 PM, Sanjoy Nath wrote: > Just open the notepad and find and replace all the spaces with comma > and after that close the file > and rename the file extension from .txt to .csv > > > see the magic > >

Re: $$Excel-Macros$$ hi-- how to transpose data in the similar gap from notepad to excel

Just open the notepad and find and replace all the spaces with comma and after that close the file and rename the file extension from .txt to .csv see the magic reverse process to get the thing in txt again ITS WILL WORK GREAT 2010/9/22 Abhidha Dixit > Dear ALL > > Please help how can i tr

Re: $$Excel-Macros$$ hi-- how to transpose data in the similar gap from notepad to excel

Hello You can copy the text in to excel and to break excel in the format as it is in not pad you have to you text to columns in the review menu of menu bar.If you text is separated by comma or colon or space or other delimiters you can choose delimited option and choose the symbol that separates

Re: $$Excel-Macros$$ hi-- how to transpose data in the similar gap from notepad to excel

Please Check this 2010/9/22 Abhidha Dixit > Dear ALL > > Please help how can i transpose the data from notepad to excel with the > similar colomn gap so that when we copy this again to notebook i shall get > the data with the samilar spaces > > thanks > > -- > > ---

Re: $$Excel-Macros$$ Hi

you have to send your posting from your email-client, not from the group web. On Thu, Sep 16, 2010 at 4:03 PM, dinoabeer wrote: > > Can somebody help. I m a newbie here. how do I upload I file when I > post something> -- -

Re: $$Excel-Macros$$ hi

In addition to the above, also please check the following link: http://chandoo.org/excel-formulas/vlookup.html Thnx Vinod N On Sat, Aug 28, 2010 at 8:04 PM, rajasekhar praharaju < rajasekhar.prahar...@gmail.com> wrote: > Hi, > > > Adding to this..

Re: $$Excel-Macros$$ Hi all

http://office.microsoft.com/en-us/excel-help/25-easy-pivottable-reports-HA001034633.aspx http://www.timeatlas.com/5_minute_tips/chunkers/learn_to_use_pivot_tables_in_excel_2007_to_organize_data

Re: $$Excel-Macros$$ Hi all

Learn from Help menu in excel On Sat, Aug 28, 2010 at 11:05 AM, Pankaj Kumar wrote: > Hi, All, > > > I am fresher in ms excel & wanted to learned how to prepared Pivot table & > report in Msexcel > > -- > *Warm Regards > Pankaj kumar > M: 9899816107 > e-mail: rajputpanka...@gmail.com >

Re: $$Excel-Macros$$ Hi all

Table Complited Go to data cleck privot table select range finist On Sat, Aug 28, 2010 at 11:05 AM, Pankaj Kumar wrote: > Hi, All, > > > I am fresher in ms excel & wanted to learned how to prepared Pivot table & > report in Msexcel > > -- > *Warm Regards > Pankaj kumar > M: 9899816107 > e

Re: $$Excel-Macros$$ hi

Hi Pankaj, Vlookup means Vertical lookup that is find the given value in vartical order. vlookup is the way to find the particular data from master file. It gives the data in vertical manner from the right side of the column against which data has to find. Syntax VLOOKUP(lookup_value,table_array

Re: $$Excel-Macros$$ hi

Dear Pankaj, Please find attachment with simple example of Vlookup & Hlookup. - Vlookup always take right value. - Vlookup doesn't take duplicate value. Thanks, Noorain Ansari On Fri, Aug 27, 2010 at 10:54 AM, Pankaj Kumar wrote: > Hi, > > Can anyone help me to understand what is Vlo

Re: $$Excel-Macros$$ hi

Press F1 Key and see the examples. On Fri, Aug 27, 2010 at 10:54 AM, Pankaj Kumar wrote: > Hi, > > Can anyone help me to understand what is Vlookup & Hlookup,for a short > example how to use it ,, > > -- > *Warm Regards > Pankaj kumar > M: 9899816107 > e-mail: rajputpanka...@gmail.com >

Re: $$Excel-Macros$$ Hi, need your help - urgent

Good! But instead of copy paste we can use bring to front by keeping all images on same position. On Thu, Jul 1, 2010 at 7:38 PM, ashish koul wrote: > hi > > > Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As > Boolean) > > > If ActiveCell.Row = 2 And ActiveCell.Column =

Re: $$Excel-Macros$$ Hi, need your help - urgent

hi i need help how i can secure a hidden sheet no any one can unhide and modify it. Regards Ni On Thu, Jul 1, 2010 at 7:38 AM, ashish koul wrote: > hi > > > Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As > Boolean) > > > If ActiveCell.Row = 2 And ActiveCell.Column

Re: $$Excel-Macros$$ Hi, need your help - urgent

Hi Rajender, I am not quite sure how would you want to do it. However there is a very simple solution mentioned in the link below, which almost does what you are trying to achieve. http://www.excelforum.com/excel-general/713781-display-an-image-based-on-a-cells-value.html

Re: $$Excel-Macros$$ hi-help required .

thanks ..thanks a lot. one little doubt...if i delete or add a qty in the list...then pivot table is not updated immediately ? i need it to be updated regards,sarvesh lahoti. --- On Tue, 6/4/10, rf1234 rf1234 wrote: From: rf1234 rf1234 Subject: Re: $$Excel-Macros$$ hi-help required . To

Re: $$Excel-Macros$$ hi-help required .

Here is the solution attached you can do it with the help of sumproduct formula or with Sumif Formula Regards Hemant On Mon, Apr 5, 2010 at 2:24 PM, Sarvesh wrote: > > hi > > i have a worksheet where sizes and qty are maintained for each item in this > way > > 460*12 Pet 31 460*12 Pet 265 46

Re: $$Excel-Macros$$ hi-help required .

6/4/10, rf1234 rf1234 * wrote: > > > From: rf1234 rf1234 > Subject: Re: $$Excel-Macros$$ hi-help required . > To: excel-macros@googlegroups.com > Cc: sarve...@yahoo.com > Date: Tuesday, 6 April, 2010, 10:52 AM > > > Hello Dear, > Attached workbook has a sample for yo

Re: $$Excel-Macros$$ Hi Please Help ME

Hello Dear, I am unable to understand your problem.Please 1'st explain problem. In your attachment,you have not explain your problem. Please Reply So that we can understand your requirements. On Mon, Mar 22, 2010 at 3:27 PM, anil panchal wrote: > Hi All > > A NB MTRL NB Width Ex

Re: $$Excel-Macros$$ hi all

what is it supposed to do? On Fri, Mar 19, 2010 at 9:49 AM, Puttaswamy wrote: > How to use that, its not working for me? what is the use of that sheet? > > > On Fri, Mar 19, 2010 at 11:54 AM, ashish koul wrote: > >> just find it on goole see if it useful to u >> >> -- >> >> -

Re: $$Excel-Macros$$ hi all

How to use that, its not working for me? what is the use of that sheet? On Fri, Mar 19, 2010 at 11:54 AM, ashish koul wrote: > just find it on goole see if it useful to u > > -- > > -- > Some important links for exce

Re: $$Excel-Macros$$ Hi Help in Excel

hi harish Ayush saying is true, unless u dont try by urself u will never learn...if you really want to learn ask any specific funtion or formula, we will be happy to make it clear to you for any query you can mail me On 26/01/2010, ayush jain wrote: > Dude, This forum is to help genuine &

Re: $$Excel-Macros$$ Hi Help in Excel

Dude, This forum is to help genuine & real life problems of excel and macros users. Your test appears to be quite simple and it was made to test your capability. You will not be able to learn if we will solve it. First try at your end and if you find any problems in specific question, just let us

Re: $$Excel-Macros$$ hi

Your being troubled by "array functions". those curly brackets cannot be entered manually. On Fri, Nov 13, 2009 at 3:45 AM, Shraddha Shah wrote: > Hi, > > > > We are using the attached file to prepare certain reports for the bank. > > > > We need to actually bucket the all the deposits as per th

  1   2   >