Search results

I use pivot table and set the "value field settings" to "Max".

Thank you bobhc! I'm going to do it tonight.

WOW! Works like a charm! Thank you very much, SirJB7. I only made tiny alteration on the coding to fit the real file. My jaw is on the floor when I see how it works. All the names hi-lighted will have a PDF file independent of one another. This will help not just me but every readers here...

Hello SirJB7, Sorry I didn't reply soon enough. Super busy at work lately. I'm going to give it a try on Monday. I don't have MS2010 on my personal PC, only at work. rest assure i'll do it on monday or tuesday. the employee performance report would be conducted quarterly or annually...

Hi, I have a worksheet with an input sheet and an output sheet. On the output worksheet there is a list box displaying workers' names (e.g 100 names). By clicking on a different name it will display the info of that worker in a report format. Currently, when I hi-light all the names in...

WOW! My jaw's on the floor rolling down a basement. That is super awesome. I'll need to learn that VBA. Thank you very much, all hail to SirJB7!!!

Hi SirJB7, sorry about H18 has no formula. I'd prefer column Z to run independent of the printing process because (may be) managers don't want to have all the hard copies and I may not want to print those reports without an employee name. As you can see this will only update once a...

same error persisted on Set rng1 = Worksheets(ksWs1).Range(ksRng1) Basically i was using the same file you sent me yesterday...

I got a message: Run-time error '9': Subscript out of range on the line where Set rng1 = Worksheets(ksWs1).Range(ksRng1)

I have a list of employee names in column A2 and down a few hundred rows in Sheet1. In Sheet2 I have a pulldown menu referencing the names in Sheet1. Depending on the name chosen, Sheet2 H18 will compute different performance number for different employees. Question: Is there a solution to...

I guess the answer is yes after you have saved the original file with a different name. Then you run your macro in the newly named file whilst leaving the original untouched (closed).

Try SUMPRODUCT((A2:A6="P2")*B2:D6) Read more here: http://chandoo.org/wp/2011/05/26/advanced-sumproduct-queries/

let's get some champagnes!

Hi Sudeep, I can't download you file for some reason... Anyway, I guess you are looking for a live solution that when you enter pass/fail in summary sheet the other 2 worksheets will update automatically. You can use my method then. all you need to do is to fill out the help columns on...

Wow! Thank you very much, SirJB7! I can't tell if you are old. but i can say you are definitely not lazy helping us out here at chandoo.org. :)

Thanks, Hui. The 2nd link is a great help.

Hi SirJB7! if it is not too much trouble, could you please kindly explain the flow of the macros you have created? Private Sub lstPrinting_LostFocus() Dim I As Integer, J As Integer J = 0 With lstPrinting For I = 0 To .ListCount - 1 If .Selected(I) = True Then J = J + 1 Next I End...

I'd put the file in a public server and designate someone to share with. You can do a search in Excel on sharing workbook for more idea. In general, I'd communicate with the people I'm sharing my workbook that they only work/not work on certain worksheets to avoid duplication of work.

i'd create a helper column on each worksheet total student worksheet the formula would be =countif($E$2:E2,E2)&E2 assuming line 1 is header and column E has the word "Pass" or "Fail" Pass student worksheet create a column and from line 2 copy down so that it shows "1pass", "2pass"...

Hi Chandoo/Hui, Is it possible to write an article on MS Excel 2010 Solver. Solver is so different from what I'm used to and all the new feature are not easy to understand, such as GRG non linear, simple LP, evoluntionary, options, Reports: Answer, sensitivity, limits, outline reports (I...

Thank you very much, SirJB7! It's absolutely BEAUTIFUL! I'm sure many people here could use this technique generating individual report without creating one worksheet for one employee. I used the normal listbox because it was easy for me to use and my manager can view a particular employee...

hi SirJB7 I have uploaded a file. The file name is Testing.xlsm and I'm using MS2010 now. Finally upgrading from 2007 to 2010 version. https://docs.google.com/open?id=0B1Yt3Yl95LuPS2xtSF96bzE2SGM

Hi SirJB7, Good morning. I tried last night but there is a compile error: Variable not defined on ActiveWorksheet. I thought the solution would be macro asking me which person to start printing (such as 67th person) and ends at which person (such as 189th person). Also, I look up the...

I'll try and see how it works tonight. Many thx, SirJB7.

Hi SirJB7, First of all, thanks for helping me. I have encounter a problem with "UserForm1". There is an error message : Compile error: Variable not define I'm using Excel 2010. Does that make a difference?