Search results

I'm a fan of Peter's work. So much so that I dropped cell references completely around 2010. I have rewritten several ModelOff challenges (I don't compete) without cell references so I know it is possible to do Financial Modeling and many other types of spreadsheets without them. Why? Names...

I'll let others answer your question. I'm going to provide something else - what I believe is better. Your data structured is best categorized as a crosstab table. Crosstab tables cannot be pivoted, filtered, sorted, easily summed, or easily expanded. If you want to see the science behind what...

Just to mention - since my #1 Rule of VBA is to not use VBA to do what XL does natively - This can be achieved in XL 2010 and higher using Auto-Filters and/or Slicers. 1) Click on any data cell in sheet "Data" and use CTRL-T to turn it into a table. Check "My Table has Headers". 2) In the...

Use Advanced Filter Sheets("Report").Activate Sheets("Data").Range("A1").CurrentRegion.AdvancedFilter Action:=xlFilterCopy, _ CriteriaRange:=Range("Criteria"), CopyToRange:=Range("Extract"), Unique:=False 1) Change Report!B2 from "Product" to "Product Type" to agree with data headings 2)...