Re: $$Excel-Macros$$ extracting numbers

2016-05-05 Thread Upendra Singh Sengar
Have not seen the workbook but you can modify the formula as below to extract everything after "_POV_" =MID(A1,FIND("_POV_",A1)+5,Len(A1)-FIND("_POV_",A1)+5) Thanks, Upendra Singh +91-9910227325 On Thu, May 5, 2016 at 11:43 AM, Abhishek Jain wrote: > In all but

$$Excel-Macros$$ Need Help in Extracting Daily Numbers from Cumulative file

2015-08-24 Thread Upendra Singh
m not able to figure the way to calculate this. The file contains almost 1 entries. Please let me know the ways by which this can be achieved using VBA. Thanks, Upendra Singh -- 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 Fac

Re: $$Excel-Macros$$ Exel hyperlink

2012-10-27 Thread Upendra Singh
Hi Ajay, After selecting the cells containing hyperlinks, go to vb editor by pressing alt+f11. Then press ctrl+g and type selection.hyperlinks.delete Press Enter and you are done... Sent from my iPhone On 27-Oct-2012, at 8:56 PM, ajay prasad wrote: > DEAR All, > please help me to remove hyper

Re: $$Excel-Macros$$ Introduce Yourself !!

2012-06-10 Thread Upendra Singh
Hi, i am upendra singh, from delhi, works for an online advertising company. I love excel and loves to learn new tweeks and tricks. Sent from my iPhone On 10-Jun-2012, at 1:46 PM, Maries wrote: > Hi all, > > Name : Marieswaran > > Age : 25 > > Current City : Duba

RE: $$Excel-Macros$$ Formula of the week - share your best formula

2011-01-14 Thread Upendra Singh
Hi Noorain, Please use below formula: =VLOOKUP(A7,INDIRECT("'"&TEXT(B7,"dd-mmm")&"'"&"!A:B"),2,0) Regards Upendra Singh From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN A

Re: $$Excel-Macros$$ Re: Query Excel File

