RE: $$Excel-Macros$$ Fwd: Copy the formula till end of data without using copy paste every time we add the add to the sheet

I forgot to say that the formula is extended to the last row of data when a Name is entered into Column A, and a number entered into Col B Regards - Dave. Date: Wed, 25 Nov 2009 21:48:40 +0530 Subject: $$Excel-Macros$$ Fwd: Copy the formula till end of data without using copy paste every ti

RE: $$Excel-Macros$$ SUM ON BASIS OF FORAMAT

Hi, Nothing seems to be determining the special format. My guess is that it was either applied manually to each cell, or it was imported from another workbook or application. Whatever the origin, we are stuck with the data as presented. Regards - Dave. > Date: Wed, 25 Nov 2009 19:58:38 -0800

Re: $$Excel-Macros$$ SUM ON BASIS OF FORAMAT

1: What is determining if the cell gets a number format of "dr" or "cr"? (yes, it may be simple to others. I got no clue what those stands for) 2: How is that number format being applied to the cell? it gotta be based on some specific criteria, Right? What i was getting to: let a worksheet funct

Re: $$Excel-Macros$$ Formula Calculation Problem

Hi Niraj, when i looke closely, i found that you have a "Space" after every value.. i deleted the space and the formula worked check attachment Regards, Madhu On Wed, Nov 25, 2009 at 7:05 PM, Niraj Kothari wrote: > Dear , > > I am trying to multiply the values in this attached excel sheet but

Re: $$Excel-Macros$$ Formula Calculation Problem

Dear Mr.Paul, Thanks very much for your instant reply. Regards Niraj *Kothari Diamonds and Jewels * 689, Kunte Chowk, Laxmi Road Pune INDIA - 411030 Website: www.KothariJewelry.com On Wed, Nov 25, 2009 at 9:42 PM, Paul Schreiner wrote: > The problem is that th

$$Excel-Macros$$ Fwd: Copy the formula till end of data without using copy paste every time we add the add to the sheet

-- Forwarded message -- From: Chanti-Hyderabad Date: Wed, Nov 25, 2009 at 9:47 PM Subject: Copy the formula till end of data without using copy paste every time we add the add to the sheet To: MS EXCEL AND VBA MACROS Hi Team, Copy the formula till end of data without using copy

$$Excel-Macros$$ Copy the formula till end of data without using copy paste every time we add the add to the sheet

Hi Team, Copy the formula till end of data without using copy paste every time we add the add to the sheet. Please write to me if you are not able to understand the query.. I am herewith attaching a sample file for your easy reference. Thanks Ramesh --

Re: $$Excel-Macros$$ A Non-Excel Query

Is it windows? If you want to use VBA for that, filecopy() function should help Hemant Hegde 2009/11/25 Peetu > There are free utilities available such as Allways Sync which can > synchronize your data between two locations. > > On Nov 25, 3:52 pm, Aindril De wrote: > > Hi Abhishek, > > > >

$$Excel-Macros$$ Re: Formula Calculation Problem

Dear Niraj Kothari You could probably use the TRIM command to remove trailing spaces. Just type =TRIM(A1 or whatever your cell reference is) into an adjacent cell and then fill down. On Nov 25, 1:35 pm, Niraj Kothari wrote: > Dear , > > I am trying to multiply the values in this attached excel s

Re: $$Excel-Macros$$ Watch Window focus change if breakpoint is active

I have my watch window docked at the bottom and it works as you wish it to. From: Santh To: MS EXCEL AND VBA MACROS Sent: Wed, November 25, 2009 2:57:12 AM Subject: $$Excel-Macros$$ Watch Window focus change if breakpoint is active I Put a break point in VBA

Re: $$Excel-Macros$$ Formula Calculation Problem

The problem is that the character isn't a 'space'. it a member of the extended ASCII character set (160) which, depending on the font, is an undisplayed character. So, the issue is how to replace it. If you KNOW that there is always a special character at the end, you could use the formula: =LEFT

Re: $$Excel-Macros$$ Re: Replace contents in a formula used for whole sheet.

Hi Nikhil If you are using find and replace option, make sure that the word you want to "find" does not contain any part of any of the sheet names. In case it contains (if it is damaging the formulae), change the sheet names before "replacing" the formulae. You can restore the sheet names afterw

