Date Tracking

flexinau

Board Regular
Joined
Sep 22, 2002
Messages
118
Hi Excel Buddies,

You are all experts!!!!!

How is it possible to track the dates for when data are changed?

For example:
Column A is a type of yoyo
Column B is the rebate % for the yoyo

For Yoyos, the rebate rate might be 10% on 9 Oct 02. The rebate rate is amended to 12% on 15 Nov 02. This means that the effective date of the rebate of 10% on the yoyo is from 9 Oct 02 up to 14 Nov 02. Any yoyo bought from 15 Nov onwards will attract a rebate of 12%.

Now if you need to have a database showing a particular type of yoyo with the rebate rates for a period of 1 year, you will need to show the different rebate % and the period the rate relates to.

Sounds simple but not really.....

I guess the format in this case does not really matter much as long as the result shows the different rebate percentages and what dates they are effective.

Note that the only data available is the continual update of rebate rate for the yoyo on the same sheet as the percentage changes.

Thanks in advance
 

Some videos you may like

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

Mark W.

MrExcel MVP
Joined
Feb 10, 2002
Messages
11,654
See the Excel Help topic for "View information about changes to a workbook".
 

flexinau

Board Regular
Joined
Sep 22, 2002
Messages
118
Thanks Mark, you are a champ!!!!!!!!!

Are there any limitations on this functionality other than the number of row limit??
 

Mark W.

MrExcel MVP
Joined
Feb 10, 2002
Messages
11,654
I'm not quite sure about the "limit" to which you are referring.
 

flexinau

Board Regular
Joined
Sep 22, 2002
Messages
118

ADVERTISEMENT

Thanks, the history changes should be accurate. The only issue is the archiving of it.

Have a great day....
 

flexinau

Board Regular
Joined
Sep 22, 2002
Messages
118
Mark,

Is this tracking able to be applied to track changes to results to the formulas even though the formula itself has not changed?
 

Mark W.

MrExcel MVP
Joined
Feb 10, 2002
Messages
11,654
On 2002-10-08 21:45, flexinau wrote:
Mark,

Is this tracking able to be applied to track changes to results to the formulas even though the formula itself has not changed?

It tracks changes to cell contents as a result of an edit. A cell containing a formula such as =NOW() would not be listed once the worksheet was recalculated; however, if B1 contained =A1/10 and A1 was edited then A1 would be listed.
 

Dave Patton

Well-known Member
Joined
Feb 15, 2002
Messages
4,565
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
You could assign the rebate via a Lookup
and the the Lookup table would log the changes.

=VLOOKUP(B2,dRebates,2)

dRebates Date effective Rebate %
 

Watch MrExcel Video

Forum statistics

Threads
1,122,689
Messages
5,597,559
Members
414,156
Latest member
WDMix

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top