A1 reads =+(B1+C1)/C1 where B1 represents 'the current month' and C1 represents 'the previous month'. The formula in A1 shows me the change between the current and previous months. Each month I want to insert a new column between A and B, and, I want the formula in A1 to remain as =+(B1+C1)/C1.
I've tried different things, but it seems no matter what I do, when I insert a column between A and B, the formula in A1 changes to =+(C1+D1)/DC1
Any thoughts?
Thank you.
Joe
Last edited by mystockpick; 06-01-2014 at 09:13 AM.
Try this........
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Works great!! Awesome. Thank you!
Another option...
=SUM(OFFSET($A$1,0,1,,2))/OFFSET($A$1,0,2)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
@FDibbins
Nice one.
@mystockpick
Glad it helped.
If that takes care of your question, please mark your thread as solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.
Moreover you may also click on * (star) to Add Reputation to those who have put their time and efforts to help you in this forum. This is another way to say thanks to them.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks