Automatically copy data to another file or worksheet.

[ghaxnavi]

Hi guys,

Got situation which I cant solve on my own. I got a General Accounts Ledger and a Cashbook, both separate files. General Ledger has multiple worksheet assigned to specific Account. What I am trying to do is that if I enter data into Cashbook, it should automatically be copied to the respective account in General Ledger. I know how to link a cell to another cell in different worksheet or file but the problem is that I cant assign any cell in Cashbook as there will be no sequence of entries there.

For example in Cashbook the first entry is of Advance Account and second entry is of Salary Account. They should automatically go to their respective worksheets in General Ledger workbook. Data column and rows are identical in both workbooks. I am just trying to avoid re-enter every entry in both files.

As far as I know Excel, I think there should be unique identifier for each entry in Cashbook which can be used to distribute data to different worksheets in General Ledger. I just dont know how to do it

Attaching both files for reference.

And pardon me if I didnt make myself clear.