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

    Automatic OK

    Hi, In Excel I created several tables over Power Query by connecting to web sites. I have set tales Refresh every 30 minutes. But sometimes the web sites do not respond and message box appears about it. Can I configure Excel to automatically click on OK button so that it disappears...
  2. A

    Excel selects updated tables instead of summary table

    Hi, I have several tables create over Web query using Power Query. And I have summary table created over those tables. I want to refresh the tables so that my summary table shows the latest figures. When I update the tables Excel automatically selects last updated table. But I need Excel to...
  3. A

    Getting data from web with Power Query

    Hello, I need to get data from web (Crude Oil Historical Prices - Investing.com). But I want to get data not for the last month as seen over the web-page, but for the greater date range. There is option to select start and end date on web-site. However, when I select the range and run, I...
  4. A

    Putting Excel file in Windows startup folder with VBA

    Hello, I need help with VBA code to put file to Windows Startup folder so that the file is open-ed automatically on every Windows start up. Thank you, Anar
  5. A

    Adding/Removing Pivot Table Value Field item with VBA

    Hello, I want to add/remove Pivot Table Value Field item with a macro. Want to then assign the code to a button and when clicking the button the addition and removal should alternate. Please Help.
  6. A

    SUMPRODUCT with closed workbook

    Hello, I have a problem with SUMPRODUCT formula. I have searched internet, including this website for help, but could not find anything. I have a file (destination file) where I put Sumproduct formula from another files (source files). Formulas work in sheet1 in destination file, but not in...
  7. A

    Print template with changing numbering

    Hi, guys, I need help. The issue is that I have a template, I need to print 120 copies of it. The whole structure of the template does not change except for the numbers of the each template, for example, first printed template should have a number QSA1, second QSA2, etc. It can be done...
  8. A

    Addition to macro code

    Hi everyone I have code purpose of which is to repeatedly write the same words in several workbooks. To do that I open all workbooks and run macro in each workbook separately. The macro writes the required words, then saves the workbook and closes it. I don't want to run macro manually...
  9. A

    Group numbers

    Hi, everyone I need help. The issue is described below. Below is a list of invoice groups. Group number of the first group of invoices is 1 and it is written in front of the first invoice. I need to write a formula which will show me group number of each invoice group. The group number should...
  10. A

    Macro to change file name daily

    Hello, Can anyone suggest a code to change the date in Excel file name daily. File name is in this format: FileName_Date FileName will stay the same each day, Date should change every day BR, Anar
Back
Top