Formula to copy date from latest update

alexoigres

Board Regular
Joined
Dec 2, 2005
Messages
184
Hi everybody,
Myabe this question is very simple but I can not make it work even with conditional formating.
I have two worksheets and in one of them I have a tracker with updates and dates: for example.... column A1 I have the number 1 column B1 Date and Column C1 I have the reason of update.
On the other worksheet I need to keep the latest date and number from colum B1

At this moment I have been updating the work sheet manually but sometimes its very complicated to remember doing it in both worksheet.
What is the easy way to keep both sheets to the latest update on the traker?
thank you
Alex
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

Forum statistics

Threads
1,224,558
Messages
6,179,512
Members
452,921
Latest member
BBQKING

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
Back
Top