• 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

    Macro to find & replace text

    Oh! I m sorry for this. I'll check the link and update you accordingly. Thank you very much.
  2. R

    Macro to find & replace text

    Can any one help on this issue?
  3. R

    Macro to find & replace text

    Hello everyone, I have two files, Book1 & Book2. Book1 is used for reporting. I have to do find and replace many times to update this workbook. Is it possible to do it with a macro. I will put "text to be find" in Cell A1 of book2 and "text to be replaced" in cell A2 of book2. When I run the...
  4. R

    Links using Indirect function

    can I have some short vba code for this.
  5. R

    Links using Indirect function

    It's difficult for me to use VBA
  6. R

    Links using Indirect function

    I have uploaded a sample file.
  7. R

    Links using Indirect function

    Part of formula ='C:\Users\ranjeet\Desktop\New folder\[sales.xlsx]A'!D6 In the above link Now next month I've to change sheet reference from A to B and so on.
  8. R

    Links using Indirect function

    Thanks, but I have to change sheet reference every month so I am looking for a solution for that.
  9. R

    Links using Indirect function

    Hi, I have created a link to another workbook using indirect function. When such source data file is closed it shows #Ref error. I used manual calculation option but it fails when I refresh the file. Basically, purpose of creating of link using indirect is only that I want to change sheet...
  10. R

    Grouping with Multiple column filtering

    Hi, you can use "Sorting option" First sort by "SEC" then by "CCY"
Back
Top