Re: $$Excel-Macros$$ Re: Ashish Koul : Most helpful Member

congrats buddy Warm Regards, Harmeet Singh IT Analyst McKinsey Company http://www.facebook.com/Harmeeet On Wed, Mar 2, 2011 at 11:06 PM, DILIPandey dilipan...@gmail.com wrote: Congrats Ashish...!! Best Regards, DILIPandey On Mar 1, 8:38 pm, Ayush jainayus...@gmail.com wrote

Re: $$Excel-Macros$$ Re: Reqd : Add in to convert Numbet to text in Excel 2007

http://code.google.com/p/openexcel/downloads/list http://code.google.com/p/openexcel/downloads/list Warm Regards, Harmeet Singh IT Analyst McKinsey Company http://www.facebook.com/Harmeeet On Tue, Dec 7, 2010 at 9:27 PM, OpenExcel.com ashishj...@openexcel.comwrote: Hi Radhe, It seems you

Re: $$Excel-Macros$$ Own Formule in Pivot Table

Hi Dave, Thanks for the correction and sorry for being so dumb :D. Warm Regards, Harmeet Singh IT Analyst McKinsey Company http://www.facebook.com/Harmeeet On Fri, Dec 3, 2010 at 1:16 PM, Dave Bonallack davebonall...@hotmail.comwrote: Hi, Harmet, your formula is using relative values

Re: $$Excel-Macros$$ Own Formule in Pivot Table

here you go Warm Regards, Harmeet Singh IT Analyst McKinsey Company http://www.facebook.com/Harmeeet On Thu, Dec 2, 2010 at 11:43 PM, Ramkesh Maurya sunscel...@gmail.comwrote: Hi All, Please tell me how i can insert my own formule in Excel. e.g 2 is 5.71% of 35 the Grand Total, in next

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

U deserve this bro.keep rocking Warm Regards, Harmeet Singh IT Analyst McKinsey Company http://www.facebook.com/Harmeeet On Mon, Oct 4, 2010 at 7:04 AM, hanumant shinde hanumant_5...@yahoo.co.inwrote: congrats ayush. this gropu really rocks

Re: $$Excel-Macros$$ Unique id to name

This should help. Warm Regards, Harmeet Singh IT Analyst McKinsey Company http://www.facebook.com/Harmeeet On Thu, Aug 19, 2010 at 7:18 PM, None n8dine4ma...@yahoo.com wrote: Unfortunately a puvot table won't work here as I need the formula on each line in the worksheet. Otherwise your

Re: $$Excel-Macros$$ Thank you Dave Bonallack !!

I Second that Ayush...Dave Rocks.Cheers Warm Regards, Harmeet Singh IT Analyst McKinsey Company http://www.facebook.com/Harmeeet On Sat, Jul 31, 2010 at 2:29 PM, Ayush jainayus...@gmail.com wrote: Dear Group, In the recent group survey conducted, I asked one question

Re: $$Excel-Macros$$ How to ADD product of two columns in a single cell

Hi There, See attached file. Warm Regards, Harmeet Singh IT Analyst McKinsey Company http://www.facebook.com/Harmeeet On Thu, Jul 22, 2010 at 11:42 AM, Rave Patwal ravepat...@gmail.com wrote: Please help to add the product of two columns e.g. Column1Column2 23 119

$$Excel-Macros$$ Extract Nth word from string

I hope this would be helpful for sum1..See attached file. Warm Regards, Harmeet Singh IT Analyst McKinsey Company http://www.facebook.com/Harmeeet -- -- Some important links for excel users: 1. Follow us

Re: $$Excel-Macros$$ Interview questions

this would help http://www.coolinterview.com/type.asp?iType=220 http://www.coolinterview.com/type.asp?iType=220 Warm Regards, Harmeet Singh IT Analyst McKinsey Company http://www.facebook.com/Harmeeet On Fri, Jul 9, 2010 at 5:09 PM, Soni.Rajender soni.rajen...@gmail.comwrote: Hi

