$$Excel-Macros$$ Formula to delete Rows

Dear Experts, Need your help! On the attached if : Column C if the value is below 500 then the row must automatically Delete If column D if the value is below 0 the row must automatically delete and if column E the value is below 0.04 the row must automatically delete. Can you please help me w

$$Excel-Macros$$ Need help in picking data and updating in new sheet via Macro

Hi Group... Would appreciate if someone can help me in creating a macro or any formulated template to pick data from one sheet and update in other sheet. Process:--- Input sheet has 3 tabs: '*IntraState-Inter InterLata SDN'*, '*International Outbound'* and '*Mobile Offshore'.* ** Output sheet ha

$$Excel-Macros$$ sample template

Hi Experts Can i perform machine learning techniques on Excel...if so can i have copy and understand how to use it. Thanks you so much in adv Sri -- 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 @

Re: $$Excel-Macros$$ Macros Cartograms

Thank you so much On Mon, Jan 14, 2013 at 1:22 PM, Anoop K Sharma wrote: > Hi Jai, > > Please find attached file. Look at sheet2, select the country name from > combo box at upper left corner, use spin button to change the size of shape. > > Regards, > Anoop > > > O

$$Excel-Macros$$ Macros Cartograms

Hi Team, I need to write a macro on the attached template Cartogram where I can adjust a value and the size of countries in a map of the world changes (but their vague position stays the same)... Thanks a ton for the help! Sri -- Join official Facebook page of this forum @ https://www.faceb

$$Excel-Macros$$ HELP REQUIRED

Dear Groups Member Please Help me, i have attached one Sheet i need that when we fill Sheet 2 then automatically update Annual, Monthly & Sheet -1 -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Us

Re: $$Excel-Macros$$ Excel Function_Code

Please tell me how can use this add in please send the example sheet Thanks On Thu, Jul 5, 2012 at 9:52 AM, Deba Ranjan wrote: > Thanks Chile, > Working fine. > > > Thanks & Regards, > *Deba Ranjan P* > > > > > > On Wed, Jul 4, 2012 at 9:19 PM, ChilExcel wrote: > >>

Re: $$Excel-Macros$$ Vlookup is not working

please see the attachment On Thu, May 24, 2012 at 6:01 PM, Amit Gandhi wrote: > thanks sir > > On Wed, May 23, 2012 at 6:00 PM, dguillett1 wrote: > >> Also, please do not use entire columns. Restrict to only area needed. >> >> =VLOOKUP(E3,Sheet1!E1:G100,3,FALSE) >> >> Don Guillett >> Microsof

Re: $$Excel-Macros$$ How to export data from Excel to Tally

