Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 29th 12, 03:10 AM
Junior Member
 
First recorded activity by ExcelBanter: Apr 2012
Posts: 2
Default 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")

  #2   Report Post  
Old May 4th 12, 07:58 PM
Senior Member
 
First recorded activity by ExcelBanter: Jul 2010
Location: Belo Horizonte, Brazil
Posts: 170
Exclamation

Quote:
Originally Posted by Ria Ray View Post
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
__________________
I hope it can help you.

Best regards,
Marcilio Lob„o
---------------------------
Belo Horizonte, Brazil


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to copy row data from Sheet2 to Sheet1 based on Conditional Date John Lauer Excel Programming 2 June 22nd 11 04:13 PM
copy data from sheet2 to sheet1 when sheet2 has variable # of rows Anne Excel Discussion (Misc queries) 6 February 27th 09 10:48 PM
To copy data from Sheet2 to Sheet1 in Excel using VB.net [email protected] Excel Programming 0 July 21st 06 08:08 PM
copy data from sheet1 based on criteria in sheet2 to sheet3 Fred Excel Programming 3 May 25th 04 01:46 PM
Copy Data (Sheet2 to Sheet1) Updates Web Query JStone0218 Excel Programming 0 October 9th 03 02:07 AM


All times are GMT +1. The time now is 05:34 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright ©2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017