2010-12-23 Thread Upendra Singh Sengar
Hi Ayush, This doesn't help. I've got the correct code: "Select Distinct [Market] from [Sheet1$A1:D5000]" or "SELECT DISTINCT [Column Heading] FROM TableName ORDER BY [ColumnHeading];", (¨`·.·´¨) Keep `·.¸(¨`·.·´¨) Smiling !! (¨`·.·´¨)¸.·´ Upendra Singh `·.¸.·´99

$$Excel-Macros$$ Query Excel File

2010-12-22 Thread Upendra Singh Sengar
*** Do somebody have idea how to query excel file if i need distinct value from a particular column. (¨`·.·´¨) Keep `·.¸(¨`·.·´¨) Smiling !! (¨`·.·´¨)¸.·´ Upendra Singh `·.¸.·´9910227325 -- -- Some important links for exc

Re: $$Excel-Macros$$ MACRO's

2010-12-20 Thread Upendra Singh Sengar
Hi Vebhav, Nothing is wrong in below code but if you want to select 3rd row from current row, you should add one line to below code: Row(Z).select. (¨`·.·´¨) Keep `·.¸(¨`·.·´¨) Smiling !! (¨`·.·´¨)¸.·´ Upendra Singh `·.¸.·´9910227325 On 20 December 2010 13:27, vebhav jain wrote: > Hi

$$Excel-Macros$$ welcome to order 2010.11.20.11.10.26

2010-11-19 Thread Upendra Singh Sengar
Hi Im ahmed saber. these days i bought 3 iphone 4G from a website : www.ebay365.org and i get the very great price and quality products from them . i want to introduce it to you . when you went their website and tell them my name ahmed saber . you will get a very great discount . the website is ww

Re: $$Excel-Macros$$ Excel VBA Macros eBook ..Absolutely FREE worth $45

2010-11-09 Thread Upendra Singh Sengar
Hi Sumit, Kindly mail me the PDF u've downloaded. (¨`·.·´¨) Keep `·.¸(¨`·.·´¨) Smiling !! (¨`·.·´¨)¸.·´ Upendra Singh `·.¸.·´9910227325 On 9 November 2010 15:22, sumit kumar wrote: > Hey > > There is no password, I opened it without password. > > > Regards > Sum

Re: $$Excel-Macros$$ Excel VBA Macros eBook ..Absolutely FREE worth $45

2010-11-09 Thread Upendra Singh Sengar
Hi Ayush, What is the password to opent the file. (¨`·.·´¨) Keep `·.¸(¨`·.·´¨) Smiling !! (¨`·.·´¨)¸.·´ Upendra Singh `·.¸.·´9910227325 On 8 November 2010 19:35, Ayush wrote: > Dear Group Members, > > Good news for all of you !! > > Now you can download VBA macros ebook wor

Re: $$Excel-Macros$$ Excel quiz

2010-09-22 Thread Upendra Singh Sengar
power means power function... (¨`·.·´¨) Keep `·.¸(¨`·.·´¨) Smiling !! (¨`·.·´¨)¸.·´ Upendra Singh `·.¸.·´9910227325 On 22 September 2010 18:15, Upendra Singh Sengar < upendrasinghsen...@gmail.com> wrote: > Mathmatically if a raise to power b is c > then > a=C raise to power 1/B

Re: $$Excel-Macros$$ Excel quiz

2010-09-22 Thread Upendra Singh Sengar
Mathmatically if a raise to power b is c then a=C raise to power 1/B b=C raise to power 1/A but power is not working is excel properly... (¨`·.·´¨) Keep `·.¸(¨`·.·´¨) Smiling !! (¨`·.·´¨)¸.·´ Upendra Singh `·.¸.·´9910227325 On 22 September 2010 17:55, Ayush wrote: > > Dear Group, >

$$Excel-Macros$$ Re: Query!!!!

2009-10-20 Thread Upendra Singh
Hi Himadri, You should multiply new client with customer per client. Thanks and Regards, Upendra Singh +91-9910227325 From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Himadri Roy Sent: Monday, October 19, 2009 9:50 PM To: excel-macros

$$Excel-Macros$$ FW: Today's Joke: Love Marriage VS Arranged Marriage - The IT Perspective

2009-10-15 Thread Upendra Singh
u Buy. Arranged Marriage: Product is sold on an as is where is basis. Product once sold will not be taken back! Thanks and Regards, Upendra Singh +91-9910227325 --~--~-~--~~~---~--~~ --

$$Excel-Macros$$ Re: Returning error while in filter mode paste as value.

2009-10-13 Thread Upendra Singh
Hi Aliahk, This error comes when you copy non-contiguous cell and try to paste them on non-contiguous cells. After copying, remove filter and then paste or copy and paste on a different sheet. Let me know if this helps. Thanks and Regards, Upendra Singh +91-9910227325

$$Excel-Macros$$ Re: heyerlinking many cells

2009-10-09 Thread Upendra Singh
This will hyperlink all the cell from A1 to M500 Thanks and Regards, Upendra Singh +91-9910227325 -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of nader Sent: Friday, October 09, 2009 7:54 PM To: MS EXCEL AND VBA MACROS Subjec

$$Excel-Macros$$ Re: Subtract dates

2009-10-09 Thread Upendra Singh
speak of it in polite conversation. Do not confuse the DATEDIF worksheet function with the DateDiff VBA function. Thanks and Regards, Upendra Singh +91-9910227325 From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Paul Schreiner Sent: Friday

Recall: $$Excel-Macros$$ Re: Subtract dates

2009-10-09 Thread Upendra Singh
Upendra Singh would like to recall the message, "$$Excel-Macros$$ Re: Subtract dates". --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutor

$$Excel-Macros$$ Re: Subtract dates

2009-10-09 Thread Upendra Singh
Hi Paul, Nopes. I will not format that cell/column as dd-mm-yy. It should be formatted as number. I never used Datediff and so was unaware that it is VBA only function but now I know. Thanks, Upendra Singh +91-9910227325 From: excel-macros@googlegroups.com [mailto:excel-mac

$$Excel-Macros$$ Re: Looking for most effecient way to convert lots of data

2009-10-08 Thread Upendra Singh
Mail Grand Total 555- 1 1 1 1 4 555- 1 1 1 3 Grand Total 1 2 2 1 1 7 Now replace 1 with Yes.. Let me know if it helps... Thanks and Regards, Upendra Singh +91-9910227325 -Original Message- From: excel-macros

$$Excel-Macros$$ Re: workbook open or not

2009-10-02 Thread Upendra Singh
Wkbk.Name = Filename Then MsgBox (Filename & " is open; changes may result in errors.") End If Next Wkbk End Sub Thanks and Regards, Upendra Singh +91-9910227325 From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of hanuma

$$Excel-Macros$$ Re: Subtract dates

2009-10-02 Thread Upendra Singh
Hi Huzaifa, This is very much possible to subtract dates. Simply subtract as you subtract no.s and format the cell as "yy-mm-dd". This works fine provided you are subtracting dates and not text written as date. Thanks and Regards, Upendra Singh +91-9910227325 -Original Message

$$Excel-Macros$$ Re: inserting page totals

2009-10-02 Thread Upendra Singh
Hi Rohith, Use the subtotal function as below: If you want total for column and your column has 500 rows, write formula in row 510 =subtotal(c1:c500,9). Thanks and Regards, Upendra Singh +91-9910227325 -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac

$$Excel-Macros$$ Re: Need to add sort by column A, G, and J to this macro

2009-10-02 Thread Upendra Singh
Hi c, Before running macro, go to Tools->Sort and sort your data col A-Ascending, Col G-Ascending, Col H-Ascending, Col K - Descending. Let me know if this helps. Thanks and Regards, Upendra Singh +91-9910227325 -Original Message- From: excel-macros@googlegroups.

$$Excel-Macros$$ Re: Doubt

2009-10-01 Thread Upendra Singh
d to your workbook after ActiveSheet. ThisWorkbook.Sheets.Add ,After:=ActiveSheet,count:=15 Thanks and Regards, Upendra Singh +91-9910227325 From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of sumanth kumar Sent: Thursday, October 01, 2009 3:21 PM

$$Excel-Macros$$ Re: Error 91 - Run Time

2009-10-01 Thread Upendra Singh
Hi Kuhrty, You have to set the value of dbs (database) first to continue Let me know if this helps. Thanks and Regards, Upendra Singh +91-9910227325 -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of kuhrty Sent: Thursday

$$Excel-Macros$$ Re: Access To Excel

2009-09-30 Thread Upendra Singh
com/downloads/details.aspx?familyid=d9ae78d9-9dc6-4b38 -9fa6-2c745a175aed&displaylang=en> &displaylang=en Thanks and Regards, Upendra Singh +91-9910227325 -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Jac

$$Excel-Macros$$ Re: Date Format

2009-09-30 Thread Upendra Singh
the format of date equivalent to your existing date format. As for your example, you should select Date->DMY and click finish. See you've done. Change the format of entire selection to dd-mmm- and verify your result. Thanks and Regards, Upendra Singh +91-9910227325

$$Excel-Macros$$ Re: how to change decimal coordinates into DDMMSS format

2009-09-27 Thread Upendra Singh
Below are the formulas to achieve this in excel: Decimal Degree Minute Seconds 9.73877 =INT(A2) =INT((A2-INT(A2))*60) =(((A2-INT(A2))*60)-INT((A2-INT(A2))*60))*60 Thanks and Regards, Upendra Singh +91-9910227325 From: excel-macros@googlegroups.com [mailto:excel-mac.

$$Excel-Macros$$ Re: How to save a DBF file in Excel 2007

2009-09-24 Thread Upendra Singh
Hi Sudhir, You can open DBF files directly in Excel 2007 or you can use save as dialog box to save a file as .dbf. Just use the filetype in the save as dialog box. Thanks and Regards, Upendra Singh +91-9910227325 -Original Message- From: excel-macros@googlegroups.com [mailto:excel

RE: UPENDRA >RE: $$Excel-Macros$$ Re: insert = in every cell with nos & Blank

2009-08-13 Thread Upendra Singh
Copy and paste values in the required column. I just leave it so that you can understand the implementation. Regards, Upendra Singh +91-9910227325, +91-9310760597 - There are

$$Excel-Macros$$ Re: Help Needed

2009-08-12 Thread Upendra Singh
Hi Iqbal, You need password to RAR file or password remover for RAR files…. Regards, Upendra Singh +91-9910227325, +91-9310760597 - There are 10 kinds of people: Those

$$Excel-Macros$$ Re: insert = in every cell with nos & Blank

2009-08-12 Thread Upendra Singh
Hi Manoj, See the attached file... Regards, Upendra Singh +91-9910227325, +91-9310760597 - There are 10 kinds of people: Those who understand binary and those who don&#

$$Excel-Macros$$ Re: NAMED Range

2009-08-11 Thread Upendra Singh
Most one knows..(Joke.) Simply go to Insert->Name->Define. Select the given name and click "delete" ( if you are using excel 2003) OR Go to Formulas->Name Manager. Select the given name and click "delete" (if you are using excel 2007) Regards, Upend

$$Excel-Macros$$ Re: How to convert number into hrs & min.

2009-08-10 Thread Upendra Singh
cell where you have the total time in minutes. Do not forget the last , in the formula. Regards, Upendra Singh +91-9910227325, +91-9310760597 - There are 10 kinds of people

$$Excel-Macros$$ Re: need help vlookup macro or another idea

2009-08-07 Thread Upendra Singh
Hi osiso, You need to nest match function inside your vlookup. Send me the excel file with sample data and I'll show you how Regards, Upendra Singh +91-9910227325, +91-93107

$$Excel-Macros$$ Re: Split data to different Sheet *** URGENT***

2009-08-07 Thread Upendra Singh
Hi Vivek, Send me the macro as text file as my outlook had blocked "Potential unsafe attachment .bas" please. Regards, Upendra Singh +91-9910227325, +91-

$$Excel-Macros$$ Re: Help needed on MS Access user guide.

2009-08-06 Thread Upendra Singh
Hi Vinod, Please download from below Link.. MSPress_Step_By_Step_MS_Office_Access_2003_EBook.pdf <http://rapidshare.com/files/248961528/MSPress_Step_By_Step_MS_Office_Access _2003_EBook.pdf> Regards, Upendra Singh +91-9910227325, +91-9310

$$Excel-Macros$$ Re: Help with formula

2009-07-29 Thread Upendra Singh
Hi Harris, Use the below formula in cell F20. =INDEX($C$6:$O$11,MATCH($D20,$C$6:$C$11,0),MATCH($E20,$C$6:$O$6,0)) Regards, Upendra Singh +91-9910227325, +91-9310760597

$$Excel-Macros$$ Re: Help with formula

2009-07-29 Thread Upendra Singh
Hi Harris, Use the below formula in cell F20. Regards, Upendra Singh +91-9910227325, +91-9310760597 - There are 10 kinds of people: Those who understand binary and those

$$Excel-Macros$$ Re: Excel and Access connectivity

2009-07-29 Thread Upendra Singh
Hi Sunil, You can link your worksheet with MS-Access and then write Queries rather than importing data from Excel to Access. Regards, Upendra Singh +91-9910227325, +91-9310760597

$$Excel-Macros$$ Re: Clearing data from a protected sheet

2009-07-29 Thread Upendra Singh
Hi Martin, You could try selecting only visible cells by pressing F5->Special->Visible Cells Only. Regards, Upendra Singh +91-9910227325, +91-9310760597 - There are 10 ki

$$Excel-Macros$$ Re: Hi Frnd Plz Solve This Pro

2009-07-29 Thread Upendra Singh
Hi Anil, Select entire sheet and then go to format->Columns->Width and enter 8 and press Enter. You will see all columns. Columns are not hidden but their width have made to be 0. Regards, Upendra Singh +91-9910227325, +91-9310

$$Excel-Macros$$ Re: Counting Cells in a Parent/Child relationship

2009-07-25 Thread Upendra Singh
, Upendra Singh +91-9910227325, +91-9310760597 On 7/24/09, Dinsdale wrote: > > I would like to apologize if this has been answered in another thread, > but I could not find it in the searches I was doing. Maybe I was > searching the wrong thing... > > I am a software developer

$$Excel-Macros$$ Re: QUERY ON EXCEL

2009-07-25 Thread Upendra Singh
Use Index-Match =INDEX($A$3:$G$12,MATCH(C$17,$A$3:$A$12,0),MATCH($B18,$A$3:$G$3,1)) Regards, Upendra Singh +91-9910227325, +91-9310760597 - There are 10 kinds of people

$$Excel-Macros$$ Re: Excel Problem - kindly help

2009-07-25 Thread Upendra Singh
Right click on sheet tab and select Ungroup. You've grouped your sheets... Regards, Upendra Singh +91-9910227325, +91-9310760597 - There are 10 kinds of people: Thos

$$Excel-Macros$$ Re: Please provide help on mail merge numerical value

2009-07-22 Thread Upendra Singh
eld. 4. Append \# #,##0. 5. Right Click and Click Update field and You've done. Regards, Upendra Singh +91-9910227325, +91-9310760597 - There are 10 kinds of peo

$$Excel-Macros$$ Re: Pasting as "Link" or "Embedding" from Excel 2007 to Powerpoint 2007

2009-07-22 Thread Upendra Singh
Hi Abhi, Rather than paste special, you can try Insert->object command and insert excel workbook as Object to your Presentation. After inserting, resize object. I hope this will solve your problem. Regards, Upendra Singh +91-9910227325, +91-9310760

$$Excel-Macros$$ Re:

2009-07-22 Thread Upendra Singh
27;S heet1'!$A$1:$N$1,0)). If you have any problem understanding or implementing Index-Match, Send me a sample Sheet and I will explain with example. Both the formulas works if the column heading in both the sheets are same. Regards,

$$Excel-Macros$$ Re: Hii

2009-07-22 Thread Upendra Singh
Hi Ankur, This is what required. And my name is not upender, its Upendra Regards, Upendra Singh +91-9910227325, +91-9310760597 -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of ankurcma Sent: Wednesday, July 22, 2009 4:55 PM

$$Excel-Macros$$ Re: Hii

2009-07-21 Thread Upendra Singh
Hi Ruchi, Enter the below formula in the cell C2 =VLOOKUP(TIME(HOUR(B2),CEILING(MINUTE(B2),15),0),$F$2:$G$99,2,0). Regards, Upendra Singh +91-9910227325, +91-9310760597 From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Ruchi Saxena Sent

$$Excel-Macros$$ Re: vLOOKUP

2009-07-17 Thread Upendra Singh Sengar
.),BCA >>>>> Mobile: +91 9810929744 >>>>> dilipan...@gmail.com >>>>> dilipan...@yahoo.com >>>>> New Delhi - 110062 >>>>> >>>>> On Wed, Jul 15, 2009 at 9:04 AM, Mahesh wrote: >>>>> >>>>

$$Excel-Macros$$ Re: Creating empty rows b/w filed rows without ASAP

2009-07-14 Thread Upendra Singh
ws you need. ActiveCell.Offset(1, 0).Activate Loop End Sub _______ Regards, Upen

$$Excel-Macros$$ Re: Make a Pivot Table using data from 2 different worksheets

2009-07-14 Thread Upendra Singh
Hi Prashant, Go to Data->Pivot Table and Pivot Chart. Then select the third option : Multiple Consolidation Ranges. This will help if your data have exactly Same no and Name of columns. Regards, Upendra Singh +91-9910227325, +91-9310760

$$Excel-Macros$$ Re: urgent Help Required

2009-07-13 Thread Upendra Singh
Hi Sachin, You have entered date which seems as date but actually are strings. You have to write dated in the format mm/dd/yy. So your date should be 03/31/09, not 31-03-09. This will solve your problem Regards, Upendra Singh +91-9910227325, +91-9310760597

$$Excel-Macros$$ Re: Best Excel Tip Award of JUNE goes to *****UPENDRA SINGH*****

2009-07-10 Thread Upendra Singh
Thanks Ayush. Indeed Singh is king I have contributed very less to this group but learned a lot. I will continue searching new tips and share with group. Regards, Upendra Singh +91-9910227325, +91-9310760597

$$Excel-Macros$$ Re: To make the color of the cell white

2009-07-08 Thread Upendra Singh
You can use paste Special-> values in you macro Regards, Upendra Singh +91-9910227325, +91-9310760597 - There are 10 kinds of people: Those who understand binary and those who do

$$Excel-Macros$$ Re:

2009-07-06 Thread Upendra Singh
. The formula will return the number of corresponding cells that are different. If the formula returns 0, it means that the two ranges are identical. Regards, Upendra Singh +91-9910227325, +91-9310760597

$$Excel-Macros$$ Re:

2009-07-06 Thread Upendra Singh
la, so input it with Ctrl-Shift-Enter) is more complex, but it will handle a range that contains a blank cell. =SUM(IF(COUNTIF(A1:D100,A1:D100)=0, "", 1/COUNTIF(A1:D100,A1:D100))) Regards, Upendra Singh +91-9

$$Excel-Macros$$ Re:

2009-07-06 Thread Upendra Singh
the cities from that country. Remember that Defined Names can't include spaces, so, to enter, Great Britain, you would have to put it like "Great_Britain" or "GreatBr

$$Excel-Macros$$ Re: Simple Question - Please tell me about repalcement of (*)

2009-07-06 Thread Upendra Singh
Hi Amresh, Use ~ before * i.e. you have to search ~* Regards, Upendra Singh +91-9910227325, +91-9310760597 - There are 10 kinds of people: Those who understand binary

$$Excel-Macros$$ Re: displaying an empty cell

2009-07-02 Thread Upendra Singh
splayed in you sheet. Regards, Upendra Singh +91-9910227325, +91-9310760597 - There are 10 kinds of people: Those who unders

$$Excel-Macros$$ RE: Need Help for File Searching Macro

2009-07-02 Thread Upendra Singh
Hi All, Any Help. Please .. Regards, Upendra Singh +91-9910227325, +91-9310760597 - There are 10 kinds of people: Those who understand binary and those who don&#

$$Excel-Macros$$ Re:

2009-06-30 Thread Upendra
My Contribution for This Week Tip is Below : Understanding Relative and Absolute References... Excel accepts cell references in what are called absolute and relative ranges. Absolute ranges have a $ character before the column portion of the reference and/or the row portion of the reference. Rel

$$Excel-Macros$$ Re: Best Excel Tip Award of Week # 26 goes to **** UPENDRA SINGH ****

2009-06-30 Thread Upendra Singh
WOOH. Thanks Ayush. Cheers Regards, Upendra Singh +91-9910227325, +91-9310760597 - There are 10 kinds of people: Those who understand binary and those who don&#

$$Excel-Macros$$ Re: Macro for Opening a Particular Sheet .

2009-06-30 Thread Upendra Singh
t3 will be activated. Regards, Upendra Singh +91-9910227325, +91-9310760597 - There are 10 kinds of people: Those who understand binary

$$Excel-Macros$$ Need Help for File Searching Macro

2009-06-29 Thread Upendra Singh
or I'm missing any library. Regards, Upendra Singh +91-9910227325, +91-9310760597 - There are 10 kinds of people: Those who understand binary

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

2009-06-29 Thread Upendra Singh
Hi Lohit, Download below file from Rapishare.com http://rapidshare.com/files/248896187/Wrox_-_Excel_2003_VBA_Programmers_Refe rence.pdf Regards, Upendra Singh +91-9910227325, +91-9310760597

$$Excel-Macros$$ Re: EXCEL E BOOK .

2009-06-27 Thread Upendra Singh
Hi Debashis, Download below file from Rapishare.com http://rapidshare.com/files/248896187/Wrox_-_Excel_2003_VBA_Programmers_Refe rence.pdf Regards, Upendra Singh +91-9910227325, +91-9310760597

$$Excel-Macros$$ Re: Help required to modify vb code

2009-06-27 Thread Upendra Singh
Hi Mahesh, Check this if it works... Regards, Upendra Singh +91-9910227325, +91-9310760597 - There are 10 kinds of people: Those who understand binary and those who

$$Excel-Macros$$ Re: Please send me Ms Access 2007 book

2009-06-26 Thread Upendra Singh
Asad/Surendra, MS-Access Book for your reference. MS_Office_Access_2003_EBook.pdf <http://rapidshare.com/files/248961528/MSPress_Step_By_Step_MS_Office_Access _2003_EBook.pdf> Regards, Upendra Singh +91-9910227325, +91-9310

$$Excel-Macros$$ Re: Inserting Rows

2009-06-26 Thread Upendra Singh
Hi Mahender, If you have ASAP Utilities, You can go to ASAP Utilities->Columns->6.Insert Between Empty Row and Column. ASAP Utilities will ask you for Row or column to insert and no. of Row or Column to Insert. Regards, Upendra Singh +91-9910227325, +91-9310

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

2009-06-26 Thread Upendra Singh
Hi Ankur, I've uploaded one VBA file on Rapidshare.com. Below is the link to download. http://rapidshare.com/files/248896187/Wrox_-_Excel_2003_VBA_Programmers_Refe rence.pdf Regards, Upendra Singh +91-9910227325, +91-93107

$$Excel-Macros$$ Re: Simple Macro Request

2009-06-26 Thread Upendra Singh
Hi Terrance, You can do this without macro. 1. Create copy of Pivot Edit->Move or Copy Sheet. 2. Remove Subtotal and do Pivot Table Copy-> Paste Special-> Values. 3. Apply Advance Filter and Filter the Data. Regards, Upendra Singh +91-9910227325, +91-9

$$Excel-Macros$$ Re: Mail Merge Word Excel 2003

2009-06-25 Thread Upendra Singh
the merge Field. 4. Append \# #,##0.00. 5. Right Click and Click Update field and You've done. Regards, Upendra Singh +91-9910227325, +91-9310760597 - There are

$$Excel-Macros$$ Re: Plz. Help: Convert complex figures into higher or lower 00 Figures

2009-06-24 Thread Upendra Singh
Hi Dharmendra, You can use built in MRound Function in Excel. If Cell A1 have value of 2723, MRound(A1,100) Would give you 2700. Regards, Upendra Singh 9910227325 - There are 10

$$Excel-Macros$$ Re: Concatenate cells and separate values with commas

2009-06-23 Thread Upendra Singh
the copied data in "find what" Box. 5. In the replace box, type a single ",". 6. Press Replace all and copy the whole data back to excel. If you are using Excel 2003, you can do this in 5 Iterations. Regards, Upen

$$Excel-Macros$$ Re: Concatenate cells and separate values with commas

2009-06-22 Thread Upendra Singh
the copied data in "find what" Box. 5. In the replace box, type a single ",". 6. Press Replace all and copy the whole data back to excel. If you are using Excel 2003, you can do this in 5 Iterations. Regards, Upen

$$Excel-Macros$$ Re: Conversion of value in words from figures

2009-06-22 Thread Upendra Singh
Hi Zaki, ASAP utility is absolutely free. You need to purchase license only if you need it for commercial purpose. Regards, Upendra Singh 9910227325 - There are 10

$$Excel-Macros$$ Re:

2009-06-21 Thread Upendra Singh
Name : Upendra Singh Tip : Left Lookup One of the Limitation of both the VLOOKUP and HLOOKUP functions is that you can only lookup a value to the right of the key value. For example, in the range shown Below, you can retrieve the value "c" by using VLOOKUP to search for a 3. Ho

$$Excel-Macros$$ Re: Options

2009-06-20 Thread Upendra Singh
Name: Upendra Singh Tip: color Every Alternate Row in data with conditional Formatting (without Macro) 1. Select the data you want to Format. 2. Go to Conditional Formatting. 3. In the first box, Select “Formula is” and type the formula : =MOD(ROW()-1,1*2)+1>1.

$$Excel-Macros$$ Re: vlookup urgent help

2009-06-20 Thread Upendra Singh
7;ve done. Merged Party Name Bill No. Amount =B2&C2 abc 123 500 =B3&C3 abc 456 590 =B4&C4 bcd 234 434 =B5&C5 bvd 544 3453 Regards,

$$Excel-Macros$$ Re: Options

2009-06-20 Thread Upendra Singh
Hi Vinay, Please find enclosed sample xl Sheet. Please note that in the cell A1, I’ve written my name but that is visible only in formula bar, not in Excel Sheet. I Hope it helps…. Regards, Upendra Singh 9910227325

$$Excel-Macros$$ Re: Options

2009-06-19 Thread Upendra Singh
Hi Friends, Name : Upendra Singh TIP : Hide Data in Cell or Worksheet from praying Eyes ðSelect the range you want to hide. ðGo To Format=>Number=>Custom ðIn the type Box, type three colon (;;;) and press enter. ðThe data where the above formatting is a

$$Excel-Macros$$ Re:

2009-06-05 Thread Upendra Singh
Name : Upendra Singh Subject : Selecting More than one Value in a single Page field for Pivot Table Tip : There are sometime situation where we need to select more than one Value form a given Page field in Excel Pivot Table. In Excel 2003, we can either select “All” or one Value from a

$$Excel-Macros$$ Re: Is there any way to search Google using VBA and Get Search Results in Excel

2009-05-26 Thread Upendra Singh
Hi, This code is not running. Does this requires any reference library to be included except default.. Regards, Upendra Singh 9910227325 From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of ddadmin2009 Sent: Tuesday, May 26, 2009 11:47 AM To

$$Excel-Macros$$ Re: Cell reference

2009-05-10 Thread Upendra Singh Sengar
Thanks > > > >A B C D > ------ > > 10 A 1 =A1 > > > > -- Sent from my mobile device (¨`·.·´¨) Keep `·.¸(¨`·.·´¨) Smiling !! (¨`·.·´¨)¸.·´ Upendra Singh `

$$Excel-Macros$$ Re: Open XL - A Powerful Excel Addin

2009-04-29 Thread Upendra Singh
Hi Satish, I think you have not installed .Net Framework 3.5 and VSTO 3.0 Runtime. I have installed these Pre-requisites and my installation completes. Regards, Upendra Singh 9910227325 From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of

$$Excel-Macros$$ Re: Urgent Help in Access

2009-04-28 Thread Upendra Singh
Hi Prashanth, Write the below query and let me know if it is working: Update Test1 Set Test1.Month = Month.Month Where Test1.Weekno. = Month.Weekno Regards, Upendra Singh 9910227325 From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of

$$Excel-Macros$$ Re: Open XL - A Powerful Excel Addin

2009-04-28 Thread Upendra Singh
setup." Please suggest what to do... Regards, Upendra Singh -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Ashish Jain Sent: Tuesday, April 28, 2009 6:32 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Re: Open X

$$Excel-Macros$$ Re: How to calculate interest

2009-04-26 Thread Upendra Singh
Hi Niraj, Please check the attached file... Regards, Upendra Singh 9910227325 From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of NIRAJ KOTHARI Sent: Saturday, April 25, 2009 12:27 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros

$$Excel-Macros$$ Re: Macro to send email through Excel

2009-04-24 Thread Upendra Singh
or BCC field (" & errcount & " errors detected.)", vbOKOnly) = vbOK End If End Sub ________ __ Regards, Upendra Singh 9910227325 From: excel-macros@googlegroups.com [ma