if you use Tally 9 Then you have import the excel file in tally On Fri, May 18, 2012 at 6:13 PM, raghu gr wrote: > Sir, > > I have lot of data in excel how to export it to Tally ERP 9, please give > suggestions sir. > > Thanks > Raghu > > -- > FORUM RULES (986+ members already BANNED for violati

$$Excel-Macros$$ VBA COCE Required

Hello Goups Please give me a vba code , when we open the excel sheet then give me message " Hello Welcome this sheet" please provide me the VBA CODE. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent,

Re: $$Excel-Macros$$ INDEX FUNCTION & MATCH FUNCTION

t; > On Mon, Feb 6, 2012 at 4:54 PM, NOORAIN ANSARI > wrote: > >> Dear Jai, >> >> See attached sheet >> >> On Mon, Feb 6, 2012 at 3:33 PM, Jai wrote: >> >>> Dear Excel Group Member, >>> >>> >>> Plea

$$Excel-Macros$$ INDEX FUNCTION & MATCH FUNCTION

Dear Excel Group Member, Please give the some example of index function & Match Function & how can use both function in combined. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formu

Re: $$Excel-Macros$$ want to solution of Vlookup limitation

you use only =vlookup formula On Fri, Jan 6, 2012 at 3:30 PM, Ashish Bhalara wrote: > Dear experts, > > There are a limitation of vlookup that it find out the value only from > right side of the lookup_value. I require the value from left side of > lookup_value. > Is there any solu

Re: $$Excel-Macros$$ INSERT THE ROW

THANKS A LOT On Thu, Nov 3, 2011 at 3:56 PM, ashish koul wrote: > check the attachment > > > > > On Thu, Nov 3, 2011 at 3:50 PM, Jai wrote: > >> HOW CAN INSERT THE PLEASE GIVE THE VBA CODE OR FORMULA >> >> -- >> FORUM RULES (925+ members alrea

$$Excel-Macros$$ INSERT THE ROW

HOW CAN INSERT THE PLEASE GIVE THE VBA CODE OR FORMULA -- FORUM RULES (925+ 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

Re: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row

I need also this VB Code On Mon, Oct 3, 2011 at 4:41 AM, ChilExcel wrote: > Urgent !! > i Need VB lines codes for > > 2011/10/1 ChilExcel > >> hi >> >> i Need VB lines codes for >> Alert MsgBox Pair duplicate entry in row >> >> Column D function account and duplicates alerts (NO Problem!

$$Excel-Macros$$ REMOVE THE ERROR IN THIS FILE

PLEASE HELP -- -- 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.

Re: $$Excel-Macros$$ Re: remove duplicates - is it a good code?

HOW CAN REMOVE THE DUPLICATE VALUE IN EXCEL SHEET WITH THIS CODING On Wed, Aug 3, 2011 at 5:14 AM, bpascal123 wrote: > Hi, > > This is another code with the same style as above and similar to it, > this time it highlights instead of delete duplicate values... > > I am wondering why

$$Excel-Macros$$ Vlookup Query-2

Hello Experts I Have a one Qurery Please Check the attachment -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN gro

Re: $$Excel-Macros$$ Vlookup Regarding Query Please Help

THIS Realy Good Formula Thaks On Wed, Jul 6, 2011 at 3:49 PM, NOORAIN ANSARI wrote: > Dear Jai, > > Please try it without helping column.. > > =VLOOKUP(B7&"*",Sheet1!B7:C12,2,) > > > Thanks & regards, > Noorain Ansari > *http://noorain-ansari.b

Re: $$Excel-Macros$$ Vlookup Regarding Query Please Help

Thanks of Lot Sir On Wed, Jul 6, 2011 at 3:42 PM, ankur wrote: > *hi jai > find the attached filethis has slight modification of venkatesan > solution...the repeat of name is taken care , as u required tell me it > helps? > *Have A Nice Time & Enjoy Life >

$$Excel-Macros$$ Vlookup Regarding Query Please Help

-- -- 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 tutor

$$Excel-Macros$$ Maill Merge in Two Excel Sheet

Dear Experts i wnat to mail merge From Sheet -2 To Sheet -1, in Sheet -2 , Name, Desination, & Emp code . -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitt

$$Excel-Macros$$ Mail Merge Regarding

Hello EveryBody Can You tell me that , Mail Merge is possible in One Excel File to Another Excel file , if it is possible then How? -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks

Re: Falha ao cancelar a mensagem: $$Excel-Macros$$ Recall: Help on Percentile Function

Dear Ankur Padey Sir How are you? On Thu, Jun 30, 2011 at 4:12 PM, ankur wrote: > hi gilberto > your file is undownloadable > Have A Nice Time & Enjoy Life > > Regards: > CMA Ankur Pandey > (Someone Different) > > I'm not the best but i'm not like the rest~~ > > > > On Mon, Jun 20

Re: $$Excel-Macros$$ Password protect & unprotect sheets using code

Please send excel file. On Fri, Apr 15, 2011 at 5:21 PM, Rajesh K R wrote: > Hi Experts, > > I want to password protect my work sheets, but the same time it is > necessary to unprotect it for the running of macro so i have to give a > code to unprotect them. how can I do it. > > Regards > > Rajes

$$Excel-Macros$$ Command button

Dear Expert i Have a Excel file, i Want to use Command button in vba code please help me. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailyt

$$Excel-Macros$$

*Wishing you all Very happy and prosperous New Year* -- -- 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 @ h

$$Excel-Macros$$

Dear Expet please tell me that how can you excel button in vba coding. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Link

Re: $$Excel-Macros$$ EXCEL SHEET IN SEPARATE TOOL BAR

Dear Expert Can you tell me that what is work of This functions Please. On Sun, Dec 5, 2010 at 11:16 AM, ashish koul wrote: > try this addin save it on your dektop and double click it. > > > On Sun, Dec 5, 2010 at 12:46 AM, ChilExcel wrote: > >> yes >> >> yes, download this application .

Re: $$Excel-Macros$$ Please help regard this question

THANKS A LOST EXPERTS On Fri, Nov 12, 2010 at 3:59 PM, SAJID MANSOOR wrote: > Very simple! Good > > > On Fri, Nov 12, 2010 at 11:49 AM, NOORAIN ANSARI > wrote: > >> Dear Jai... >> >> Please see attachment.. >> >> =TEXT(D5-D6,"YY ")&a

$$Excel-Macros$$ Please help regard this question

Dear Groups First Cell 20/12/2011 Secound Cell 12/11/2010 Required Results 1 YEAR ,1 MONTH ,8 DAYS LEFT DEAR GROUP MEMBER PLEASE HELP ME, I WANT TO NEED THAT WHEN WE LESS FIRST CELL TO SECOUND CELL Required Results 1 YEAR ,1 MONTH ,8 DAYS LE

$$Excel-Macros$$ VBA PASSWARD REGARDEING

Dear Group member, please provide the VBA Code to protect the excle file, When we open the excel file he need passward. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :

Re: $$Excel-Macros$$ help required

Please check the attachment, On Tue, Oct 19, 2010 at 10:32 AM, girish kumar wrote: > Hi Krishna, > > see file attached, in that second sheet u see in b column i used Left > function and in c column Vlookup > > left function i used =left(A2.13) > > and vlookup answer is #N/A > > Becau

$$Excel-Macros$$ VBA Passward

I need VBA Passward in Excel , Because When Anybody open in excel file he want VBA Passward . Thaks in Advance -- Thanks For Mail. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tr

Re: $$Excel-Macros$$ Ayush Jain – Microsoft MVP 20 10

U deserve this Friend. On Mon, Oct 4, 2010 at 9:35 AM, C.G.Kumar wrote: > Congratulation friend on reaching a milestone. Hope may more to come > > On Sun, Oct 3, 2010 at 3:47 PM, Ayush wrote: > >> Dear Group, >> >> I am proud to announce that I am awarded Microsoft Most Valuable >> Profess

Re: $$Excel-Macros$$ Fwd: कविता :- उस Expert का शुभ नाम है......पाण् डेय MR. दिलीप जी.

Awesome ! It's only brief introduction of pandey ji pandey ji is like BOOK(Big Ocean Of Knowledge) where all VBA developers meet like rivers. * Best Regard, * * *** *...@i Deo t...@ri* *Software Engineer* *(Radar Technologies) b...@dohi(UP) to b...@ng@lore-560038* ***

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$$ Need Solution

Dear , Please Check the attachment. On Tue, Sep 7, 2010 at 9:19 AM, Dave Bonallack wrote: > Hi, > This seems to be a straight-forward job for SUMIF or SUMPRODUCT. > SUMIF is well explained in the help. > Let me know if you need more help, or if I have mis-interpreted your needs. > Regards - Dave.

$$Excel-Macros$$

Hello Experts Can you Tell me that how can Hide the One Cell in Excel in Sheet. -- Thanks For Mail. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.co

$$Excel-Macros$$ Risk

Dear Team, Does anyone have excel spreadsheets for dtermining capital,operational and market risk Sri -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.c

Re: $$Excel-Macros$$ Please check the attachment.

Thank a lot sir On Sat, Jul 10, 2010 at 4:27 PM, Born to Win wrote: > Dear Jai, > > Please check attached sheet. > > Thanks, > Chandrabhan Singh > > > > On Sat, Jul 10, 2010 at 1:03 AM, Jai wrot

$$Excel-Macros$$ Please check the attachment.

-- Thanks For Mail. -- -- 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=18

$$Excel-Macros$$ Dear Group Help Me Regarding Conditional Formating

Pleaese Check the Attachment -- Thanks For Mail. -- -- 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://

Re: $$Excel-Macros$$ PAID LIST TRACER

Please send the file On Wed, Jun 2, 2010 at 5:07 PM, Chandra Gupt Kumar wrote: > Kindly attach the worksheet. > > -Original Message- > From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] > On Behalf Of siva > Sent: Friday, May 28, 2010 3:38 PM > To: MS EXCEL AND VBA

Re: $$Excel-Macros$$ help in excel formula

use ; Today()-1 On Sat, May 29, 2010 at 9:58 PM, Deepak Pal Singh wrote: > You can use =Today()-1 > > > > > On Fri, May 28, 2010 at 10:07 PM, Surendra saxena wrote: > >> Hi All, >> >> need you help to fix the formula in excel like below- >> >> (-Today+End.date) >> >> i want to fix t

$$Excel-Macros$$ Urgent Help

hi priyan,,,aamir here,, priyan, I recently downloaded this file encrpytion program : http://priyanr.somee.com/downloads/folderprotect.zip It was working good until a few weeks later when suddenly all my locked folders changed into a control panel icon. Usually to unlock it, i would just have to

Re: $$Excel-Macros$$ Help with Median Formula

Hi All, wots fantastic group where Dilip kind of helping people available . my saveral students are getting lots of benefits from all the members of this group specially from Dilip Pandey. Thanks a lot to all ! _ j...@i Deo t...@ri |

$$Excel-Macros$$ Sumproduct

Dear All, Can you tell me that what is the work of sum product. -- Thanks For Mail. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2

$$Excel-Macros$$ PDF EDITOR

Dear All Groups Members I Need In PDF Editor Can you Give me ?, This is very urgent for me. -- Thanks For Mail. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : h

Re: $$Excel-Macros$$ Need Passward Cracker

> Dear All, > > Can you Give me VBA Passward Cracker, > -- > Thanks For Mail. > > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Jo

$$Excel-Macros$$ Need Passward Cracker

Dear All, Can you Give me VBA Passward Cracker, -- Thanks For Mail. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Faceb

$$Excel-Macros$$ FILTER

Dear All Members. How can put the filter 2 times in One Excel file . -- Thanks For Mail. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldai

$$Excel-Macros$$ help

Dear All, How can protect the file with vba passward ? -- Thanks For Mail. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Jo

$$Excel-Macros$$ how can protect the excel sheet in VBA Passward.

DEAR ALL,EXPERTS Can you Tell me that how can protect the excel sheet in VBA Passward. -- Thanks For Mail. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://

$$Excel-Macros$$ Help Me Expert

Dear All Experts Help Me, Please Check the Attachment. I have bigcardtext But he not Work Properley, When we convert the Number For Example 600 he Convert the Amount the in Million Please help me i want to convert the this amount in Rupees Sixty Lac. -- Thanks For Mail. -- --

Re: $$Excel-Macros$$

On Fri, Mar 19, 2010 at 6:24 PM, Jai wrote: > Dear All, > > I have a big card text but he not wrok properly when we convert the amount > suppose that 100 he gives the reults Million but we net Indian Rupes i > want to say he convet the amount in indian Rupess. Please Help me.

$$Excel-Macros$$

Dear All, I have a big card text but he not wrok properly when we convert the amount suppose that 100 he gives the reults Million but we net Indian Rupes i want to say he convet the amount in indian Rupess. -- Thanks For Mail. --

Re: $$Excel-Macros$$ CONVERT chk it

Dear Sir, This is not work properly On Tue, Mar 16, 2010 at 5:13 PM, Vikas Chouhan wrote: > Hi, > > > Dear , > > > open attachment and follow instruction > > > *Press Alt+t+m+v and after that press f5 and enter > > * > On T

Re: $$Excel-Macros$$ CONVERT

Dear Sir I need in MS Word, Convert Number to Text. On Tue, Mar 16, 2010 at 5:23 PM, Roshan Mathew wrote: > Hi Jai, > > As I am aware, the following is possible during Mail Merge > > After Inserting the Merge Feild which is a numberic field, pls follow the &g

Re: $$Excel-Macros$$ CONVERT

Thank You On Tue, Mar 16, 2010 at 3:33 PM, Aindril De wrote: > Hi, > > Please use the macro in the following link: > http://wordribbon.tips.net/Pages/T007755_Converting_Numbers_to_Text.html > > Regards, > Andy > > On Tue, Mar 16, 2010 at 2:13 PM, Ja

$$Excel-Macros$$ CONVERT

Hello All, Please Tell me That, Can we convert number to Text In Ms Word -2007, For Example 2000 (Number) Two thousand (Text) -- -- Some important links for excel users: 1. Follow us on TWI

$$Excel-Macros$$ Re: Please help

On Tue, Feb 2, 2010 at 7:02 PM, Sri Jai wrote: > Dear All, > > Can somebody please help me on the below two scenarios > > 1) On the attached I would like to have columns E, F, G and H which is > highlighted Yellow below when I run a Macro. These new columns must be > a

$$Excel-Macros$$ Re: Excel Macro

Hi everyone, How to handle pivot table and pivot chart using VBA please can you send me attachment for this == Jai Deo Tiwari, Bangalore - 38

$$Excel-Macros$$ Re: VBA

Thank you Sarfaraz ! -- Regards, Jai Deo Tiwari, Rewire Information Systems Indiranagar, Bangalore - 38 Mob # 09620346991 . Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended

$$Excel-Macros$$ Re: Class Module

Hi everyone, Please tell me how to use v-lookup and h-lookup using VBA. If possible please attach the docs of example. > > > > -- Regards, Jai Deo Tiwari, Rewire Information Systems Indiranagar, Bangalore - 38 Mob # 09620346991 . Notice: The information contained in this e-

$$Excel-Macros$$ Re: Getting top 50 ranks from a pivot table

Hi All, I am new for VBA.But i am working as developer in Java Tech. Please suggest me how to learn VBA ? -- Regards, Jai Deo Tiwari, Rewire Information Systems Indiranagar, Bangalore - 38 Mob # 09620346991 . Notice: The information contained in this e-mail message and/or attachments to

$$Excel-Macros$$ Re: Puzzle #3 - Identify Perfect and Smith Numbers

> Puzzle #2 - > > >http://groups.google.com/group/excel-macros/browse_thread/thread/b4d2. > .. > > > Solved by - Bruno and Sandeep > > > > > > -- > > > Thanks & Regards > > > Ashish Jain > > > (Excel Macros - Google G

$$Excel-Macros$$ Re: want a macro code

0 i = 0 Err1: End Sub only you have to paste this code on vba editor Alt+F11 double click on sheet1 and paste it there it will run. Regards, Jai Kishan On May 20, 10:10 am, Deepak Rawat wrote: > Hi all!i have attached a file, there is 5 fields in the file >

$$Excel-Macros$$ Re: change from small letter to capital

ch i have typed in small letters > now wants to change those things in the Big letters . reply fast its > urgent > > -- > Regards, > Vinay Keni > > > > > > -- Its, Jai --~--~-~--~~~---~--~~ Visit the blog to download Exce