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

    Export userform as a pdf

    Hi All I've been using below code without any problems on 32bit, however doesn't work in 64bit. ' Export UserForm as PDF (image) Dim pdfName As String Dim newWS As Worksheet keybd_event VK_LMENU, 0, KEYEVENTF_EXTENDEDKEY, 0 keybd_event VK_SNAPSHOT, 0...
  2. R

    Index Match 2 criteria's and return two results from 2workbooks

    Bosco, apologies as forgotten to thank you. Regards R
  3. R

    Index Match 2 criteria's and return two results from 2workbooks

    Hi There Need some help, please. I have a file with 2 workbook (sheet1 and sheet2, on sheet1 have various columns, where on sheet2 only have 4 columns, however both worksheets have hundreds of rows. What I'm looking after is that: On sheet1 A2:A4 & F2:F4 (as a index) On sheet 2 look and match...
  4. R

    VLookup from another workbook and return results from 3 columns

    Thank you, very much appreciated. R
  5. R

    VLookup from another workbook and return results from 3 columns

    Hi vletm Some of the rows doesn't copy properly, as you have mentioned probably due to the spaces on the source file. Could you please let me know what [#All] after table1 does? Anyway, thank you for your help. Regards R
  6. R

    VLookup from another workbook and return results from 3 columns

    Hi There I'm trying to use this formula: VLOOKUP(B3,[Source.xlsx]Sheet1!$A$3:$H$10,{6,7,8},FALSE) ; without success, could some please help me on this one? Brief: Have two files, one named "Formula" (where I have the Vlookup formula) and other named "source". The formula file "Column B" has...
  7. R

    Rank the highest value

    Hi All Managed, file attached with a solution, might help someone. Thanks again. Regards R
  8. R

    Rank the highest value

    Hi All On the file attached shows on column H the values from column F sorted by the largest to the smallest value. However I would like to rate the highest value on column J to 1, the next highest to 2, next to 3 and so on. Could someone please help me with formula? Thanks. Regards Americo
  9. R

    Extract text from a column ignoring duplicates and blanks

    Thanks, unfortunately don't have office 365, only 2010.
  10. R

    Extract text from a column ignoring duplicates and blanks

    Hi There Have a column with 7000 + records (text), would like to extract to another column, a list with text strings ignoring duplicates and blanks cells. I'm using on cell C2 a formula but doesn't return what I need. File attached. Thanks in advance. Regards R
  11. R

    Calculate date & time difference

    Hi All I am wondering if someone could help me please. Need to calculate date and time difference between three columns. The problem I'm facing is that, one of the dates and time are in a separate columns (F&G): Column F=date Column G=time (of F) Column K = date & time together (separate...
  12. R

    VBA code to set a formula on a range when workbook open

    Thank you so much. Will have a go. Regards R
  13. R

    VBA code to set a formula on a range when workbook open

    Hi Tried that, but the code doesn't work. On sheet2 cell N7, set a date, so either when before close or save should move/paste the row to sheet3. Could you please help? Thanks again R
  14. R

    VBA code to set a formula on a range when workbook open

    P45cal The reason I need it, part of the another piece of code is (archive) data move the entire row and past it in a another worksheet and after run the code the cell "o" loose the formula, probably the copycells code is not correct (file attached). On sheet2 cell o7 the conditional formula is...
  15. R

    VBA code to set a formula on a range when workbook open

    Hi There I tried to use without success below code to force the formula to set & refreshed when workbook opens Would like to set a range Sheet2 O6:O10000 Conditional formula: =IF(L6="","",IF(L6-TODAY(),"Action Needed",IF(L6<TODAY(),"Overdue",IF(L6>TODAY(),"")))) ActiveCell.FormulaR1C1 = _...
  16. R

    VBA copy and paste range

    Hi All I'm wondering if someone could help me with a couple things, please? 1 - when change a date on sheet2 column L, should copy entire row to Sheet3 starting on cell C6 (code on sheet2), so records every time the date is changed. 2 - Code on Module1 Sub copy cells, wondering if possible to...
  17. R

    SUMIF with two criteria

    Thank you Hui Very much appreciated. Regards R
  18. R

    SUMIF with two criteria

    File attached Thanks R
  19. R

    SUMIF with two criteria

    Hui,Narayan Thank you for your prompt reply. @Narayan I need the opposite, if possible. This week - Australia/Brazil how many cells on deadline column in 1 week time - Australia/Brazil how many cells on deadline column in 2 weeks time- Australia/Brazil how many cells on deadline column Tried...
  20. R

    SUMIF with two criteria

    Hi there I'm looking for a formula (samples on sheet1 C6 to C10), to sum how many cells on sheet2 column L have a date (this week, 1week, 2weeks,etc) based on column E (countries). The formulas on file attached works fine only with one criteria. Any help will be appreciated. Thanks in advance...
  21. R

    Excel formula MAX +1

    Sorry, forgot to say that, sheet3 works as a archive of sheet2, when row(s) on sheet2 are set to complete. When set to complete the entire row is moved to sheet3. I need to look for the last number on both sheets 2&3 C6:C2000. Thanks for your help. R
  22. R

    Excel formula MAX +1

    Hi File attached. Thanks again R
Back
Top