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

2013-10-16 Thread alisha malhotra
:16 PM, xlstime wrote: > >> PFA some HR dashboards example >> >> ..... >> >> Enjoy >> Team XLS >> >> >> >> On Tue, Oct 15, 2013 at 11:20 PM, alisha malhotra < >> alisha.malhotr...@gmail.com> wrote: >> >>>

$$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 b

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

2011-09-19 Thread alisha malhotra
ound in my 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

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 wrote: > 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 show a revolving > b

$$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
Thanks a lot for ur help. Regards, Alisha On Sun, Jul 24, 2011 at 9:54 PM, Sam Mathai Chacko wrote: > Here > > > On Sun, Jul 24, 2011 at 9:36 PM, alisha malhotra < > alisha.malhotr...@gmail.com> wrote: > >> >> Thanks for adding the date picker. >> >

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

2011-07-24 Thread alisha malhotra
2 PM, GoldenLance 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 > wrote: > > Hi, > > > > I am using

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

2011-07-24 Thread alisha malhotra
7:51 PM, Sam Mathai Chacko wrote: > 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

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

2011-04-18 Thread alisha malhotra
ode in data instead of count of poor or count of avg etc.? I am >> sending you the attachment. >> >> Regards, >> Alisha >> >> >> On Fri, Apr 15, 2011 at 10:27 AM, ashish koul wrote: >> >>> see if it helps >>> >>> On Thu, Apr 14, 2

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 wrote: > Count of Divisions PoorAvg GoodV Good > > Total Grand Total > Total A

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

2011-04-15 Thread alisha malhotra
at 10:27 AM, ashish koul 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 P

$$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. *Pleas

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

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

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

2010-12-15 Thread alisha malhotra
> On Tue, Dec 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 >> Qtr

$$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 :