K
Kanmi
I have a Workbook link to the database, Anytime changes made in the database
and when i open the workbook then there are Automatic update on the
worksheet."sheet1" I'm looking for a way to be able to know the new changes
either by changing font, colour or any other ways to know this is new data
added to the pages or editing. For example
First Name Last Name ID Hire Date Title
Jeff Dell 001 06/25/2009 Manager
Larry Lus 002 01/20/2009 Supervisor
Colls Ref 003 02/02/2009 Sales Rep
IF MANAGER
First Name Last Name ID Hire Date Title
Jeff Dell 001 06/25/2009 Manager
(CHANGE) TO MD
First Name Last Name ID Hire Date Title
Jeff Dell 001 06/25/2009 MD
AND NEW STAFFN WAS ADDED
First Name Last Name ID Hire Date Title
Jeff Dell 001 06/25/2009 MD
Larry Lus 002 01/20/2009 Supervisor
Colls Ref 003 02/02/2009 Sales Rep
HUB CLINTON 004 07/12/2010 General Manager.
I want know these changes by showing/appear different from the rest of the
data. Please can anybody help me. Thanks and Appreciate your time.
and when i open the workbook then there are Automatic update on the
worksheet."sheet1" I'm looking for a way to be able to know the new changes
either by changing font, colour or any other ways to know this is new data
added to the pages or editing. For example
First Name Last Name ID Hire Date Title
Jeff Dell 001 06/25/2009 Manager
Larry Lus 002 01/20/2009 Supervisor
Colls Ref 003 02/02/2009 Sales Rep
IF MANAGER
First Name Last Name ID Hire Date Title
Jeff Dell 001 06/25/2009 Manager
(CHANGE) TO MD
First Name Last Name ID Hire Date Title
Jeff Dell 001 06/25/2009 MD
AND NEW STAFFN WAS ADDED
First Name Last Name ID Hire Date Title
Jeff Dell 001 06/25/2009 MD
Larry Lus 002 01/20/2009 Supervisor
Colls Ref 003 02/02/2009 Sales Rep
HUB CLINTON 004 07/12/2010 General Manager.
I want know these changes by showing/appear different from the rest of the
data. Please can anybody help me. Thanks and Appreciate your time.