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

    Power Query, Pivot every alternate row

    Hi , In the custom column, I have store names and every alternate row contains the word T&F, I need to pivot the rows where T&F along with the "Yes/No" in the value column. The end result should read: Custom Value T&F Dubai Mall-DM1-1404 Yes No Much appreciated for a solution in Power...
  2. C

    Dates filter not working in VBA

    Hello ALL, I have a macro that filters dates by month and year based on cell values. I have dates that range from the year 2020 till year 2030. Now the strange part is that all years filter properly except for any dates that lie within the year 2030 I have the below code and could'nt find a...
  3. C

    Run time error '91' object variable or with block variable not set error on opening file

    Hi All, I made a macro file with a worksheet selection change events, whenever i send it to my colleagues over the internet by mail, when they open it, they have to enable editing, after enabling editing it throws this run time error '91' object variable or with block variable not set , once...
  4. C

    Mouse events on charts

    Hi Chandoo, Is it possible you could do some tutorials on mouse hover events on charts.... thanks, Mustafa
  5. C

    Dashboards

    Hi there, I have an excel dashboard and a combo box that select the users name, below are some charts that update accordingly. I dont want the end user to mess around with the charts so i need to lock all the cells and charts in the dashboard. If i lock all the cells, and hover my mouse over...
  6. C

    Pricechecker

    Hi all there , can you help with some VBA code for the following: In column A i have some numbers between 1 and 12 which represents units, and column B has the price. In column C-N which starts from January i need to have the result of units * price but the cells should be filled in such a...
  7. C

    Nesting formulas

    Hi Chandoo / Everyone How can we learn how to nest formulas and make really mega formulas. If you can share some data with nested formulas with the explanations, would be great. Thanks, Mustafa
  8. C

    ANIMATED CHARTS

    HELLO EVERYONE OUT THERE, CAN ANYONE COME UP WITH AN ANIMATED CHART, SOMETHING THAT MOVES SMOOTHLY....IF YOU HAVE SEEN THE EXCEL HERO WEB SITE....CAN ANYONE EXPLAIN HOW THAT IS DONE...OR BETTER CAN ANYONE SUGGEST AN EASIER METHOD HOW TO DO ANIMATION IN CHARTS. CHANDOO...WOULD LIKE YOUR HELP IN...
Back
Top