Quote:
Originally Posted by Mike Finley
Write this in excel and set up one worksheet as a separate price sheet to pull everybodies prices from. Everybodies individual worksheet would do the calculations off the single price sheet. You change the single price sheet and everybodies individual prices recalculates based off the new price changes.
|
That sounds exactly like what I need. I can probably do it, but my skills at excel won't allow me to do it quickly! It will be nice since we have about 70 different plans that we need price adjustments every 8 months or so. Going through everyones files and multipling the increase by the sqft for each plan is time consuming. Thanks for the idea!