Re: $$Excel-Macros$$ IN THE SENTENCE REQUIRE ONE CELL VALUE

this should help. see attached file Warm Regards, Harmeet Singh On Tue, Jun 15, 2010 at 6:43 PM, big smile bigsmile...@gmail.com wrote: Hellow Friends Can it possible that in cell lets ex. in B1 I write - The gross total is Rs. ---[ Cell value of A1 ]. In between any

Re: $$Excel-Macros$$ Excel Sheet Renameing Macro Reqired

*Here you go* *use mentioned code* * * *Sub ren()* * * *mo = InputBox(Enter Month number.)* * * *For i = 1 To Application.Worksheets.Count* * * *Sheets(i).Name = Left(Sheets(i).Name, 3) mo Right(Sheets(i).Name, 3)* *Next i* * * *End Sub* Warm Regards, Harmeet Singh http

Re: $$Excel-Macros$$ Post VBA Jobs for Our Group Members

There is one vacant position for Tech Lead at McKinsey Gurgaon. Interested people can apply. Thanks Regards, Harmeet Singh Sent via BlackBerry Wireless On Fri, May 21, 2010 at 7:08 PM, naniram 06n...@gmail.com wrote: Yes Shyam, this is a great helpful for those who are looking Job on VBA

Re: $$Excel-Macros$$ Need formula to get the desired cell content.

Below Code may help u Do ActiveCell.Offset(1, 0).Select Loop Until Rows(ActiveCell.Row).Hidden = False Thanks Regards, Harmeet Singh Sent via BlackBerry Wireless On Fri, May 21, 2010 at 6:46 PM, Vinu vinu1sm...@gmail.com wrote: Hello, I have 2 sheets. In one sheet I have a dump

Re: $$Excel-Macros$$ Permutations and combinations

For that use FACT formula... =fact(5) Thanks Regards, Harmeet Singh Sent via BlackBerry Wireless On Thu, Apr 15, 2010 at 4:55 PM, Dilip Pandey dilipan...@gmail.com wrote: Dear Michael, So do you want only two numbers to sum up - at a time 1+19 or you want scenarios like below

Re: $$Excel-Macros$$ Plz Help me urgent

Good one guyz nice to see such creative formulas, here is my share of knowledge. Kindly check out the index match function without adding additional column. Thanks Regards, Harmeet Singh Sent via BlackBerry Wireless On Tue, Apr 6, 2010 at 4:59 PM, Born to Win cs4...@gmail.com wrote

Re: $$Excel-Macros$$ 12 secret shortcuts of Excel

Regards, Harmeet Singh Sent via BlackBerry Wireless On Fri, Apr 2, 2010 at 8:56 PM, ayush jain jainayus...@gmail.com wrote: Dear Members, Thanks for all your contribution to the group. The group has successfully completed three years. On this occasion, I would like to launch an eBook on excel

Re: $$Excel-Macros$$ Need urgent Help.

Hi, PFA file for solution Thanks Regards, Harmeet Singh Sent via BlackBerry Wireless On Fri, Apr 2, 2010 at 3:45 PM, Baby Patel smritipatel2...@gmail.comwrote: Hi All, Can anyone help me providing the quick guide on excel formulas. I know muchbut want to prepre for an interview

Re: $$Excel-Macros$$ Please help In seperating alphabets and numbers from a cell

Thanks Dave Its my pleasure to get appreciation from a legend (DAVE) :) God bless u Thanks Regards, Harmeet Singh Sent via BlackBerry Wireless On Wed, Mar 31, 2010 at 7:52 AM, Dave Bonallack davebonall...@hotmail.comwrote: Hi Harmet, MUCH shorter than mine! Very good. Does need

Re: $$Excel-Macros$$ Please help In seperating alphabets and numbers from a cell

*found one more method.* *PFA file* Thanks Regards, Harmeet Singh Sent via BlackBerry Wireless On Wed, Mar 31, 2010 at 5:29 AM, Dave Bonallack davebonall...@hotmail.comwrote: Hi, I've thought about it some more and have come up with a rediculously long formula that does the job

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

