$$Excel-Macros$$ how to extract text from a cell? urgent need !!!

Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA

$$Excel-Macros$$ vlookup urgent help

no. amount i want to extract amount from shhet 2 , if party name bill name of sheet 1 are same in other words, i want to compare both party name and bill no. from sheet 1 sheet 2 and if they match i want to get amount from sheet 2 please help me Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey

$$Excel-Macros$$ macro book!!urgent help

for positive reply. thanks in advance Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ --~--~-~--~~~---~--~~ - Some

$$Excel-Macros$$ Re: Microsoft Office 2007 ebooks collection

sir this link is not working properly, can u guide me how to download the file 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 Wed, Jul 22, 2009 at 10:48 AM, Vivek Agrawalvivek.agrawa...@gmail.com wrote: Hello

$$Excel-Macros$$ Re: Microsoft Office 2007 ebooks collection

thank u sir i got the link ,i m downloading the books 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 Wed, Jul 22, 2009 at 3:13 PM, vivek agrawalvivek.agrawa...@gmail.com wrote: I did not track the site from where

$$Excel-Macros$$ Re: Hii

hi Mr. Upendra sorry for misspelling your name i m really sorry for that 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 Wed, Jul 22, 2009 at 8:29 PM, Upendra Singhupendrasinghsen...@gmail.com wrote: Hi Ankur

$$Excel-Macros$$ protect track changes from Accept or Reject Changes option

Hello Excel Gurus is there any way to disable the Accept or Reject Changes option i dont want anybody else to accept or reject changes made in the excel sheet i want to put password in that option urgent reply needed Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone

Re: $$Excel-Macros$$ Extract Comma separated Data

*@ David very good way to solve the above said query...It's really amazing trick... @ Maries.nice one TOday i learn two more tricks out of Countless.. * Regards: CMA Ankur Pandey Visit My Site http://cmaankur.wordpress.com/ On Mon, Jun 11, 2012 at 12:49 PM, Maries talk2mar...@gmail.com

Re: $$Excel-Macros$$ FW: Highlighting the Text based on the Week day.....

knowledge of VBA ,its just an effort Note : Choose no. in input box : 1 for sunday , 2 for monday and so on Thanks* Regards: CMA Ankur Pandey Visit My Site http://cmaankur.wordpress.com/ On Mon, Jun 11, 2012 at 9:08 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Muneer, See

Re: $$Excel-Macros$$ FW: Highlighting the Text based on the Week day.....

*@ Noorain Sir... only one word...Awesome. * Regards: CMA Ankur Pandey Visit My Site http://cmaankur.wordpress.com/ On Mon, Jun 11, 2012 at 11:01 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Ankur, Excellent Job.. I have improved it, see attached sheet.. -- Thanks

Re: $$Excel-Macros$$ Date format change by running the macro

(A1).Select ActiveCell.FormulaR1C1 = _ =DATE(LEFT(RC[-1],4),MID(RC[-1],5,2),RIGHT(RC[-1],2)) ActiveCell.Select Selection.AutoFill Destination:=ActiveCell.Range(A1:A500) ActiveCell.Range(A1:A1).Select End Sub * Regards: CMA Ankur Pandey Visit My Site http

Re: $$Excel-Macros$$ Excel Function details collection required

Hi Divakar You can Download file from here http://www.xlfdic.com/ It will explain you most of the functions with examples and syntax Regards: CMA Ankur Pandey On Tue, Jun 12, 2012 at 1:54 PM, Divaker Pandey divake...@gmail.com wrote: Hi Members, I have required syntax and details

Re: $$Excel-Macros$$ Date

Dear Chandra, Try this one DATEDIF(A2,B2,d) for Formula1(Days) TEXT(B2-A2,[h]:mm:ss) for Formula2(hr:mm:ss) CONCATENATE(C2, Days ,HOUR(D2), Hr ,MINUTE(D2), Mins ,SECOND(D2), Sec) for Formula3 Regards: CMA Ankur Pandey On Tue, Jun 12, 2012 at 7:58 PM, NOORAIN ANSARI noorain.ans

Re: $$Excel-Macros$$ Macro for column size reduction

: CMA Ankur Pandey -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post

Re: $$Excel-Macros$$ vlookup -please help on the attachment

hi Smitha i hope this is your requirement PFA Regards: CMA Ankur Pandey On Mon, Jun 18, 2012 at 11:28 AM, Smitha S R sperdwo...@gmail.com wrote: Hi, PFA my vlookup table. If I select the nature of expenses, corresponding expenses main head should come from the second worksheet anemd

