Data Transfer from Sheet 1 to Sheet 2

[slackerzkiddo]

Hello everyone,

I'm currently doing some statistics for my Manager and I would like to request for some help. I'm not totally new to excel but i'm not good at it .

I would like to ask if it is possible to automatically transfer what i type in Sheet 1 to Sheet 2 ?

i.e I type "ABC" on cell A1 on sheet 1, "ABC" will automatically on cell A1 on sheet 2.

do i need Macro/VBA to make do this ? If so, can someone explain to me how ?

Thanks.

Daniel

[:) Sixthsense :)]

Do right click on Sheet1 Sheet Tab and select View Code and copy and paste the below code

Please Login or Register  to view this content.

Return to excel and make changes in sheet1.

[slackerzkiddo]

Thanks so much for helping.

Manage to resolve it.