ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Copy data automatically from sheet1 to sheet2 (https://www.excelbanter.com/new-users-excel/445917-copy-data-automatically-sheet1-sheet2.html)

Ria Ray April 29th 12 03:10 AM

Copy data automatically from sheet1 to sheet2
 
Hello!
I am new to Excel and am stuck with an issue. I will be thankful if any 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 the order A,E,B)

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

Mazzaropi May 4th 12 07:58 PM

Quote:

Originally Posted by Ria Ray (Post 1601301)
Hello!
I am new to Excel and am stuck with an issue. I will be thankful if any 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 the order A,E,B)
Now, when the data is entered in sheet1.....sheet2 has to automatically get filled with the respective columns(A,E,B) from sheet1..... How to I do that...... there are two things which arise here.......one:the already existing data should b filled in to the second sheet..... two: any modifications or changes made to sheet1 should reflect in sheet2 for the columns(A,E,B)........ and also on sheet2, the column has to be grouped according to the column E (lets say that column E has got "usernames".....then all the records on sheet2 has to be grouped according the the "usernames")

Dear Ria Ray, Good Afternoon.

Please, attach a example worksheet here to easier the understanding.

Fill there an example on how do you want the answer at Sheet 2.

I believe that doing this way you will receive a good answer quicker


All times are GMT +1. The time now is 08:28 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
ExcelBanter.com