Copy data automatically from sheet1 to sheet2

R

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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top