Thread: Auto transfer of data from one sheet to another

Hi,
I have a sheet which is a expense sheet. Colum A represents name of the account Column B represents description of the transaction Column C represents Cash in Flow Column D represents Cash Out. Column E represents Balance.
For Each Name of the account there is a sheet.
I need the data in column C,D,E next to the name of account to automatically appear in the sheet representing the name of the account in next available free cell in column B.

I hope I am clear in my explanation of the above. If any questions please let me know. I really need to find out the method for the above action.

Thanks

Hi,

Thank you so much for your prompt response.

Please find attached excel sheet as an sample of what I need.

I have already transfered first data manually into the sheets of JOHN, SPENCER AND STEVE. Now I would like the data in column B, C, D to be automatically pasted in the next available row in the case of the sample workbook ROW3, COULMN A. This will make my accounting work so much automated !!

Thank You.