Re: $$Excel-Macros$$ Help needed in creating a Dashbord

2013-10-16 Thread alisha malhotra
. Enjoy Team XLS On Tue, Oct 15, 2013 at 11:20 PM, alisha malhotra alisha.malhotr...@gmail.com wrote: Hi, I am working in HR department in a manufacturing company and want to create a dashboard. Please guide me in preparing the same like the things

$$Excel-Macros$$ Help needed in creating a Dashbord

2013-10-15 Thread alisha malhotra
Hi, I am working in HR department in a manufacturing company and want to create a dashboard. Please guide me in preparing the same like the things to be covered in the dashboard How can I link some list box or combo box to a chart in the dashboard without macro i.e. through formulas if it can

Re: $$Excel-Macros$$ Power point Query

2011-09-19 Thread alisha malhotra
presentation which is already ready I also Want to change the colour If yes please let me know how to do it Thanks once again Shrinivas On Sat, Sep 17, 2011 at 10:34 PM, alisha malhotra alisha.malhotr...@gmail.com wrote: Dear Shrini, I am sending you one attachment. Check out

Re: $$Excel-Macros$$ Power point Query

2011-09-17 Thread alisha malhotra
Dear Shrini, I am sending you one attachment. Check out if it works. Regards, Alisha On Thu, Sep 15, 2011 at 5:43 PM, Shrinivas Shevde shrinivas...@gmail.comwrote: Dear All I know this is not Excel related query but still can any one help me. I want to prepare the presentation and want to

$$Excel-Macros$$ Help in Training room booking system

2011-08-01 Thread alisha malhotra
Hi, I want to create a Training room(or Auditorium etc.) booking system. How should I create it? What features should I add? If anyone have this kind of template then please send me. Waiting for your response. Thanks Regards, Alisha --

Re: $$Excel-Macros$$ Date Time picker on a userform

2011-07-24 Thread alisha malhotra
PM, Sam Mathai Chacko samde...@gmail.comwrote: Try this... Date and Time Picker Control 6.0 (SP6) is what I used On Sun, Jul 24, 2011 at 6:43 PM, alisha malhotra alisha.malhotr...@gmail.com wrote: Hi, I am using one userform, In that I need Date time Picker in excel 2003. But when I

Re: $$Excel-Macros$$ Re: Date Time picker on a userform

2011-07-24 Thread alisha malhotra
, GoldenLance samde...@gmail.com wrote: Use Date and Time Picker Control 6.0 (SP6) from the tool box. That would list the control in the toolbox window. Click on it, and use it on your userform. On Jul 24, 6:13 pm, alisha malhotra alisha.malhotr...@gmail.com wrote: Hi, I am using one

Re: $$Excel-Macros$$ Date Time picker on a userform

2011-07-24 Thread alisha malhotra
Thanks a lot for ur help. Regards, Alisha On Sun, Jul 24, 2011 at 9:54 PM, Sam Mathai Chacko samde...@gmail.comwrote: Here On Sun, Jul 24, 2011 at 9:36 PM, alisha malhotra alisha.malhotr...@gmail.com wrote: Thanks for adding the date picker. But I need the time picker also if you can

Re: $$Excel-Macros$$ Problem in pivot table

2011-04-18 Thread alisha malhotra
:32 PM, alisha malhotra alisha.malhotr...@gmail.com wrote: Hi Ashish, I have made the pivot table using the layout as yours layout. But my pivot is little bit complicated.Why is that so happening?. Why did you use employee code in data instead of count of poor or count of avg etc.? I am

Re: $$Excel-Macros$$ Problem in pivot table

2011-04-15 Thread alisha malhotra
at 10:27 AM, ashish koul koul.ash...@gmail.com wrote: see if it helps On Thu, Apr 14, 2011 at 9:29 PM, alisha malhotra alisha.malhotr...@gmail.com wrote: Hi, I want to create one pivot table. In this, *I want to calculate the number of employees in Poor, Avg, good, and very good

Re: $$Excel-Macros$$ Re: Problem in pivot table

2011-04-15 Thread alisha malhotra
Hi Saggi, Please send one attachment. Please tell me How to use formula in pivot table in excel 2003? Regards, Alisha On Fri, Apr 15, 2011 at 9:43 AM, saggi realsa...@gmail.com wrote: Count of Divisions PoorAvg GoodV Good Total Grand Total

$$Excel-Macros$$ Problem in pivot table

2011-04-14 Thread alisha malhotra
Hi, I want to create one pivot table. In this, *I want to calculate the number of employees in Poor, Avg, good, and very good.* But it is showing the same no. of employees in each category that is wrong. I am sending you the file as attachment. Please help me in creating the pivot table.

Re: $$Excel-Macros$$ cumulative sum in pivot table

2010-12-19 Thread alisha malhotra
, Find attached file saved in excel 2003. Regards Kantilal -- Forwarded message -- From: alisha malhotra alisha.malhotr...@gmail.com Date: Wed, Dec 15, 2010 at 6:44 PM Subject: Re: $$Excel-Macros$$ cumulative sum in pivot table To: excel-macros@googlegroups.com Hi

Re: $$Excel-Macros$$ cumulative sum in pivot table

2010-12-15 Thread alisha malhotra
7, 2010 at 4:06 PM, alisha malhotra alisha.malhotr...@gmail.com wrote: Hi Group, I have one pivot table. In that I want to show the cumulative sum. e.g. Qtr1 sale:- 10 units Qtr2 sale:- 20 units Qtr3 sale:- 10 units Qtr4 sale:- 30 units now i want to show the sale of qtr1 and qtr2 i.e

$$Excel-Macros$$ cumulative sum in pivot table

2010-12-07 Thread alisha malhotra
. 40 units and so on. How can I do this? Can anyone help me please? Thanks Regards, Alisha malhotra -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http