Re: $$Excel-Macros$$ Seems Like comments but Not

yes, datavalidation-input message Regards: CMA Ankur Pandey On Fri, Jun 15, 2012 at 4:13 PM, Anil Gawli gawlianil8...@gmail.com wrote: Yes that is created by data validation Ahmed is Right. Regards, Gawli Anil On Fri, Jun 15, 2012 at 4:03 PM, Ahmed Honest ahmedhon

Re: $$Excel-Macros$$ Need help on Validation

Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads

Re: $$Excel-Macros$$ Need help on Validation

hi mahesh thanks for compliment On 12/22/09, Mahesh mahender.bi...@gmail.com wrote: Hi Ankur, Thanx a lot... jst a simple word for this is AWESOME On Tue, Dec 22, 2009 at 11:19 AM, ankur ankurpande...@gmail.com wrote: hi mahesh check the sheet, your query has been solved On 12

Re: $$Excel-Macros$$ Need help on Validation

hi vinod now check this one On 12/23/09, Vinod N nvino...@gmail.com wrote: Hi Ankur, When Tamilnadu is selected, the Hub validation is not working... all other regions are working fine... Please check and revert.. A new learning about data validation Thanks a lott... Thanks Vinod N

Re: $$Excel-Macros$$ Re: Please solve my prob.with validation.

from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best

$$Excel-Macros$$ TEXT(MONTH(NOW()),mmm) Always Returns Jan

on a worksheet, type the following formula into a cell: =TEXT(NOW(),mmm) this will return correct month -- Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest

Re: $$Excel-Macros$$ HAPPY NEW YEAR

notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest

Re: $$Excel-Macros$$

Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ -- -- Some important links for excel users: 1. Follow us in TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel

Re: $$Excel-Macros$$ Extracting

the date part of this field - I don't want the time, but I cannot use =Left(A1,10) as the cell is not text. Any help would be appreciated. Cliff -- Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest

Re: $$Excel-Macros$$ Advance Excel

/subscribe -- Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ -- -- Some important links for excel users: 1. Follow us in TWITTER for tips tricks

Re: $$Excel-Macros$$ Code User Laval

/subscribe -- Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ -- -- Some important links for excel users: 1. Follow us in TWITTER for tips

Re: $$Excel-Macros$$ Help required in conditional formatting

Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ -- -- Some important links for excel users: 1. Follow us in TWITTER for tips tricks and links : http

Re: $$Excel-Macros$$ Excel Solver

and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best

Re: $$Excel-Macros$$ Combining mulitple rows into one row

Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ -- -- Some important links for excel users: 1. Follow us in TWITTER for tips tricks and links : http://twitter.com

Re: $$Excel-Macros$$ altering excel lookup tables

nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like

Re: $$Excel-Macros$$ Kindly help!! Sumif vba needed.

columns/rows. Is this possible? Regards, Vin -- Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ -- -- Some important links for excel

Re: $$Excel-Macros$$ Name of last Month

will be automatically updated as per my requirement. -- With Love, Mahesh Bisht -- Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ -- -- Some

Re: $$Excel-Macros$$ Name of last Month

hi mahesh Sorry for geting your question wrongly, my answer will get only present month. On 1/13/10, ankur ankurpande...@gmail.com wrote: hi mahesh write this formula in your coloum heading =For the month of TEXT(TODAY(),mmm,) for any more clarification , u can mail me On 1/13/10

Re: $$Excel-Macros$$ Re: Password crecker for Excel workbbok

Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ -- -- Some important links for excel users: 1. Follow us in TWITTER for tips tricks and links : http

Re: $$Excel-Macros$$ Name of last Month

hi mahesh this will help u =For the month of TEXT(EOMONTH(TODAY(),-1),mmm,) On 1/13/10, ankur ankurpande...@gmail.com wrote: hi mahesh Sorry for geting your question wrongly, my answer will get only present month. On 1/13/10, ankur ankurpande...@gmail.com wrote: hi mahesh write

Re: $$Excel-Macros$$ Re: help

hi rahul be specific to your question 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 Wed, Jan 13, 2010 at 5:02 PM, Dilip Pandey dilipan...@gmail.com wrote: Dear Rahul, Please explain what column or what data you

Re: $$Excel-Macros$$ Tabulating Real time price data in an Excel sheet

hi Gurmeet can i have sample file,then it will be easy 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 Thu, Jan 14, 2010 at 2:19 PM, Gurmeet Singh gurmeetsingh.meh...@gmail.com wrote: Hi, Current Situation: I

