Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 2
Default Automatically copying data 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  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 621
Default Automatically copying data from sheet1 to sheet2

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

On Sun, 29 Apr 2012 19:09:27 +0000, Ria Ray
wrote:


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")

  #3   Report Post  
Senior Member
 
Location: Belo Horizonte, Brazil
Posts: 170
Thumbs up

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 Morning.

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

I believe that the answer will help you definitely.
__________________
I hope it can help you.

Best regards,
Marcilio Lobão
---------------------------
Belo Horizonte, Brazil
  #4   Report Post  
Junior Member
 
Posts: 2
Default

Dear Gord,

Is there an easy way to have each cell of Sheet1 transferred to each individual cell in Sheet2 without having to retype the formula in each cell of Sheet2?

For example, if I want all of Column A and all of Column B to have the same content in both sheets 1 and 2, how can I do this without having to change the cell number in the formula each time?


Quote:
Originally Posted by Gord Dibben[_2_] View Post
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

On Sun, 29 Apr 2012 19:09:27 +0000, Ria Ray
wrote:


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")
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Automatically copying data from sheet1 to sheet2

I work on excel sheet for my daily records like sheet 1

date items client price amount terms

I want to see on sheet 2 by only one item particular with qty
What formula can be put


  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Automatically copying data from sheet1 to sheet2

As I am selling surf soap oil water cream etc etc
On other sheet I want to see water in jan with qty and price and cost

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
Copy data automatically from sheet1 to sheet2 Ria Ray New Users to Excel 1 May 4th 12 07:58 PM
Copying data from Sheet1 which is on multiple rows for each customerto Sheet2 on single row. u473 Excel Programming 2 November 3rd 09 06:33 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
A1 Sheet2 is linked to A1 sheet1 so that user enters value(abc123) a1 sheet1 and A1 sheet2 is updated pano[_3_] Excel Programming 2 October 28th 07 03:32 PM
copying data from sheet1 to sheet2 Rookie Excel Worksheet Functions 3 September 7th 06 12:09 PM


All times are GMT +1. The time now is 10:35 AM.

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

About Us

"It's about Microsoft Excel"