*Thank you guyz.* * * *I am **overwhelmed with your response* * * Thanks Regards, Harmeet Singh Sent via BlackBerry Wireless On Sat, Feb 13, 2010 at 10:00 PM, Dhananjay Pinjan dppin...@gmail.comwrote: Thank you very much!!1 On 2/11/10, Harmeet

Re: $$Excel-Macros$$ how to use fillcolor for an condition

Attached file would help... Thanks Regards, Harmeet Singh Sent via BlackBerry Wireless On Fri, Jan 15, 2010 at 3:06 PM, Ashok Renga ashokrenga2...@gmail.comwrote: when a100 ,i need fill the box with green color similarly when a100,i need to fill the box with red colour can

Re: $$Excel-Macros$$ Help with pivot table

*Hope this helps* [image: ?ui=2view=attth=126281972feb624dattid=0.1disp=attdrealattid=ii_126281972feb624dzw] Thanks Regards, Harmeet Singh Sent via BlackBerry Wireless On Wed, Jan 13, 2010 at 5:40 PM, Sir Digby Chicken Ceasar petercros...@googlemail.com wrote: Hi Sorry for off topic

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

thanx ayush, wish u and the group member the same.. *Excel group rock * Thanks Regards, Harmeet Singh Sent via BlackBerry Wireless On Thu, Dec 31, 2009 at 4:47 PM, Ayush jainayus...@gmail.com wrote: Dear Group members, Wish you all a very very Happy New Year. May our

Re: $$Excel-Macros$$ Locking/Freezing a range of cells

Hi Vinod, Attaching a sample file. If this is what u want, u might wanna read my previous reply again else team would surely help u. Thanks Regards, Harmeet Singh Sent via BlackBerry Wireless On Wed, Dec 23, 2009 at 2:53 AM, Vinod N nvino...@gmail.com wrote: Hi Harmeet and Praveen

Re: $$Excel-Macros$$ GetUnique_Collection - to capture numeric values

*Nice solution Dave.. :)* * * *Vinod,* *I hope that would help you. * Thanks Regards, Harmeet Singh Sent via BlackBerry Wireless On Wed, Dec 23, 2009 at 12:40 PM, Dave Bonallack davebonall...@hotmail.comwrote: Hi Vinod, The attached shows how to create an instantly

Re: $$Excel-Macros$$ Locking/Freezing a range of cells

. 5. goto tool protection protect sheet then uncheck SELECT LOCKED CELLS. pppf.i m being so patient today..lol let me know if it works for u..HAND Thanks Regards, Harmeet Singh Sent via BlackBerry Wireless On Sun, Dec 20, 2009 at 9:00 PM, Vinod N

Fwd: $$Excel-Macros$$ Running Mecro automatically

Thanks Regards, Harmeet Singh Sent via BlackBerry Wireless -- Forwarded message -- From: Harmeet Singh harmeet.hew...@gmail.com Date: Mon, Oct 12, 2009 at 7:28 PM Subject: Re: $$Excel-Macros$$ Running Mecro automatically To: Manish Pansari pansari.man...@gmail.com Here u go

$$Excel-Macros$$ Re: Plz Help

*Tried to solve the issue in one column, i hope this helps :)**see attached file* * * Thanks Regards, Harmeet Singh Sent via BlackBerry Wireless On Sun, Oct 11, 2009 at 9:30 AM, Prashant Bhawar prashant.aca...@gmail.comwrote: Plz help here i attached a problem file

$$Excel-Macros$$ Re: Converting Date to uppercase

*Enter date in cell A1 then **Use formula- =UPPER(TEXT(A1,dd-mmm-))**I hope this will solve the issue.* Thanks Regards, Harmeet Singh Sent via BlackBerry Wireless On Sun, Oct 11, 2009 at 7:37 AM, Praveen Khunte praveen.khu...@gmail.comwrote: I have a requirement where

$$Excel-Macros$$ Re: PUZZLE Use functions only

