nancybrown
Well-known Member
- Joined
- Apr 7, 2005
- Messages
- 868
I have a file with two tabs: Tab1 "2009 payment terms" is updated each week. Tab2 "2008 payment terms does not change.
On a weekly basis I insert a column in the 2009 payment terms and using the unique identifier Vendor ID, I add an index statement to being in matching 2008 payment terms from tab2 so I can have a side-by-side view of the 2008 and 2009 terms.
I then insert another column "Terms Status" and add an IF statement to show differences in the 2008 & 2009 terms and return values. It is something like: =IF(d2=c2,"No Change",IF(d2>c2,"Updated",IF(d2<c2,"Lost Terms")
My question . . . to avoid this repetitiveness, is the code to program a button to do these functions for me???
Any help would be appreciated.
On a weekly basis I insert a column in the 2009 payment terms and using the unique identifier Vendor ID, I add an index statement to being in matching 2008 payment terms from tab2 so I can have a side-by-side view of the 2008 and 2009 terms.
I then insert another column "Terms Status" and add an IF statement to show differences in the 2008 & 2009 terms and return values. It is something like: =IF(d2=c2,"No Change",IF(d2>c2,"Updated",IF(d2<c2,"Lost Terms")
My question . . . to avoid this repetitiveness, is the code to program a button to do these functions for me???
Any help would be appreciated.