Search threads

This Week's Hot Topics

• SUMPRODUCT formula & chart for blended tier pricing

  • Started by tammyanthos
  • Yesterday at 1:40 PM
  • Replies: 64

  Blended tier pricing I need to create a chart and formula that calculates what the price = based on the $ amount of the account e.g. accounts...
• Advanced Formula Help - INDEX MATCH MATCH? VLOOKUP? Please help :(

  • Started by CarrieWarrie
  • Saturday at 2:16 AM
  • Replies: 40

  Hi guys, Wondering if anybody can help me - I have been trying to figure out this formula for 2 days now, with no luck :( I'm trying to figure...
• Input box select sheet

  • Started by Tigerexcel
  • Mar 31, 2020
  • Replies: 38

  I'm trying to insert an input box whereby the user just selects a worksheet, rather than having to type it in. So far I have, Dim Sheetname As...
• code not looping.

  • Started by orsm6
  • Mar 31, 2020
  • Replies: 30

  hi all - i thought this code would loop through the range and put a formula in every box ... but it doesn't. how can it be changed to make it...
• Pls help - macros with protected sheets

  • Started by momentumons
  • Thursday at 12:33 AM
  • Replies: 32

  Hello! I have a model that has two macros in it that both basically copy and paste data. How can I get these to run but also protect the sheets so...
• Find and Replace values not equal to

  • Started by akjohno
  • Mar 31, 2020
  • Replies: 29

  Hi all, I have some code to change values of say column D in a worksheet. It looks at the values (numeric) and then if it finds say a 400 it...