*Had to create an UDF...see attached file.not sure if it can be done using formula in one cell.* Thanks Regards, Harmeet Singh Sent via BlackBerry Wireless On Sat, Oct 3, 2009 at 10:41 PM, Sandeep sandymau...@gmail.com wrote: Reverse a text or number or mixed value entered in a cell

$$Excel-Macros$$ Re: Converting data into date

Hope below code helps: *Cells(1, 1).Value = Format(23-Mar-2009, /mm/dd)* * * * *Thanks Regards, Harmeet Singh Sent via BlackBerry Wireless On Mon, Sep 28, 2009 at 10:39 PM, Duncan - UK duncan...@googlemail.comwrote: Hi there, Fairly new to VBA. I am trying to convert a column

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

*attached file would help u** *Thanks Regards, Harmeet Singh Sent via BlackBerry Wireless On Mon, Sep 28, 2009 at 5:29 PM, Jack j...@jackcwood.co.uk wrote: How can I create an import from ms access to excel where a user does not have access application ?? spent ages trying to work

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

Please check on ur system after uninstalling ms access. I would have checked, but using MSaccess for some urgent deliverable. :) Thanks Regards, Harmeet Singh Sent via BlackBerry Wireless On Mon, Sep 28, 2009 at 7:26 PM, Jack j...@jackcwood.co.uk wrote: Thanks Harmeet But will the end

$$Excel-Macros$$ Re: how to change decimal ccoordinates into DDMMSS fromat

*See attached file* Thanks Regards, Harmeet Singh Sent via BlackBerry Wireless On Fri, Sep 25, 2009 at 4:32 PM, Mahesh mahender.bi...@gmail.com wrote: Dear friends, Need your help. i want to convert decimal coordinates into DDMMSS. 9.73877= 09 44 20 -- With Love

$$Excel-Macros$$ Re: Need to color the duplicates

Hi Sonia, If you open the VBE window, u will see a for each loop, that is changing the cell color for all the selected cells. Let me know if more clarification is required. :) Thanks Regards, Harmeet Singh Sent via BlackBerry Wireless On Wed, Sep 23, 2009 at 1:34 PM, Sonia Singla sonia

$$Excel-Macros$$ Re: forgot password

can u send that file.. i will try to recover passowrd.. Thanks Regards, Harmeet Singh Sent via BlackBerry Wireless On Wed, Sep 23, 2009 at 8:27 PM, manish manish_karandi...@yahoo.com wrote: ive forgot password to the new project macro i have created in VB excel. how to recover

$$Excel-Macros$$ Re: Need to color the duplicates

*See attached file and let me if it helps..* Thanks Regards, Harmeet Singh Sent via BlackBerry Wireless On Mon, Sep 21, 2009 at 6:40 PM, Sonia Singla sonia...@gmail.com wrote: Hi I have the data in an array say in nXm. I want to make a macro color the cells with the same color

$$Excel-Macros$$ Re: Need to color the duplicates

*opps gave u wrong file* *please check attached file (updated)* Thanks Regards, Harmeet Singh Sent via BlackBerry Wireless On Mon, Sep 21, 2009 at 6:56 PM, Harmeet Singh harmeet.hew...@gmail.comwrote: *See attached file and let me if it helps..* Thanks Regards, Harmeet

$$Excel-Macros$$ Re: Vlookup and If formula

Open below page from ur new id and join the group: http://groups.google.com.sg/group/excel-macros http://groups.google.com.sg/group/excel-macros Thanks Regards, Harmeet Singh Sent via BlackBerry Wireless On Thu, Sep 17, 2009 at 4:25 PM, VELMURUGAN velmurugan.vellpand...@tessolve.com wrote

$$Excel-Macros$$ Re: Vlookup and If formula

Thanks Jiju, no need of cake, ur one line of gratitude is more than enough to make my day. But one suggestion from me, always go for the toughest solutions as* Smooth roads never make good drivers.* * * Happy learning... * *Thanks Regards, Harmeet Singh Sent via BlackBerry Wireless

$$Excel-Macros$$ Re: AUTO UPDATE

