Automatically copying data from sheet1 to sheet2

[Ria Ray]

Hello!
I am new to Excel and am stuck with an issue. I will be thankful if an
one could shine some light on the issue.

I have 2 excel sheets: sheet1 : sheet2
Sheet1 has A,B,C,D,E columns with data in them
Sheet2 had A,E,B columns with no data... (sheet2 columns are in th
order A,E,B)

Now, when the data is entered in sheet1.....sheet2 has to automaticall
get filled with the respective columns(A,E,B) from sheet1..... How to
do that...... there are two things which arise here.......one:th
already existing data should b filled in to the second sheet..... two
any modifications or changes made to sheet1 should reflect in sheet2 fo
the columns(A,E,B)........ and also on sheet2, the column has to b
grouped according to the column E (lets say that column E has go
"usernames".....then all the records on sheet2 has to be groupe
according the the "usernames"

 

[Gord Dibben]

You can create links on Sheet2 back to cells on Sheet1

In A1 of Sheet2 enter =Sheet1!A1 or in E1 enter =Sheet1!E1

Same type of linked formula for other columns from Sheet1 to Sheet2.

Note these can be drag/copied to fill other cells.


Gord

 

[Mazzaropi]

Hello!
I am new to Excel and am stuck with an issue. I will be thankful if an
one could shine some light on the issue.
I have 2 excel sheets: sheet1 : sheet2
Sheet1 has A,B,C,D,E columns with data in them
Sheet2 had A,E,B columns with no data... (sheet2 columns are in th
order A,E,B)
Now, when the data is entered in sheet1.....sheet2 has to automaticall
get filled with the respective columns(A,E,B) from sheet1..... How to
do that...... there are two things which arise here.......one:th
already existing data should b filled in to the second sheet..... two
any modifications or changes made to sheet1 should reflect in sheet2 fo
the columns(A,E,B)........ and also on sheet2, the column has to b
grouped according to the column E (lets say that column E has go
"usernames".....then all the records on sheet2 has to be groupe
according the the "usernames")

Dear *Ria Ray*, Good Morning.

Why not to put here your worksheet in attach, as example, to easier ou
answer to you?

I believe that the answer will help you definitely