• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. J

    Dashboard

    Sorry fellas, I don't get it. I typed this: Private Sub Worksheet_Change(ByVal Target As Range) If Intersect (Target, Range("A1:B10)) Is Nothing Then Exit Sub Application.EnableEvents = False Worksheets("Sheet1").PivotTables("Pivottable1").PivotCache.Refresh Application.EnableEvents =...
  2. J

    Dashboard

    Thanks Sir, That both you guys helped. They didn't cover VBA in my class. Thanks again.
  3. J

    Dashboard

    Hi Hui, Not familiar with VBA codes. Can you tell me step by step if you have the time? Thanks, Joe.
  4. J

    Dashboard

    Hi Chandoo, I have a question for you regarding dashboards. I have my data in one worksheet and my pivot table and charts in another worksheet. When I go to insert another row in the data it doesn't seem to update the pivot table automatically. I can use the change data source to update it...
  5. J

    Payroll Calculation

    Here is my sample: Timesheet MONDAY Start 8:30 am Lunch 0:30 mm Finish 5:30 pm Total ????? Thanks, JOE.
  6. J

    Payroll Calculation

    Hi Chandoo et all, Thanks so much for answering my other questions, really like this site alot. I have a payroll question for you: I am trying to figure out how I go about doing the lunch break if it is in this format: time in 8:00AM time out: :30 min time in: 1:00PM time out 5:00 PM...
  7. J

    Subtotal Formula

    Hi SirJB7, Can you explain what Tabla means? Thank you.
  8. J

    Bubble Charts on top of a map

    Thanks you guys rule too. Someone just answered another question for me so quickly. Thanks again. Joe, from Michigan.
  9. J

    Subtotal Formula

    Boy you guys rule, thats what i was looking for. you know what youre talking about, and you respond in a promt manner, thanks again can you pass the second question to any of your collegues? Thanks again, I'm glad I found your website. Joe, from Michigan.
  10. J

    Bubble Charts on top of a map

    I wish I knew how to do this. Can someone go step by step with me. Joe, from Michigan.
  11. J

    Subtotal Formula

    Hi Chandoo, Hope all is well in the new year. I have a couple of questions regarding the subtotal formula for you. I want to add some rows to a section of my subtotal and I know to use the offset function, but where do you put it within the subtotal formula? Also I would like to learn how to...
  12. J

    Text Functions

    Thanks Luke that's what I need it to do!! You guys are awesome.
  13. J

    Text Functions

    Hi all, Thanks for responding. I will try all your information. Thanks for the help. I'm sure I will be asking more questions since I've been reviewing Excel on my own. Thanks again.
  14. J

    Text Functions

    Hi, Thanks for responding. Here is what I am trying to do: Joseph Lee Horling Lee =MID(I54,FIND(" ",I54)+1,FIND(" ",I54,FIND(" ",I54)+1)-1-FIND(" ",I54)) Thats where the Lee pops up next to my full name after doing the formula. Then I would like to change the Lee in that same cell to...
  15. J

    Text Functions

    Hi Chandoo People I am wondering if I can do something in the Excel text function. I can extract my middle name using this formula: =MID(I54,FIND(" ",I54)+1,FIND(" ",I54,FIND(" ",I54)+1)-1-FIND(" ",I54)). Not a problem in doing that. What I would like to do is within that formula can I...
  16. J

    Speedometer Chart

    Hi Chandoo Organziation, I am working on a speedometer chart. I don't know how to allocate the data labels to look like an actual speedometer on a car. Is there a formula I use or can I just write 10,20, 30 ect. in a column and use it in the select data dialogue box? Can you give me some...
  17. J

    Combo Box

    My apologies sgmpatnaik. Joe.
  18. J

    Combo Box

    Hi Chandoo People, I am still having a problem in my combo box. I have a list of names in column b and would like the prefix to those names as Mr. Mrs. and Ms. in column a. I used Active for the combo box so i can check the properties easier. To my problem it is only linked to one cell...
  19. J

    Combo Boxes

    Hi, This is in response to Jason's post regarding my question on combo boxes. The combo box is in form control. I want a drop down list with the prefix's of Mr., Mrs. & Ms. in the first 20 cells or so. I can get the list input in the box but when I pick Mr. it goes to a number 1 in the...
  20. J

    Combo Boxes

    Hi Trying to make a combo box with Mr., Mrs. & Ms. as a prefix in a column. Can't seem to get the text, just the number. Thanks for your help. Joe from Michigan.
  21. J

    formulas

    Hi, I received my Microsoft Office 2007 Certification, but havent used it yet for a company. I was just wondering what I need to know when I go in for a job interview. I have reviewed a lot thanks to your website. I've been studying alot of the formulas like vlookup,if,time calculations...
Back
Top