Please provide a sample file with example... Thanks Regards, Harmeet Singh Sent via BlackBerry Wireless On Wed, Sep 16, 2009 at 3:27 PM, Shimmy morur...@gmail.com wrote: Hi, I have data in sheet1 showing Name, gender, Place of residence and period of employment as respective columns

$$Excel-Macros$$ Re: Help Needed for Debit Credit entries

*please provide a sample file* Thanks Regards, Harmeet Singh Sent via BlackBerry Wireless On Wed, Sep 16, 2009 at 7:44 PM, Deep pradeep170...@gmail.com wrote: Dear Freinds, I am attaching one file which contains debit credit amounts in same column. But previous

$$Excel-Macros$$ Re: Count of Colored Cells

*See attached file**found very nice function in vba...* *hope this helps* Thanks Regards, Harmeet Singh Sent via BlackBerry Wireless On Tue, Sep 15, 2009 at 1:55 PM, Dave Bonallack davebonall...@hotmail.comwrote: Hi Pooja Not possible in 2003 usinf formulas. Have to use VBA

$$Excel-Macros$$ Re: CODING

*See below attached pic.**mentioned few steps, that would help u. * [image: 1.png] Harmeet Singh Sent via BlackBerry Wireless On Mon, Sep 14, 2009 at 1:15 PM, Shimmy morur...@gmail.com wrote: Hi I am a new user of excel and have this problem: I have created a database in excel

$$Excel-Macros$$ Re: Userform for 10 secs

Below code may help u *Sub um()* *If Application.Wait(Now + TimeValue(0:00:10)) Then* *MsgBox Time expired ' or write Unload Me here* *End If* *End Sub* Thanks Regards, Harmeet Singh Sent via BlackBerry Wireless On Fri, Sep 11, 2009 at 10:23 AM, suresh k brave.sur...@gmail.com

$$Excel-Macros$$ Re: Need to sort spreadsheet based on values in Column A

Its fine.just have a chill pill...LOLz Thanks Regards, Harmeet Singh Sent via BlackBerry Wireless On Thu, Sep 10, 2009 at 11:00 PM, rad...@progressivetel.com rad...@progressivetel.com wrote: My most humble of apologies... this is correct... I confused myself... many

$$Excel-Macros$$ Re: Need to sort spreadsheet based on values in Column A

of rows). Thanks in advance! mail2web.com - Microsoft® Exchange solutions from a leading provider - http://link.mail2web.com/Business/Exchange -- Thanks Regards, Harmeet Singh Sent via BlackBerry Wireless

$$Excel-Macros$$ Re: Puzzle #1 - Generate the Sample Pattern (VBA)

-- -- Thanks Regards, Harmeet Singh Sent via BlackBerry Wireless --~--~-~--~~~---~--~~ -- Some important links for excel users: 1

$$Excel-Macros$$ Re: Query

') in Blank Cells scattered in a table? - Ankur Satija, Consultant -- Thanks Regards, Harmeet Singh Sent via BlackBerry Wireless --~--~-~--~~~---~--~~ -- Some important

$$Excel-Macros$$ Re: Filter problem

for values above 3260 and the rows all rows after 3260 can be views.( see Book master 3. worksheet in filter problem file) My problem How I can see the values after 3264 in book master 2 worksheet ? Thanks for your time . Waiting for your reply. Prashant. -- Thanks Regards, Harmeet Singh

$$Excel-Macros$$ Re: hi thanks for the help

Regards, Harmeet Singh Sent via BlackBerry Wireless --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads

$$Excel-Macros$$ Re: hi thanks for the help

*Sorry, attached wrong file**try the attached file.* On Mon, Sep 7, 2009 at 2:27 PM, Harmeet Singh harmeet.hew...@gmail.comwrote: Just added some lines to Daniel's code. See attached file... On Mon, Sep 7, 2009 at 11:34 AM, ashish koul koul.ash...@gmail.comwrote

$$Excel-Macros$$ Re: help plz

