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

    Identifying Calculation options easily

    Afternoon all, In our organisation, one department has a system that require Excel to be in manual calculation mode. Which is a pain when they send you a file and and it knocks it off on all your own files. I'm looking for a simple way to identify this, maybe being able to change the colour of...
  2. M

    SUM variable number of rows

    This also works, 57. Out of interest is there pros and cons of using Sumifs V SumProduct? Cheers
  3. M

    SUM variable number of rows

    Works a treat, thank you very much. Like the logic, I'll be able use that going forward :)
  4. M

    SUM variable number of rows

    hello all, I was wondering if it was possible to lookup a date value in one column, then sum the values in the next column for variable number of rows, eg. Data DATE PRICE 01/4/15 10 02/04/15 11 03/04/15 11 04/04/15 10 ... Then i have cells with date and number of...
  5. M

    Refresh data table using VBA

    Cheers Luke - I got so obsessed with "It works on another file" I didn't see the obvious. Appreciate the help.
  6. M

    Refresh data table using VBA

    Afternoon, I need some help with what I thought was a simple refresh. I'm trying to create a button that will update the data in a hidden sheet. I use this same code in a different file and it works fine, but this new file is using a data table. ActiveWorkbook.Worksheets("2015...
  7. M

    "Simple" Checkbox query

    Hi, I've got a file that prepare a report pack and prints, various reports. Someone has asked to have a pack excluding a few reports, so I thought I would add a checkbox next to the report list. Just been testing this and it doesn't like it. My VBA knowledge is light, but thought this was...
  8. M

    VBA help

    Hi, I've just completed a rather large product/pricing model and realised that unless I have something that allows the actual data (formula) to be pasted as values, I will have do a lot of manual copy/pasting everything I open a file. This is way beyond my VBA skills (even been generous to...
  9. M

    VBA to filter specifc rows

    Cheers Luke, thanks for you help. i would have struggled with "and" bit!
  10. M

    VBA to filter specifc rows

    Actually been trying to figure it out, I'm able to show the totals, but struggling with not showing 0Total Sub ShowTotals() ' ' Application.ScreenUpdating = False Range("B4").Select Selection.AutoFilter Selection.AutoFilter Field:=1, Criteria1:="*Total" Range(Selection...
  11. M

    VBA to filter specifc rows

    Hi Luke, thanks for the reply. Yeah i though of this, but the length of the product list is inconsistent, I'd prefer something more robust in case list become longer than recorded macro. Cheers Paul
  12. M

    VBA to filter specifc rows

    Hi all, I have a large list of products, each with a product total line, e.g. Product1 Product1 Product1 Product1 Total Product2 Product2 Product2 Product2 Total I'd like a button to be able to filter to only see the total lines. It need to ignore "0 Total" as i have a few blanks. Any...
  13. M

    Reference sheet name from cell

    Hello all, I'm trying to link to an external file, but using the data in a cell to reference the sheet name: So this formula works, as it is referencing the file/sheet - the Product Sales.xls file has 24 sheets, one for each product. =VLOOKUP($C$4,'[Product Sales.xls]Product...
  14. M

    Clear indicator when manual calculation on

    Hello all, Bet most of us have been caught by jumping from a file with calculations turned off to another file expecting calculations to be on, printing some work and going into a meeting with a pile of nonsense! Is there anyway, without added something to each and every excel file, that Excel...
  15. M

    Managing Performance

    Hi all, I was wondering if anyone could give advice or point me in the right direction of some good articles on spreadsheet performance. I.e. Some general rules to manage file size, speed, security. Maybe some guideline on choice of functions, I know some are more CPU heavy than others...
  16. M

    Count query

    Thank you SirJB7, you confised me a little by using >G6 rather than I7, but I got ya! Spot on and I understand it! Thanks for swift response, appreciated.
  17. M

    Count query

    Hi all, run into a brick wall with doing some counts. I'm looking to create a count based on a few columns. So been using countifs, all good. But now as well as one value from two different columns i want to look for a range of values in another columns...
  18. M

    Don't show line graph when 0

    Example attached, https://dl.dropboxusercontent.com/u/9071274/LineGraph%20issue.xlsx thanks
  19. M

    Don't show line graph when 0

    Thanks for response. Yeah tried that, it doesn't plot the point but it doesn't remove the line. So it skips the points and the line goes to the next point, which gives a false picture of the zero value. Cheers
  20. M

    Don't show line graph when 0

    Hi, I've a set of values that creates a line graph, most values are around the 90% mark, but there are a few zeros. Rather the the line graph dropping from 90% to 0%, I'd rather not show the line to zero. Tried everything (well everything i thought of), the only way it work is when i...
  21. M

    Price Quality Matrix

    Spent 30 mins looking for that simple answer! cheers
  22. M

    Price Quality Matrix

    Hi Luke, Thanks for the pointer. This code is setting the x axis, not Y, where am I going wrong? Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) Select Case Target.Address Case "$B$26" ActiveSheet.ChartObjects("Chart 1").Chart.Axes(xlCategory) _...
  23. M

    Price Quality Matrix

    Thanks guys. With a tweak or two Luke's example will work. Ideally I'd like to set the Y axis maximum scale to based on a value set in cell A13 for example. Also I've removed all gridlines, but again I'd like to set one line based on data in cell A14 (basically a mid point), so we get four...
  24. M

    Price Quality Matrix

    Hi, I'm trying to create a price/quality matrix, started off thinking it was easy, but hit a brick wall! If you imagine this dataset, a list of competitors, a price which would set the Y axis and Quality score that would be the X axis. E.g. Comp2 would be lower on the price and quality...
Top