Re: $$Excel-Macros$$ Multiple Charts from one Pivot table

hi Siggy plz check below link, this can help u http://www.linkedin.com/answers/career-education/occupational-training/CAR_OCT/552422-12267407 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 Wed, Jan 13, 2010 at 3:17

Re: $$Excel-Macros$$ Kindly help!! Sumif vba needed.

hi ashish good work 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 Thu, Jan 14, 2010 at 6:52 PM, kvc praveen kumar pkkara...@gmail.com wrote: Thanks Vinod.. Glad that it was helpful!! On Thu, Jan 14, 2010 at 5:51

Re: $$Excel-Macros$$ how can I get data customer wise and Salesman wise automatically when I update master sheet1 in their respective sheet.

to group at http://groups.google.com/group/excel-macros/subscribe -- Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ -- -- Some important

Re: $$Excel-Macros$$ Re: Password crecker for Excel workbbok

hi bro check your file at http://www.file-encryptor.com/ i think your file is corrupted 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 Sat, Jan 16, 2010 at 6:04 PM, champaneriya nipun champ.ni...@gmail.com wrote

Re: $$Excel-Macros$$ How to Extract Data from a Line written in a cell.

me out to extract the data. Regards Rahul Gandhi. -- Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ -- -- Some important links for excel

Re: $$Excel-Macros$$ How to Extract Data from a Line written in a cell.

/group/excel-macros/subscribe -- Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ -- -- Some important links for excel users: 1. Follow us

Re: $$Excel-Macros$$ Help

