$$Excel-Macros$$ Re: URGENT HELP

2009-08-03 Thread Rajesh Janardanan
Guys, I am waiting for an answer , Please respond Best regards rajesh On Mon, Aug 3, 2009 at 8:01 AM, Rajesh Janardanan rajesh...@gmail.comwrote: Dear All, Need an urgent help , please refer the attached file , I need a formula which will read YTD (B13) as the last cell entered , in the

$$Excel-Macros$$ Re: URGENT HELP

2009-08-03 Thread venkatesh srinivas
rajesh can you confirm if the number of rows in just 13 or will it cross more than that... if its just Jan to Dec.. we can fix it with an simple {if condition.. } or else we need to find other ideas.. Regards Venkatesh On 8/3/09, Rajesh Janardanan rajesh...@gmail.com wrote: Dear All,

$$Excel-Macros$$ Re: URGENT HELP

2009-08-03 Thread venkatesh srinivas
sorry guys.. looks like i am too late...to reply sorry ... On 8/3/09, Rajesh Janardanan rajesh...@gmail.com wrote: Guys, I am waiting for an answer , Please respond Best regards rajesh On Mon, Aug 3, 2009 at 8:01 AM, Rajesh Janardanan rajesh...@gmail.comwrote: Dear All, Need an

$$Excel-Macros$$ Re: URGENT HELP

2009-08-03 Thread Rajesh Janardanan
hi Venkatesh, Can u give me a suggestion on the If command u have mentioned? Best regards rajesh On Mon, Aug 3, 2009 at 9:34 AM, Rajesh Janardanan rajesh...@gmail.comwrote: yes Venkatesh, it will be Jan to December only, please advise me withe the if command Best regards rajesh On

$$Excel-Macros$$ Re: help with formula for report

2009-08-03 Thread Swapnil Palande
Hi Harris, I have return function for calculating total finish and active values. Now you can use formula. But formula to work properly, columns sequence should be same as given by you in example excel (i.e. Name, month, amount). You will find this formula in user define functions. I am

$$Excel-Macros$$ Urgent help requird

2009-08-03 Thread shivashankar katageri
Dear All, I have lot work progress quantity in different months of year from 2008-2009,I need to seggregate them into month wise progress of the year or I need in some other different format,so that I can easily idintified month wise, please have luk of attached sheet -- Thanks Regards

$$Excel-Macros$$ Re: Urgent help requird

2009-08-03 Thread Swanand Deshpande
Shivashankar, I suggest you give us a sample format in which you want to see the data so that it is easier then. Regards, Swanand Deshpande Cell: +91- 90110 99165 From: shivashankar katageri Sent: Monday, August 03, 2009 1:44 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$

$$Excel-Macros$$ Re: Need Help

2009-08-03 Thread Dharmesh Shah
king is the password On Thu, Jul 30, 2009 at 11:53 PM, Aamir Shahzad aamir...@gmail.com wrote: Dear Members, Can any body remove the attached file's password which will highly appriciated. Regards, Aamir Shahzad --~--~-~--~~~---~--~~

$$Excel-Macros$$ Re: Urgent help requird

2009-08-03 Thread vivek agrawal
Hi Shivashankar cal u please clarufy in which structure or format do you require the result in Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Mon, Aug 3, 2009 at 1:44 PM, shivashankar katageri shankarkatag...@gmail.com wrote:

$$Excel-Macros$$ Re: URGENT HELP

2009-08-03 Thread Norman May
Rajesh, Try the formula below: =INDEX(B1:B12,MATCH(9.99E+307,B1:B12)) Norman On Mon, Aug 3, 2009 at 1:01 AM, Rajesh Janardanan rajesh...@gmail.comwrote: Dear All, Need an urgent help , please refer the attached file , I need a formula which will read YTD (B13) as the last cell

$$Excel-Macros$$ Formatting Question - Create Word Template from Excel

2009-08-03 Thread Dustin
Dear Group, I currently have an excel spreadsheet that is used as an invoice template. A loop goes through each customer and the invoice reflects their customer specific information. I am looking to move over to a mail-merge solution for this, and I need to convert my excel worksheet to a word

$$Excel-Macros$$ Windows Task Manager Opening old version 2003 excel file

2009-08-03 Thread TAlgo
On Aug 2, 12:41 pm, TAlgo trading.a...@gmail.com wrote: Ayush, Thanks and appreciate your help in this matter. Just was  little frustrating to search and find out that your topic was completely changed by someone. thx again, On Aug 2, 2:02 am, Ayush Jain jain_ayus...@yahoo.com wrote:

$$Excel-Macros$$ Re: Data Validation to only allow 7 digit numbers in a entire column

2009-08-03 Thread Dave Bonallack
Hi Wes, Try formatting your data as text, then use the following data validation: =AND(LEN(A1)=7,ISERROR(VALUE(A1))=FALSE) Regards - Dave. Date: Mon, 3 Aug 2009 18:11:25 -0700 Subject: $$Excel-Macros$$ Data Validation to only allow 7 digit numbers in a entire column From: