Imagine a long sheet with several sections, each ending with a Totals. And you want to switch line items between sections/departments quickly.
Now imagine each time you cut and paste a line itme you need to go back and alter the Sum Formula . Tiresome :) So far I have not found a workaround, but thought it may be something that a versed Excel person would know off the top of their heads ^_^ Any info is appreciated! :) On 6/7/06, Adkins, Randy <[EMAIL PROTECTED]> wrote: > Hmm that is a good question, I did what you indicated by cutting a row > And noticed the formulas change and such. > > Not sure if there is a work-around or not. Have to keep plugging away > At it and see if there is anything I can come up with. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:5:208302 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
