Excel Add rows automatically in excel

[DécioC]

Hey everyone, I guess I have a doubt that should be pretty simple for you guys.
Say i have a some data in sheet1, 4 columns with a independent number of rows.
On sheet2 I have a template, and I wanna have that data there too but as I dont know how many rows Im gonna need how do I import that data?
Thanks guys

 

[Becky]

I'm not sure I understand your question... could you give a little more detail please?

 

[DécioC]

I'm not sure I understand your question... could you give a little more detail please?

Sheet1 has

A B C
1 a b c
2 d e f
3 g h i

and i want it to appear on Sheet2 the same way, but when a row with new data is added to sheet1, i want it to be added to sheet2 too automaticly.
I hope it was clearer now

 

[Becky]

This is a little beyond my skills I'm afraid! I've had a quick search and found this - does this help at all?

http://answers.microsoft.com/en-us/...ange-one/4a64f964-a9a7-4ca9-b7a2-df4765b92e36