• 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

    Code only working in debug mode.

    I have this code here that works when i go through the debugger and then when i run the macro it doesn't work. I have removed some titles for sensitive reasons, but the structure is intact. Sub Disseminate() Dim RefName As String Dim RefDate As String Dim Names As Integer Dim I As Integer Dim...
  2. G

    Raw data vs Table?

    which is better, keeping raw data in its original format or making it into a table and why? I use these tables for crossreferencing to reports and metrics. Size of the file is also an issue.
  3. G

    userform text box populates based on selection.

    I am trying to get the userform textbox to automatically change when the user selects a different cell on the worksheet(like an event change), and the value of the selection now becomes the value used in the code as well as being displayed in the textbox.
  4. G

    vlookup finding non blank value

    Wow, had to change "=B2" to ="A2", but it works great. also, had to make it an array formula. Thank you so very much. =IFERROR(INDEX($I$2:$I$23,MATCH(1,($B$2:$B$23=A2)*NOT(ISBLANK($I$2:$I$23)),0)),"")
  5. G

    vlookup finding non blank value

    I have a list of Customers in column B. In column I i have an alternate name. the alternate name once given is always the same. The customer's name can appear multiple times becuase of different dates they visit, but the alternate name might appear on the 6th visit and that is all. what formula...
  6. G

    dynamic charting of dates

    i had a co-worker looking at it and noticed a formula error. its working now. Thank you for your quick response.
  7. G

    dynamic charting of dates

    I am trying to convert daily hour charging into months(sometimes data goes over into different years, like December then to January) how can i have excel automatically know if there are hours charged in a certain range to automatically include all months and appropriate years? i have used the...
  8. G

    select bar on graph and go to data

    I got it. I just used the chart sheet and used the chart events.
  9. G

    select bar on graph and go to data

    yeah, VBA, i have a chart sheet so i can do chart events, I have a list of parts. different people build the parts. I am looking at their time charged to each part. i want to know who charged the less. so when i look at the bar graph of the product, i click on the bar, i can then see who charged...
  10. G

    select bar on graph and go to data

    If memory serves correctly i believe there was a tutorial on how to create graphs and make them selectable. for example. i have a bar graph that gives me total sales. i can then click on that bar and get detailed info about what info goes to that bar. any suggestions? Thanks
  11. G

    Create backup without formulas

    I have a complex spreadsheet. i want to create back up files but without any formulas. I have special formatting and charts. how can i go about this? I have tried doing a vba savacopyas. it works however, i still have all the formulas. i then tried to reopen it and then go through the...
  12. G

    vba code running slowly.

    sorry about the format, it pasted that way and i didn't adjust it. i tried using the conditional format and becuase of the size of the range, it really bogs the spreadsheet. can you assist on the reference concepts. that would be very helpful. I think that that concept is my crux right now.
  13. G

    vba code running slowly.

    I have written a code to open a workbook on a network and calculate a QTY through sumifs formula with 2 criteria. I have 6000 parts and 10 products i am comparing the network file against. the network file is about 70,000 lines. i have tried looping the formula several ways. one line item and...
  14. G

    linking Project to Excel

    Thanks guys, I got it. you are all awesome.
  15. G

    General Excel VBA to copy MS Project field into Excel

    I want some generic code to copy a field in project and paste it into excel. I need the generic syntax and i can change to what i need. i am just lost on the initial code. Thank you, Greg
  16. G

    linking Project to Excel

    Hello Sajan, I am at a production facility. we have decided to go forward to provide MS project schedules for each end item. there are about 700 individual tasks that need to be accomplished. from these project files i need to gather schedule information as well as % complete information. so...
  17. G

    linking Project to Excel

    Does anyone know some VBA to extract column data from Project and put it into Excel. someone please!!!!!!
  18. G

    linking Project to Excel

    html has the same issue, now i am getting an OLE error.
  19. G

    linking Project to Excel

    I got the copy to work, here is the new problem. i keep getting reference issues now. it will work one moment then not another. i will look at the html idea and get back with you. thanks
  20. G

    linking Project to Excel

    I am trying to create metrics from my project file, but i am having trouble linking to my project file for automatic updates. can someone help please. I have done a copy and paste link text but only certain columns are pasted and not everything i copied. Thanks
  21. G

    suming based on criteria on multiple columns

    I am trying to count inventory. i have the product in columns F,G,H and so on. I have the parts that make the product in column B. in addition, i use multiple parts in different assemblies to make this part. meaning, i could use a part 2 or 3 times (like screws). I need to create an inventory...
  22. G

    vba code working with shapes.

    how do i name shapes based on cell values? then add a connetor line to a different shape?
  23. G

    Changing the values of a pivot chart using a combo box

    can you post your file, i can look at it and reference it.
  24. G

    Changing the values of a pivot chart using a combo box

    unfortunately, I am unable to post. i think the problem still lies in the array formula. double click the cell where the formula is, then select ctrl + shift+ enter and it should work. http://chandoo.org/wp/2012/07/03/find-the-last-date-of-an-activity/ this may help in explaining the array...
Back
Top