• 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. G

    Changing the values of a pivot chart using a combo box

    control and shift and enter puts the formula as an array formula, when you use offset, typically an array is required, in this case, if you don't have an array {} those brackets around your formula, i don't think it will work properly. i don't know why you get the save folder, the only thing...
  2. G

    Have problem in opening an excel file

    I had a similar issue with that. we had to ask all possible users to restart their machines. we did the same thing you did and did not work, when we asked all parties who could possibly use the file to shut down and restart, it then worked.
  3. G

    Changing the values of a pivot chart using a combo box

    first thing, where ever your "report filter" filter is located, select the cell and give it a name. For example, cell B1 is my filter button on the pivot, i select B1 and type in the left field of the formula bar OperationSel then add your combo box. right click the combo box and select...
  4. G

    using ByVal in sub procedure

    Luke, that is the same source i previously used before coming here. thats funny. i guess my real question is, how to i declare a by value in my code? do i remove option explicit in my code? suggestions?
  5. G

    Using VLOOKUP to find value to the left

    have you tried filtering with values less than or equal to 0?
  6. G

    using ByVal in sub procedure

    I heard if I use ByVal in my procedure, for example Sub Test(byVal X as long) code' end sub that my code will be executed faster. especially if I have a lot of code to go through. Is this true, if so, how can i use it on a userform button? thanks
  7. G

    Set Cursor position in excel

    try this, you need to put it in the workbook object. open visual basic Alt+11, go to microsoft excel objects double click "ThisWorkbook" and paste the code below. when you put in a value and click enter it will respond. Let me know if this works Private Sub Workbook_SheetChange(ByVal Sh As...
  8. G

    sorting cells and their borders

    unfortunately I can not.
  9. G

    sorting cells and their borders

    yes this is correct. I tried doing a sort based off of the new order from project, but the borders do not follow any type of sort. the challenge is the gantt part of the file. the visual gantt borders wont sort with the items (new order). i did write code before to go to the new order take the...
  10. G

    sorting cells and their borders

    borders are being applied to constants. for example, if work started the value is a 1, this gives me an actual start date, if the work is finished it is a 2, this gives me an actual finished date. also, when work is being performed, they click on "Working" on thier userform and it will put the...
  11. G

    sorting cells and their borders

    I have a file that has a list of items. These items have a schedule. the schedule is conditionally formatted to look like a Gantt chart. This file then gets marked with a border style of when work was started and finished. If the work started a macro will put a diagonal border through the cell...
  12. G

    vlookup

    Oh, never mind, i just changed the ranges to a much smaller range and it calculates in about 9 seconds. Thanks again. you all who support us are Awesome. thanks again SirJB7.
  13. G

    vlookup

    OK, need your help again. I completed the formula for all the cells in my list needed. about 1254. the calculation time is about 5 minutes everytime i make a change. any suggestions?
  14. G

    vlookup

    You are awesome, got it to work. thanks
  15. G

    vlookup

    sure. i have list of part numbers. each part number is an installation that needs to be completed. a work order will be issued with the part number on it, so that, the person will know what to install. lets call the part number ABC. with work order 123. I need a spreadsheet that will track the...
  16. G

    vlookup

    due to the nature of my work, the security paramaters don't allow uploads. sorry, but i can try in here. part number Work Order ABC vlookup formula to find first instance ABC vlookup formula to find second instance. DEF 100-112 data is on network, but...
  17. G

    vlookup

    i am working on a spreadsheet that is part number based. each part number gets a work order assigned. I use Vlookup or Index/match to find the work order associated. however, sometimes they need to make a new work order and no longer use the first work order, but they need both in view and they...
  18. G

    Decent Salary for what we do?

    I would have to absolutely agree with Hui, the business aspect is equally, if not more important than your excel skills. Because of the stigma that goes with excel, not saying i believe in the stigma, but without the business knowledge that backs up your skills, unfortunately, the value isn't as...
  19. G

    vba find mismatches and provide list

    Thanks everyone.
  20. G

    vba find mismatches and provide list

    another quick note, the names on the list will not be located in the same row. in other words the order changes. and i cannot change the order.
  21. G

    vba find mismatches and provide list

    i am trying to compare 2 lists that should be exact. however if they are not exact, i want excel to provide a list of the mismatches. how can i do that?
  22. G

    vba conditional format

    Hmmmmmm. i have been trying all day and everytime I recorded all i would get is the cell i selected and that was it. Now, i just recorded it and it worked. go figure right! Thanks!!!
  23. G

    vba conditional format

    macros don't record conditional formats.
  24. G

    vba conditional format

    I am trying to set a conditional format based on a range that contains today's date. any one know the syntax of format conditions?
  25. G

    conditional formatting problem

    is there a way i can just delete all on the temp sheet conditional formats and then copy the formats from the master sheet to remove all the redundants? i looked in to Range("$A$4:$PK$800").FormatConditions.copy but it doesn't exist. i need my conditional "applies to" field to have the...
Back
Top