Click here to Skip to main content
15,883,705 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
See more:
Hi friends,

I have a little problem with excel. Does any one can help me in that way.
I have two sheets in excel and I want automaticlly what i write to first sheet to transfer to another sheet.... e.x

sheet one

Name Surname Age
Alan Ray 39
Tracy Gryes 34


and sheet to automatically should get the data from sheet one...


Thnx.
Posted

You can copy the worksheet[^].
 
Share this answer
 
You can put formulas in the second sheet. Or you can use VBA's Union property. The first is simplest. The second will increase your knowledge.
 
Share this answer
 
Comments
Alushi 23-Apr-13 12:58pm    
The main problem is to that formula.... and for that I need some help... if u can ?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900