$$Excel-Macros$$ Highlight annual leave schedule of each staff for easy comparison

2012-10-24 Thread Yahya Muhammad
Hi experts I want to compile the annual leave schedule of each staff in the department in excel. The idea is to have all the schedule in one work sheet, for easy comparison and to know the leave overlapping,if any, at one glance. Currently I am using the attached sheet, which I think, can be

Re: $$Excel-Macros$$ Query for applying the formula

2012-10-24 Thread VBA VABZ
Hi It could not be so. Check whether you have provided correct sheet name in your project sheet also.. Rgds//Vabs On Wed, Oct 24, 2012 at 4:05 PM, Kenil Gala keni...@yahoo.com wrote: Hi all, Pls help me solve my query. I have written my query in the attachment . Thanks Regards. --

Re: $$Excel-Macros$$ Highlight annual leave schedule of each staff for easy comparison

2012-10-24 Thread VBA VABZ
Hi Nice work, you can automate it through conditional formating. Rgds//Vabs On Wed, Oct 24, 2012 at 12:49 PM, Yahya Muhammad yahya...@gmail.com wrote: Hi experts I want to compile the annual leave schedule of each staff in the department in excel. The idea is to have all the schedule in

Re: $$Excel-Macros$$ Highlight annual leave schedule of each staff for easy comparison

2012-10-24 Thread Paul Schreiner
That's a start... but it doesn't have all of the days of the year. (you probably noticed that) Several years ago (10+?) I put together an attendance tracker for my supervisor. There were separate sheets for each individual in the department, then a summary sheet that displayed how many people

$$Excel-Macros$$ Masking Password in input box

2012-10-24 Thread Hilary Lomotey
Hi Exxperts I got this code to protect a worksheet, which was exactly what i was looking for only that entering the password into the input box is unmasked so everyone standing by can see your password. can i get a code to mask the password input?. or better still another code to ask for

Re: $$Excel-Macros$$ Masking Password in input box

2012-10-24 Thread ashish koul
use userform and textbox instead of msgbox and in text box choose * in passwordchar [image: Inline image 1] On Wed, Oct 24, 2012 at 8:44 PM, Hilary Lomotey resp...@gmail.com wrote: Hi Exxperts I got this code to protect a worksheet, which was exactly what i was looking for only that

Re: $$Excel-Macros$$ Masking Password in input box *

2012-10-24 Thread Hilary Lomotey
Thanks Ashish, one question do i paste the same code in the userform? how do i go about it pls On Wed, Oct 24, 2012 at 3:17 PM, ashish koul koul.ash...@gmail.com wrote: [image: Boxbe] https://www.boxbe.com/overview This message is eligible for Automatic Cleanup! (koul.ash...@gmail.com) Add

Re: $$Excel-Macros$$ Masking Password in input box *

2012-10-24 Thread Hilary Lomotey
Hello Again, Pls how to i combine the code below here to the code in this attached workbook (got it on the web) to achieve my desired results. Desired results being being able to password protect a sheet worksheet (just as the code below is doing only that its not masking the password). The

Re: $$Excel-Macros$$ Help need to get multiple values by vlookup

2012-10-24 Thread Paul Schreiner
Are you saying that your VLookup Value occurs in multiple rows in your table? or that you want to return multiple values from the single match? Then.. what do you want to do with the results?   Paul - “Do all the good you can, By all the means you can, In

Re: $$Excel-Macros$$ Excel Graph Problem

2012-10-24 Thread prkhan56
Thanks Rajan, But did you see the sample I sent with my original post. Is this possible with my data file? Regards Rashid On Tuesday, October 23, 2012 7:04:02 PM UTC+4, Rajan_Verma wrote: You will get desired here.. http://www.excelfox.com/forum/f13/excel-dynamic-waterfall-chart-317/** * *

$$Excel-Macros$$ Re: Help need to get multiple values by vlookup

2012-10-24 Thread Rajan_Verma
Hi Download the file from here http://www.excelfox.com/forum/f12/vlookup-return-multiple-values-4/ Thanks Rajan. On Wednesday, 24 October 2012 22:51:01 UTC+5:30, saravanan R wrote: Hi xlts, Please help me, on how to get the all the associated items In the range where it as more than

Re: $$Excel-Macros$$ Help need to get multiple values by vlookup

2012-10-24 Thread David Grugeon
It seems to me that sorting might be a better approach than a vlookup. Regards David Grugeon On 25 October 2012 14:15, Saravanan sarva0...@gmail.com wrote: Hi I need this because need to know which are all the items belongs to one value. By this values I can assign the items need to work.

Re: $$Excel-Macros$$ Help need to get multiple values by vlookup

2012-10-24 Thread अनिल नारायण गवली
Pl Share a sample sheet with us On Thu, Oct 25, 2012 at 9:52 AM, David Grugeon da...@grugeon.com.au wrote: It seems to me that sorting might be a better approach than a vlookup. Regards David Grugeon On 25 October 2012 14:15, Saravanan sarva0...@gmail.com wrote: Hi I need this

Re: $$Excel-Macros$$ Re: Help need to get multiple values by vlookup

2012-10-24 Thread Aamir Shahzad
Dear Rajan, If you have file plz share with us, your required link want to register first. On Thu, Oct 25, 2012 at 8:23 AM, Rajan_Verma rajanverma1...@gmail.comwrote: Hi Download the file from here http://www.excelfox.com/forum/f12/vlookup-return-multiple-values-4/ Thanks Rajan. On