result should be koul.ash...@gmail.com thanks ashish -- Thanks Regards, Harmeet Singh Sent via BlackBerry Wireless --~--~-~--~~~---~--~~ -- Some important links

$$Excel-Macros$$ Re: Puzzle #1 - Generate the Sample Pattern (VBA)

-- On Sep 6, 12:55 pm, Harmeet Singh harmeet.hew...@gmail.com wrote: *Hey **Ashish**,**Thanks a lot for this interesting puzzle.* *Looking forward for more innovative puzzles.* * * *Solution is attachedLet me know if I

$$Excel-Macros$$ Re: How to create new file with name and content from excel

.txt (containing productdescription1) productname2.txt (containing productdescription2) in specified folder products for example. Etc.. Thanks. -- Thanks Regards, Harmeet Singh Sent via BlackBerry Wireless

$$Excel-Macros$$ Re: How to create new file with name and content from excel

.txt (containing productdescription1) productname2.txt (containing productdescription2) in specified folder products for example. Etc.. Thanks. -- Thanks Regards, Harmeet Singh Sent via BlackBerry Wireless

$$Excel-Macros$$ Re: excel macros -non numeric value

! -- Thanks Regards, Harmeet Singh Sent via BlackBerry Wireless --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins

$$Excel-Macros$$ Re: compare two list

as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. -- Thanks Regards, Harmeet Singh Sent via BlackBerry Wireless

$$Excel-Macros$$ Re: compare two list

to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. -- Thanks Regards, Harmeet Singh Sent via BlackBerry Wireless

$$Excel-Macros$$ Re: IF condition formula

7.92 7/2/2009 9.02 7/3/2009 9.05 Answer should be 26.91. Excluding the value less than 8.00 hrs and it should calculate only for one day(7/2/2009). I have tried if condition, and not able to give both the conditions. -- Thanks Regards, Harmeet Singh Sent via BlackBerry Wireless

$$Excel-Macros$$ Re: Urgent:: Need code to run batch script thru Excel

try below code: Sub Runbf() Dim obf obf = Shell(D:\Documents and Settings\Harmeet Singh\Desktop\IP_Address.bat, 1) End Sub On Mon, Aug 24, 2009 at 4:52 PM, bharghav r bhargha...@gmail.com wrote: Hi all, I am in need of a macro which will run a batch script. Is there any alternative

$$Excel-Macros$$ Re: Add multiple comments

and safer Internet Explorer 8http://in.rd.yahoo.com/tagline_ie8_1/*http://downloads.yahoo.com/in/internetexplorer/ . -- Thanks Regards, Harmeet Singh Sent via BlackBerry Wireless

$$Excel-Macros$$ Re: One paste for many cells

, Harmeet Singh Sent via BlackBerry Wireless --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http

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

C7. Required: the whole row 7 should be highligted. Thanks and regards, Sheyn -- Thanks Regards, Harmeet Singh Sent via BlackBerry Wireless --~--~-~--~~~---~--~~ -- Some

$$Excel-Macros$$ Re: Overflow error in Excel 2007 VBA

= 100 e = a + b + c + d End Sub -- Thanks Regards, Harmeet Singh Sent via BlackBerry Wireless --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA

$$Excel-Macros$$ Re: To Unprotect Sheet

...@yahoo.com wrote: Hi Harmeet, It shows that password remover is expired Shiv Pratap -- *From:* Harmeet Singh harmeet.hew...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Tuesday, July 28, 2009 7:47:09 PM *Subject:* $$Excel-Macros$$ Re: To Unprotect

$$Excel-Macros$$ Re: Password recovery

to recover password plss thanx in advance -- Thanks Regards, Harmeet Singh Sent via BlackBerry Wireless --~--~-~--~~~---~--~~ - Some important links

$$Excel-Macros$$ Re: BEST EXCEL TIPWEEK # 26Submit your TIP here only

saver! Who is next -- Thanks Regards, Harmeet Singh Sent via BlackBerry Wireless --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel

$$Excel-Macros$$ Re: BEST EXCEL TIPWEEK # 26Submit your TIP here only

