Auto copying in excel

Closed
GoutamG Posts 1 Registration date Sunday August 24, 2014 Status Member Last seen August 24, 2014 - Aug 24, 2014 at 11:07 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Aug 25, 2014 at 02:41 AM
Suppose I have account in say 5 different banks and I have made one excel sheet for each showing date wise transactions. The sheet contains the following heads

Date | Bank | Particulars | Withdrawals | Income/Deposits | Balance | Details

I want, as I enter data in these sheets, can all these data get copied in one summary sheet arranged in descending order of dates?

Please suggest
Related:

1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Aug 25, 2014 at 02:41 AM
why not SORT after you enter data and when the file is saved?????
you can write EVENT CODE????????
0