• 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

    line chart - time format

    Hi mates, I have a series of data with 3 columns: A = date B = time (hh:mm) C = stock I want to make a chart with the time evolution of the stock. The problem is that in some days I have 6 different entries (different times and different stock) and in others I have 1 or even 0 entries. How...
  2. C

    Pivot Table - filter multiple values except one

    Good morning all, I have a Pivot Table where I am filtering out all "0" and "blank" values in the report filter for my column T. That means I end up viewing all values 1, 2, 3...... 250 and they are all selected. Next week when I refresh the PT and there is a value 251 or 1000. Will these...
  3. C

    List different entries

    Hello, I have been trying to list all the different text entries in Column A. The goal is to then use the list for validation purposes in a form. I could do it with pivot table, but I would prefer not to. Giving it a little bit of thought, I suppose I could use a function to COUNT all the...
  4. C

    code to make two cells have the same value

    Hello, I am looking for a way to have cells A1 in sheet1 and A1 in sheet2 always have the same value. The action would be: - both are blank - I enter number 1 in A1 sheet1 --> A1 in sheet2 gets number 1 as well - I enter letter a in A1 in sheet2 --> A1 in sheet1 changes from 1 to...
  5. C

    Code to change Pivot Table filter based on cell value

    Hello, I am setting up a dashboard, and for that I would need that some Pivot Tables would filter themselves based on the value on a specific cell. I got this code until now: Sheets("INDEX").PivotTables("SFCClusterPT").PivotFields("cluster").CurrentPage = Range("BC21").Value I re-checked...
  6. C

    Form to change single cell value

    Hello Excellers, I have been googling this for a while but I cannot find exactly what I look for and I am not good enough to adapt the few examples I have until now. What I would need is to have a kind of a simple for to change the value of a single cell, based on the various options in a...
  7. C

    number col B referring to col A descending order

    Hello, Lets imagine that column A has: 10 110 1110 9 18 I would like column B to have some kind of ranking related to column A so that the result would be: 10 4 110 2 1110 1 9 5 18 3 How can I do that for a large list?
  8. C

    Hide row based on cell value

    Hello, I am looking for a solution for one of my workbooks to make it easier to read and make it smaller, eliminating not needed or blank areas. For it I would like to know how can VBA code help me to make: IF A1 = "1" then hide row 1, otherwise do nothing. The same for row 2, 3, 4, and so...
  9. C

    Auto hide rows/columns according to reference

    Hello, I have cut in another topic with this question, but probably it is better if I stop being lazy and write my own in the propper forum. I am thinking about a "dynamic" table showing the names of the customers in C2:IV2(?) and the product clusters in B3:B1000(?) With a function I would...
  10. C

    VBA code to pair cells' formatting

    Hello, In the same spreadsheet I have two twin data tables. One is for manually entering data, the other one shows the result of the calculation of the manual entry and some other figures. Now I would like to mark some cell somehow (patterns, font color, bold, etc.) in the first table in a...
  11. C

    Expense tracker - treating the database

    Hello, I have been trying the 7 Personal Expense Trackers from last week's post and I realized that I like some of them a lot but I know I will not use them. In the past I have designed my own Tracker for this purpose and it was great (for me). Nevertheless the updates only lasted 4 months...
  12. C

    Filter list order in Pivot Table

    Hi, Is there any way to re-arrange the order of the items in one specific filter in a Pivot Table? It seems that excel sorts it "in order of appearence", but could it be done in alphabetical order, for example? Reason: I'm tired of doing millions of Move Down/Move Up/Move to end... Thanks
  13. C

    Stock coverage with Sales Forecast consumption

    Hi, I am doing production planning and there is an issue that has haunted me for a while. When you have a stock figure and based on a weekly sales forecast figure (that may change from week to week), how do you calc how many weeks you can cover with that initial stock? Manually: Stock=100...
Back
Top