to value. Then press Ctrl+Z to revert the change (If required) Benefit - For long formulae user can verify the result for subformula of main formula. For explanation see attached screenshot. On Tue, Jun 23, 2009 at 10:43 PM, Harmeet Singh harmeet.hew...@gmail.comwrote: HI, Name - Harmeet

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

with commas so I recieve: abc...@hotmail.com,def...@yahoo.com,ghi...@gmail.com ETC I am a rookie with hardcore excel functions, so thanks in advance for your patience. Thanks, Adam -- Thanks Regards, Harmeet Singh Sent via BlackBerry Wireless

$$Excel-Macros$$ Re: Best Excel Tip Award of Week # 24 goes to HARMEET SINGH

am happy to inform you that the award of best excel Tip of Week # 24 goes to Harmeet Singh. The tip submitted by Harmeet is as follows : Subject : Hidden text in Formula Tip : =2018+1056-4*120+N(My Salary + Bonus - 4 weekly loan repayments) BY using *N() *formula You can enter hidden text

$$Excel-Macros$$ Re: Best Excel Tip Award of Week # 24 goes to HARMEET SINGH

. Regards - Dave. Date: Wed, 17 Jun 2009 07:48:06 -0700 Subject: $$Excel-Macros$$ Best Excel Tip Award of Week # 24 goes to HARMEET SINGH From: jainayus...@gmail.com To: excel-macros@googlegroups.com CC: harmeet.hew...@gmail.com Hello Everyone, I am happy to inform you

$$Excel-Macros$$ Re: BEST EXCEL TIP WEEK # 24 Submit TIP and Win PRIZE

. Invite your friends too for participation in the contest. The more participation means more learning. Thanks again, Ayush Jain -- Thanks Regards, Harmeet Singh

$$Excel-Macros$$ Re: BEST EXCEL TIP WEEK # 24 Submit TIP and Win PRIZE

WIN PRIZES. Invite your friends too for participation in the contest. The more participation means more learning. Thanks again, Ayush Jain -- Thanks Regards, Harmeet Singh

$$Excel-Macros$$ Re: BEST EXCEL TIP WEEK # 24 Submit TIP and Win PRIZE

Regards, Harmeet Singh --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http

$$Excel-Macros$$ Re: BEST EXCEL TIP WEEK # 24 Submit TIP and Win PRIZE

, Harmeet Singh --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel

$$Excel-Macros$$ Re: hi

Regards Dhartikumar -- Thanks Regards, Harmeet Singh --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add

$$Excel-Macros$$ Re: VBA code to search for worksheet with matching date

to go to the worksheet for that date. Can someone please show me the easiest code to assign to the button to do this? Thanks. -- Thanks Regards, Harmeet Singh

$$Excel-Macros$$ Fwd: VBA help needed

which has todays date in it. -- Thanks Regards, Harmeet Singh --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add

$$Excel-Macros$$ Re: how to set default userform when open workbook

See attched screenshot. On Sun, May 17, 2009 at 7:49 AM, Dhartikumar Sahu dhartiku...@gmail.comwrote: hi grroup can somebody help me how to set default userform when open file. whithout click. Thanks Dhartikumar -- Thanks Regards, Harmeet Singh

$$Excel-Macros$$ Re: Condtional Formatting - Query

Thanks balla -- Fabio L Lemos email: flnle...@gmail.com -- Thanks Regards, Harmeet Singh --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel

$$Excel-Macros$$ Re: Password

it to fix something and then re-protect it. Any ideas? -- Thanks Regards, Harmeet Singh --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA

$$Excel-Macros$$ Re: Nth Row

workbook. So, dataset A; I need to copy Row 51, 101, 151, 201 etc. Having never needed to use VBA or Macros, I may need quite detailed instructions. Thanks. -- Thanks Regards, Harmeet Singh

$$Excel-Macros$$ Re: Need help

.as per the first sheet…. So I can merge the files ………by using my “Merge.xls” macro waiting for your responses -- Thanks Regards, Harmeet Singh --~--~-~--~~~---~--~~ - Some

