I am trying to set up a quote sheet for the sales team, and have run into problems with inserting cells, fill formulas down, and set up to accomodate dynamic range for calculations.
Ex: Below is an example of my sheet...C21:K26. What I need is to add cells in Col C:K at cursor (could be in any row from below column heading to the blank row above Quote Total), fill formulas into new cells, and update Quote Total formula. Base Price is an INDEX MATCH MATCH formula, Multiplier refers to a specific cell on same worksheet, and Col K is blank but needs to shift with the rest to maintain formatting below. I may need anywhere from just these 3 rows to over 50 rows depending on complexity of quote.
I am very familiar with Excel, but have not done VBA for over 8 years, so I am struggling. They say if you don't use it, you lose it! So very true!HTML Code:
Any help greatly appreciated as the sales team is eager to start using new format! (HELP!!!)
Bookmarks