HI Sudir plz check the attached file you can hide red shaded column your original data will reflect the total i had used this formula in cells +IF(ISTEXT(B3),VALUE(+IF(B3=-,0,LEFT(B3,FIND((,B3,1)-1))),B3) Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm

Re: $$Excel-Macros$$ How to Extract Data from a Line written in a cell.

friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest

Re: $$Excel-Macros$$ help

a file. Pl assist me. -- Ganesh Gawde -- Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ -- -- Some important links for excel users: 1

Re: $$Excel-Macros$$ Re: Concatenation based on criteria in other columns?

for this is so that I can refer to that cell using a text box in another sheet. I'm probably taking the wrong approach to accomplish this. Any help or suggestions are greatly appreciated! Thank you, Myke -- Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm

Re: $$Excel-Macros$$ Sum Based on date criteria

on this. -- Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks

Re: $$Excel-Macros$$ Re: help

to concatenate date with week but am not able to do that. so pl assist me. he showing some value after concatenation. am attaching a file. Pl assist me. -- Ganesh Gawde  date function.xls 34KViewDownload -- Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best

Re: $$Excel-Macros$$ help

://groups.google.com/group/excel-macros/subscribe -- Ganesh Gawde -- Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ -- -- Some important

Re: $$Excel-Macros$$ how to looping setting a time limit in excel 2007?

. ShortFadeBar On 20/01/2010, memonkavi memonk...@gmail.com wrote: sir ex code do calculate loop until --- here i want set a time limit pls help me -- Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like

Re: $$Excel-Macros$$ Sum Based on date criteria

hi mahesh. u r welcome On 21/01/2010, mahesh parab mahes...@gmail.com wrote: Hi Praveen,Ankur,Dave thank you all of you ! On 1/20/10, Dave Bonallack davebonall...@hotmail.com wrote: Hi, Have a look at the attached. Let me know if it's what you need. Regards - Dave

Re: $$Excel-Macros$$ Exporting data using Pulldown List

worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best

Re: $$Excel-Macros$$ Help Required - Gantt Chart

! Homepage. http://in.yahoo.com/ -- Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ -- -- Some important links for excel users: 1. Follow us

Re: $$Excel-Macros$$ Exporting data using Pulldown List

HI SANDIP if you need any other clarification , plz let me know 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 Fri, Jan 22, 2010 at 1:24 PM, ankur ankurpande...@gmail.com wrote: HI SANDIP check the revised sheet

Re: $$Excel-Macros$$ If Conditions - Urgent Help Required

hi abhishek check the attached file, i think this is what you needed 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 Fri, Jan 22, 2010 at 2:05 AM, Abhishek Jain abhishek@gmail.com wrote: URGENT Hi friends

Re: $$Excel-Macros$$ Excel can Speak now

hi shivashankar this is vba code, you have to write this code in vb project , 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 Fri, Jan 22, 2010 at 2:01 PM, shivashankar katageri shankarkatag...@gmail.com wrote:  hi

Re: $$Excel-Macros$$ Automatic goal seek...

hi sagaraher y dont you record a macro for that 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 Sat, Jan 23, 2010 at 12:41 PM, sagaraher sagara...@gmail.com wrote: Hi frds. plz anyone tell me, is ther ny way to us

Re: $$Excel-Macros$$ Exporting data using Pulldown List

u r welcome sandip 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 Sun, Jan 24, 2010 at 12:49 AM, San Pat myitems2...@gmail.com wrote: Hi Ankur, This is what I wanted.Thanks for your help! Is it possible that I

Re: $$Excel-Macros$$ Re: compare partial text in a cell and compare the information for a new cell

Ayush, very good use of formula 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, Jan 25, 2010 at 8:54 AM, ayush jain jainayus...@gmail.com wrote: Hi Steve, Attached is the solution. Column H : the formula

Re: $$Excel-Macros$$ compare partial text in a cell and compare the information for a new cell

notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest

Re: $$Excel-Macros$$ compare partial text in a cell and compare the information for a new cell

ok dilip sir i will wait for your and Steve reply On 25/01/2010, Dilip Pandey dilipan...@gmail.com wrote: Dear Ankur, Index Match is gud approach if there are more than 3 locators (1a, 1b, 1c). I am not sure how Steve has the data setup n what is his further req. are. I think he has only

Re: $$Excel-Macros$$ Grouping and average price calculation

over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone

Re: $$Excel-Macros$$ Grouping and average price calculation

hi Ayush Thanks For Such encouraging words from the moderator, you had made my day I'm still learning from this group.. i used pivot table refresh code in my data, it is working fine thanks Again Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best

Re: $$Excel-Macros$$ Re: compare partial text in a cell and compare the information for a new cell

nice one!! shridhar 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, Jan 25, 2010 at 1:26 PM, Sridhar jack sridhar0...@gmail.com wrote: Hi, Please find the attached Sridhar 9884984988 On 1/25/10, steve d

Re: $$Excel-Macros$$ if then formula - help needed

subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ -- -- Some

Re: $$Excel-Macros$$ Excel Accounting

they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest

Re: $$Excel-Macros$$ How to save data from html to excel.

6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone

Re: $$Excel-Macros$$ compare partial text in a cell and compare the information for a new cell

hi dilip sir thanks for your words On 26/01/2010, Dilip Pandey dilipan...@gmail.com wrote: Thanks Steve, It's good to hear that your requirements are fulfilled. Ankur, I have checked your formulation as well and it is good. Only two things you need to watch here is if the locators i.e, 1a

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

-- Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks

Re: $$Excel-Macros$$ How to assign rank from the list

the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest

Re: $$Excel-Macros$$ Do you know ? Excel’s leap ye ar bug

subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ -- -- Some

Re: $$Excel-Macros$$ Exporting data using Pulldown List

hi Sandip i dont know how will it be done i think it is not possible in this condition keeping your requirements , may be other members can give any idea about this On 26/01/2010, San Pat myitems2...@gmail.com wrote: Hi Ankur, Is it possible that you can covert the current formula

Re: $$Excel-Macros$$ IF statement to test if Excel Clipboard is Empty

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 Wed, Jan 27, 2010 at 10:23 AM, Dave Bonallack davebonall...@hotmail.com wrote: Hi XLCPA, I don't know a quick method of doing this, although there may be one

Re: $$Excel-Macros$$ Removing password in a macro

the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest

Re: $$Excel-Macros$$ The Aspiring Writer ;)

many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like

Re: $$Excel-Macros$$ Using IF Condition

worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm

Re: $$Excel-Macros$$ Removing password in a macro

dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 1/28/10, Robinson Boreh rbo...@gmail.com wrote: Hi, Please find the attached file. Regards -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of ankur Sent

Re: $$Excel-Macros$$ Re: Password crecker for Excel workbbok

Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel

Re: $$Excel-Macros$$ How to save data from html to excel.

hi murtaza its ok...let c the reply of other group member On 28/01/2010, Murtaza Dalal humtumhareh...@gmail.com wrote: Naah Ankur it didnt serve the purpose. I've created an HTML page. is there an HTML code for saving data in excel. On Wed, Jan 27, 2010 at 12:18 PM, ankur ankurpande

Re: $$Excel-Macros$$ IF statement logic

Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com

Re: $$Excel-Macros$$ sound with command button

: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2

Re: $$Excel-Macros$$ Help!!!!!!!!!!!!!

worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm

Re: $$Excel-Macros$$ update sheet row sumif offset

Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http

Re: $$Excel-Macros$$ VBA MACRO HELP NEEDED