$$Excel-Macros$$ Re: anybody knows a bit about SQL?

Jan1 and Feb2? thanks! -- Thanks Regards, Harmeet Singh --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add

$$Excel-Macros$$ Re: filling cells with colours

content contains Y then fill it with Yellow if no Y and any content then fill it with Green thanks...its urgent -- Thanks Regards, Harmeet Singh --~--~-~--~~~---~--~~ - Some

$$Excel-Macros$$ Re: Part Numbers

AEP23 Can this be done in Excel without a macro, API, VBA? I have been reading the help file for hours. Thanks for any help you may give me. Dan Rochester Hills, Michigan -- Thanks Regards, Harmeet Singh

$$Excel-Macros$$ Re: !!URGENT!! Formula Required Please HELP

is attached. Thanks to all in Advance Regards Mayank Patel ITC LTD 9822978041 9422749110 -- Fabio L Lemos email: flnle...@gmail.com -- Thanks Regards, Harmeet Singh

$$Excel-Macros$$ Re: Solver

I think u need to be more specific. Sorry, I couldn't get ur query. On Mon, Apr 27, 2009 at 6:20 PM, H Upadhyay harishcupadh...@gmail.comwrote: Dear All, Need ur help, pls suggest how can i create code for Solver Regards Harishh Upadhyay 9773284902 -- Thanks Regards, Harmeet

$$Excel-Macros$$ Re: Macro to open Sharepoint documents?

a macro that can open documents that are not stored on your desktop, but rather in an information portal site? Any info or suggestions are appreciated Regards -- Thanks Regards, Harmeet Singh

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

and run such 125 utilities from single addin. Open XL is a freeware addin. Download, Install and Use. This is definitely gonna save your lots of hours. Enjoy Excel ! Regards Ashish Jain www.excelitems.com Developer of Open XL -- Thanks Regards, Harmeet Singh

$$Excel-Macros$$ Re: How to create Folder and documents with help of macro

a files as input file through a user form?* ** *pls give me examples.* -- Thanks Regards, Harmeet Singh --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel

$$Excel-Macros$$ Re: Index and Offset Formula Help

, Harmeet Singh --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel

$$Excel-Macros$$ Re: Index and Offset Formula Help

one more solution is attached On Thu, Apr 23, 2009 at 7:22 PM, Harmeet Singh harmeet.hew...@gmail.comwrote: See attached file On Thu, Apr 23, 2009 at 3:38 PM, mathew darryl matt.attitud...@gmail.comwrote: hi i need to find the difference between 8:45:28 PM 10:41:00 PMi want

$$Excel-Macros$$ Re: making rows into colums

1 2 2 Sam 1 3 Steve1 1 -- Thanks Regards, Harmeet Singh

$$Excel-Macros$$ Re: Show the start and end of groups of cells

-A-03 end So for each beginning of the location, I need C to say 'start' and at the end of this group of data, I'd like it to say 'end'. Thanks ofr your help. -- Thanks Regards, Harmeet Singh

$$Excel-Macros$$ Re: Any way to divide the cell for ex. by 1000 in its place

Patel ITC LTD 9822978041 9422749110 -- Thanks Regards, Harmeet Singh --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video

$$Excel-Macros$$ Re: copy paste columns macro

(xlUp).Row ' While loop to go thru each cell in colum 1 of sheet A and copy it to column of sheet B starting from cell (A,52) Do Until i 6000 Worksheets(temp1's name).Cells(i + 51, j).Value = temp.Cells(i, j).Value i = i + 1 Loop -- Thanks Regards, Harmeet

$$Excel-Macros$$ Re: select case error

Cells(30, 2).Value = Order_Amt Cells(31, 1).Text = Optimal starting inventory Cells(31, 2).Value = Desire_Inven Cells(32, 1).Text = Critical value for determining if an order shoould be placed Cells(32, 2).Value = Crit_Value End Select -- Thanks Regards, Harmeet Singh

  1   2   >