macro 4track changes between two workbook by coping changes and create history for changes

Hi to all forum contributors,

I have recently faced a problem.I have one workbook (say Entry workbook) where data is entered.I just copies the data from this into another workbook (say Report workbook).The problems now goes here,I have to copy all the data every time into 'Report' workbook whenever there is entry/changes in any cell of 'Entry Workbook'.This is my routine work.My problem is that I cannot use the track changes steps in Excel by following menu of Review tab >> Highlight changes >> Check all options.I get simply the sheet.And I have to compare the workbooks with one another and difference type in excel and I found this tedious work and sometimes copy all the data.

What I want is that I want to copy automatically by VBA/macro only those cells where any entry/changes has been made in cell/s in a workbook of 'Entry' Workbook into 'Report'workbook.I want further to know the changes made in 'Entry' Workbook into a separate sheet of 'Report' workbook.This is similar to known as history.The data is so large that I cannot see one by one as it is too time consuming and tedious work.So,I want only the changes part to be copied in one hand in a specified sheet of 'Report' Workbook and those changes only in a separate sheet to know what are the changes made.

Hope this would be enough.

With Best Rgds,

Sure.Pls find enclosed in attachment.I want to tell you again,the 'Entry'workbook I simply receive.From this workbook I have to copy exactly the same into another workbook 'Report'.Once,I can copy the whole sheet but next time,again when I receive the 'Entry'workbook but this time I cannot copy.It is so becoz there are changes in certain cells either partly cells or wholly.Hence would require those changes cells to be copied in one hand by comparing those changes from 'Entry' workbook.And the same changes to show in a separate sheet in'Report' workbook.

Kindly note, that if any changes made by me in 'Report' workbook then those changes should not be overwritten by 'Entry' workbook data.

In otherwords,I want to update the Report workbooks from Entry Workbook.And those updated figure to be shown as history in a separate sheet in 'Report' workbook.If you see both the workbooks, the format are same.Only input cells changes are required to copied

Hope you have understood.

If any further info if you require then do let me know.

With Best Rgds