$$Excel-Macros$$ Formula Calculation Problem

Dear , I am trying to multiply the values in this attached excel sheet but it is not accepting. It says some formula or text problem. The i individually clicked each cell and deleted a space after each value and again tried multiplying then the formula worked. Is there any direct formula or macro

Re: $$Excel-Macros$$ A Non-Excel Query

There are free utilities available such as Allways Sync which can synchronize your data between two locations. On Nov 25, 3:52 pm, Aindril De wrote: > Hi Abhishek, > > Use the following command: > > XCOPY "E:\My Collection" "D:\My Collection" /E /S > > Let me know if you need any further help. >

Re: $$Excel-Macros$$ Pivot Table Help count

Hi Subhash, i hope this will solve your problem. Rgds, Mahesh Bisht On Wed, Nov 25, 2009 at 11:50 AM, subhash tambe wrote: > Dear all, > > > How to compile to excel pivot table , > ( B Column Count 5 to 15 ) > > A B C D E F G H > 1 > 2 10 > 3 25

Re: $$Excel-Macros$$ A Non-Excel Query

I think, it can be achieved by simply copying E:\My Collection and "Ctrl+A" and "Ctrl+V" on D:\ On Wed, Nov 25, 2009 at 12:19 PM, Abhishek Jain wrote: > Hi Guys, > > I am not sure whether I should ask it here or not because as the subject > suggests, this is a non-excel query. > > What is the s

Re: $$Excel-Macros$$ Re: Replace contents in a formula used for whole sheet.

Dear Nikhil, if it is the same formula u used for 3000 times then copy the complete formula then press CTRL+H paste in 'FIND WHAT' column then go to 'Replace with' column then paste again and change "M" to "A" and press Replace All. it will replace all you want. Try it Regards Vir 2009/11/25 d

RE: $$Excel-Macros$$ A Non-Excel Query

Abhi , Correct me if I am wrong ... I think you delete folder My Collection in Loc.1 & thn copy My Collection folder from Loc.2 ... and paste it in Loc.1. Not sure...if ths will work - Nayan From: Abhishek Jain [mailto:abhishek@gmail.com] Sent: 25 November 2009 12:50 To: MS EXCEL AND VBA MA

$$Excel-Macros$$ Watch Window focus change if breakpoint is active

I Put a break point in VBA macro and stops at that line during execution. After that I add 3 variables to the watch window. The watch window is in undocked state. After executing one line I wanted to delete all the items in watch window. I set focus to Watch Window. To delete items, I either presse

Re: $$Excel-Macros$$ Upgrading to Office 2007

As far as Toolbars go, Mine migrated, but instead of being where YOU want them, they go into a new group called "add-ins". so, in my case, I had (4) separate toolbars in the group. Since the icons are small, they are easy to confuse, so I made it so that when a workbook is activated/deactivated onl

$$Excel-Macros$$ Re: Replace contents in a formula used for whole sheet.

OK... so what did you use to replace it? did you use find/replace a with m ?? If so, it will try to find ALL cases of the letter "a" and replace it with "m". Probably what you're seeing is that you've changed the letter 'a' in a sheet name or workbook name that is used in a formula, and it wants to

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

Thanks :) -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Tue, Nov 24, 2009 at 11:50 PM, Hemant Hegde wrote: > That is cool! Thanks Sir :) > > On 24/11/2009, Dilip Pandey wrote: > >> you are welcome..!!

Re: $$Excel-Macros$$ A Non-Excel Query

Hi Abhishek, Use the following command: XCOPY "E:\My Collection" "D:\My Collection" /E /S Let me know if you need any further help. Regards, Andy On Wed, Nov 25, 2009 at 2:19 PM, Abhishek Jain wrote: > Hi Guys, > > I am not sure whether I should ask it here or not because as the subject > sugg

Re: $$Excel-Macros$$ Calculation Of Expire Date

Hi Nandkumar, You can use the following formula in Cell P5 to calculate the expiry date. =DATE(YEAR(J5),MONTH(J5)+O5,DAY(J5)) And Copy it down Regards, Andy On Wed, Nov 25, 2009 at 1:19 PM, Nandkumar kakvipure < nandkumar.hindust...@gmail.com> wrote: > Hello > How to Calculate Customer Mature