• 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

    First: find correct ID, than: match transaction codes

    Hi Hui, I can't copy the tables into the same workbook I want to do this every month There are about 700 personnel numbers(this changes every month) And there are 192 transaction codes(this changes around twice a year)
  2. G

    First: find correct ID, than: match transaction codes

    Rewritten so it's clearer(I hope) Hi, I have two files: File 1: these are employees (personnel numbers) with the transaction codes they are allowed to have in our computer system File 2: an export from our computer system containing the actually assigned transaction codes for every...
  3. G

    First: find correct ID, than: match transaction codes

    Hi I have two files File 1: list of ID's with a set of transaction-codes they are allowed to possess in a computersystem we use. File 2: export from the system with the actual transaction-codes that are allocated. In the column "Control" I want the transaction-codes that don't match...
  4. G

    Copy paste to other sheets

    I have a sheet with 3 Columns: Column 1: company names(sorted) Column 2: product Column 3: sales I'm looking for a macro that copies the records from the same company to the corresponding sheets(comp1 goes to sheet comp1, comp2 goes to sheet comp2, etc) Can anyone help? I have included...
  5. G

    Select two months, hide the others

    Superb! It works!
  6. G

    Select two months, hide the others

    Hi, I'm creating a timeline. I want to select two months in cell A1 and B1, the two months selected and the months in between have to bee visible the other ones have to be hidden Is this possible? I have included a example file: http://dl.dropbox.com/u/12607909/example.xlsx I could...
  7. G

    Return sum of range from other file

    Spot on! Now the next challenge: to understand your code.... THANKS
  8. G

    Return sum of range from other file

    The range is E9:V9 Formula used: =SUMIF(E9:V9,1,E4:V4) When it sees "A25S" in File B It has to total E9*E4+F8*F4 etc till V9*V4 in column B of File A etc etc thanks!
  9. G

    Return sum of range from other file

    Hi, I can't find the right formula for my problem. I have two files: File A and File B In File A is a column with Id numbers In File B is a column with ID numbers and to the right columns with transactioncodes. When a transactioncode is active for an ID number there is a "1" in the cell...
  10. G

    VBA code only works once

    Yep it works, Thanks Hui!
  11. G

    VBA code only works once

    Hi, I have VBA code that moves a row from my "todo" sheet to another sheet as soon as I fill in "finished". The problem is that it doesn't work very well. It only works when I restart Excel. When I fill in "finished" after I use other macro's or Autofilter it doesn't work anymore. I have to...
  12. G

    Collapsing charts

    Hi Hui, Super! That does the trick! Thanks, govi
  13. G

    Collapsing charts

    Hui, Thanks for your reply. The charts are collapsing, not the picture taken with the camera tool. I removed one picture and printed again, the chart with the picture removed didn't collapse, the others still did???
  14. G

    Collapsing charts

    Hi, I have a couple of charts on a dashboard which are displayed there with the use of the cameratool. Every time I print the dashboard(paper and pdf) the source charts(which are on another sheet) collapse. Links to the before and after pictures: www.excelutions.nl/download/before.png...
  15. G

    Macro to password protect all xls files in folder

    Hi, I'm looking for code that can password protect all files(so they need to know the password to open it) in a folder. Can anyone help? Thanks, govi
  16. G

    VBA search with variable

    Got it! 'Sub Search() Application.ScreenUpdating = False 'Search Dim Search As String On Error GoTo ErrorCatch Search = Range("Search").Value Sheets("data").Select Columns("M:M").Select Selection.Find(What:=Search, After:=ActiveCell, LookIn:=xlFormulas, _ LookAt:=xlWhole...
  17. G

    VBA search with variable

    Hi, That a good one but I still have another problem: There are a couple of actions the macro performs after it has found the record. If it doesn't find the record is must not perform those actions. How can I realize that? Sub Search() ' Search Macro Dim Search As String On Error...
  18. G

    VBA search with variable

    Thanks, perfect!
  19. G

    VBA search with variable

    Hi, I want to perform a search with a variable: Sheet1: in cell A1 you put the search variable Then you activate a macro that will lookup the variable in sheet 2 column 3 and select it
  20. G

    Forgot password :(

    This app works perfectly: http://www.lostpassword.com/excel.htm
  21. G

    Excel to web

    Hi uwseidl, That looks interesting, I'm gonna try it tonight. Thanks
  22. G

    Interactive Jobless Rate for People Like You - Very Interesting Implementation

    Looks good. Jon Peltier has a nice tutorial to make the same in excel: http://peltiertech.com/WordPress/interactive-multiple-line-chart/
  23. G

    specific format in a cell

    See this post by PHD himself: http://chandoo.org/wp/2008/08/07/excel-add-drop-down-list/
  24. G

    specific format in a cell

    Use Data validation: Data > Data validation
  25. G

    Movie fan?

    You are close! I have seen 121...Next saturday I will see "500 days of Summer" Last week I saw "Inglourious Basterds"; that is a comedy(sort of). Go and see is fast, in a couple of weeks you are feeding your new cell at night, and you won't have time to watch a lot of movies ;-)
Back
Top