://groups.google.com/group/excel-macros/subscribe -- Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ -- -- Some important links for excel

Re: $$Excel-Macros$$ update sheet row sumif offset

hi manoj plz check this attached file, your query has been solved fully, if you have any query , mail me On 30/01/2010, ankur ankurpande...@gmail.com wrote: hi manoj plz check the attached file i try to solve it acc to ur need, but not fully solved, may be it help you a bit thanks On 30

Re: $$Excel-Macros$$ update sheet row sumif offset

hi manoj after sending the file i notice one mistake ,just clear the cell which contains word unique list. and unmerge the cell.. rest will serve your purpose thnks On 30/01/2010, ankur ankurpande...@gmail.com wrote: hi manoj plz check this attached file, your query has been solved fully

Re: $$Excel-Macros$$ Please help me fourmula

://groups.google.com/group/excel-macros/subscribe -- Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ -- -- Some important links for excel

Re: $$Excel-Macros$$ VBA MACRO HELP NEEDED

hello friends, i had send my files to the moderator of group , you will find them shortly in our file section no need to post request here , just mail me on my id ankurpande...@gmail.com On 01/02/2010, asha abraham abrash...@gmail.com wrote: Hi Ankur, could u pls send me the VBA e-books to my

Re: $$Excel-Macros$$ Excel Learning

hi rahul a book in pdf format excel 203 bible or excel 2007 bible will solve ur problems search on google 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 Tue, Feb 16, 2010 at 8:46 AM, Venkatesh Narla nvenki

Re: $$Excel-Macros$$ Gift for you all...........

good one 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, Feb 15, 2010 at 1:53 PM, RAHUL SUREKA rahul.theoneo...@gmail.com wrote: hiii   Please Reply me how to use the excel file

Re: $$Excel-Macros$$ VBA Macros Code examples : ASCII code converter : Column Number to Alphabetic...

thanks sir 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 Thu, Feb 18, 2010 at 6:32 PM, Ayush Jain jainayus...@gmail.com wrote: Ayush Jain has sent you a link to a blog: Dear members, An ASCII converter function

Re: $$Excel-Macros$$ Inventory

there are numerous format of payroll and inventory can plz be more specific to ur requirement 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 Thu, Feb 18, 2010 at 7:18 AM, Azmath Shariff azmath2...@gmail.com wrote

Re: $$Excel-Macros$$ The Best Add-ins.... and that's too freeeee.......

thnks dear 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, Feb 22, 2010 at 11:34 PM, Dilip Pandey dilipan...@gmail.com wrote: Good one...!! -- Thanks Regards, DILIP KUMAR PANDEY   MBA-HR,B.Com(Hons),BCA

$$Excel-Macros$$ Re: pdf converter software code needed (able2extract)

i got the code thnks 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 Tue, Feb 23, 2010 at 4:02 PM, ankur ankurpande...@gmail.com wrote: hi experts, i had one pdf file converter pdf to different type of file like

Re: $$Excel-Macros$$ Excel Daily Tip : Sum/Count/Average only Visible Rows with SUBTOTAL Function

thnks for handy tips 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 Tue, Feb 23, 2010 at 11:07 AM, Ayush Jain jainayus...@gmail.com wrote: Ayush Jain has sent you a link to a blog: Dear Group, An amazing tip to use

Re: $$Excel-Macros$$ Extract numbers from alphanumeric string

hi skanda =1*MID(A1,MATCH(TRUE,ISNUMBER(1*MID(A1,ROW($1:$9),1)),0),COUNT(1*MID(A1,ROW($1:$9),1))) this is array formula use ctrl+shift+enter 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, Feb 22, 2010 at 10:15

Re: $$Excel-Macros$$ Help in Developing an Graphical Presenataion in % Foramt(PIE CHART)

ATTACHE ARRANGED DATA 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, Feb 22, 2010 at 11:56 PM, Dilip Pandey dilipan...@gmail.com wrote: Hi Sudesh, Your data is not arranged properly.  If this is not an ad-hoc

Re: $$Excel-Macros$$ Gift for you all...........

how can we minimize that window? 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 Sat, Feb 20, 2010 at 9:54 AM, ankur ankurpande...@gmail.com wrote: good one Have A Nice Time Enjoy Life Regards: CMA Ankur

Re: $$Excel-Macros$$ VBA Vedio Tutorial

check youtube.com.there are very good examples 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 Wed, Feb 17, 2010 at 6:00 PM, Puttu puttu...@gmail.com wrote: Hi Team, Can you send me any step by step procedure

  1   2   3   >