$$Excel-Macros$$ column chart

2009-08-18 Thread Lynn
i have the following columns - dates - no. of boxes packed - no. of boxes to be packed. how do i do a column chart which compares the no. of boxes packed vs to be packed ? --~--~-~--~~~---~--~~

$$Excel-Macros$$ Need to track minutes

2009-08-18 Thread Sachin Gohil
Dear All, I have to maintain database of alarms received closed, format is date time, and need to keep track of differences in minutes, please help. Thanks. _ Sports, news, fashion and entertainment. Pick it all up in a

$$Excel-Macros$$ Re: Need to track minutes

2009-08-18 Thread Dilip Pandey
Hi Sachin, Attached herewith is the dummy scenario with solution. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Tue, Aug 18, 2009 at 10:53 AM, Sachin Gohil sachin.go...@hotmail.comwrote: Dear

$$Excel-Macros$$ Help reg subtotal print page

2009-08-18 Thread Aligahk06
Dear All, Greetings of th day, I have prepared a workbook based on subtotal. I have total 500 unique w.o # subtotal For each w.o # sub total to be printed on separate page i.e whether one page or two page depending upon the length of the data. Rows to repeat for each page is from Rows 1 to Rows

$$Excel-Macros$$ Re: Need to track minutes

2009-08-18 Thread venkatesh srinivas
hi dilip! Please fine enclosed the solve sheet.' On 8/18/09, Dilip Pandey dilipan...@gmail.com wrote: Hi Sachin, Attached herewith is the dummy scenario with solution. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com

$$Excel-Macros$$ Re: column chart

2009-08-18 Thread venkatesh srinivas
Hi Lynn! Please let me know if the below mentioned file solves our problem On 8/18/09, Lynn moley_c...@yahoo.com.au wrote: i have the following columns - dates - no. of boxes packed - no. of boxes to be packed. how do i do a column chart which compares the no. of boxes packed vs to

$$Excel-Macros$$ Re: column chart

2009-08-18 Thread Lynn
Hi, if you could merge the y axis for both sides and teach me how to do it in excel 2003 will solve my problem. Thanks venkatesh srinivas wrote: Hi Lynn! Please let me know if the below mentioned file solves our problem On 8/18/09, Lynn moley_c...@yahoo.com.au wrote: i have the

$$Excel-Macros$$ Re: $$Excel - Macro$$, Automatically copy and paste the Formulas based on user inputs

2009-08-18 Thread venkatesh
hi Chetan! Can you please send a attachement with an example, which can help us to sort the isssue ASAP. Regards On Aug 18, 2:42 pm, Suhas chet...@gmail.com wrote: Hello Experts, I have a worksheet where the user enters all the data, and the second worksheet gets updated based on the

$$Excel-Macros$$ Re: Help please

2009-08-18 Thread Dilip Pandey
Dear Prashant, Sorrry for the delay, I have tried giving out two solution scenarios in the attached workbook. Thanks -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 8/17/09, prashant pawle

$$Excel-Macros$$ Help please

2009-08-18 Thread Sam K
Hello All I have small query regarding the use slope formula, attached is sheet for reference how the formula used. All I need to know is this correct process to use function or not secondly I need to know exact definition for auditions to let them understand what I try to represents them

$$Excel-Macros$$ Re: Help reg subtotal print page

2009-08-18 Thread gasparovicm
Hello, in Excel 2007 you can define page header rows and page break after subtotal 1. Page header rows Page Layout-Print Titles-Page Setup dialog window tab Sheet, and select rows in field Rows to repeat at top: 2. subtotal page break its the dialog window for subtotals Data-Subtotal and in

$$Excel-Macros$$ Using IF, AND, OR Function in Single formula

2009-08-18 Thread Prasad Gadgil
*Dear All, **Case: *There are four different rate cards (A,B,C,D) now i have to calculate the brokerage depending upon rate type mentioned in previous column. *Resoulation :* I need an formula, which will pickup the rate based on type mentioned in the column. Attaching the same file. Humble

$$Excel-Macros$$ Sharing -loss of data - even though 1 user per sheet

2009-08-18 Thread melissa.brown
Hi Everyone, I have a shared workbook which contains one sheet for each person in our workgroup. Each sheet has a set of checkboxes and a button. As the person works through their tasks using links from the spreadsheet - they tick off the corresponding checkbox. when all checkboxes are ticked