Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Inputting data into two worksheets

I want to input data into worksheet 1 in cell a1 and i also want the same
data to go into worksheet 2 but in cell a2. i would also like any other data
inputted to go across automatically eg sheet 1 a1 into sheet 2 a2, then sheet
1 b1 into b2 and so on. any ideas would be greatly appreciated.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,339
Default Inputting data into two worksheets

in sheet2 a2:

=Sheet1A1

copy across (and down) as required

"4762nicho" wrote:

I want to input data into worksheet 1 in cell a1 and i also want the same
data to go into worksheet 2 but in cell a2. i would also like any other data
inputted to go across automatically eg sheet 1 a1 into sheet 2 a2, then sheet
1 b1 into b2 and so on. any ideas would be greatly appreciated.

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,339
Default Inputting data into two worksheets

Typo ....

In Sheet2 ..

A2: =Sheet1!A1

"4762nicho" wrote:

I want to input data into worksheet 1 in cell a1 and i also want the same
data to go into worksheet 2 but in cell a2. i would also like any other data
inputted to go across automatically eg sheet 1 a1 into sheet 2 a2, then sheet
1 b1 into b2 and so on. any ideas would be greatly appreciated.

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Inputting data into two worksheets

thank you that was much appreciated that has just halved my work

"Toppers" wrote:

Typo ....

In Sheet2 ..

A2: =Sheet1!A1

"4762nicho" wrote:

I want to input data into worksheet 1 in cell a1 and i also want the same
data to go into worksheet 2 but in cell a2. i would also like any other data
inputted to go across automatically eg sheet 1 a1 into sheet 2 a2, then sheet
1 b1 into b2 and so on. any ideas would be greatly appreciated.

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
Inputting data to one worksheet for it effect another daedalus1 Excel Discussion (Misc queries) 1 June 25th 06 04:39 PM
inputting data Shanor Excel Discussion (Misc queries) 0 June 15th 06 10:50 AM
Update a chart immediately after inputting data into data source MELMEL Charts and Charting in Excel 1 December 1st 05 10:34 PM
Entries disappear after inputting data Mel Excel Discussion (Misc queries) 1 August 8th 05 03:29 PM
Inputting Source Data - help please foredis Charts and Charting in Excel 1 June 22nd 05 02:36 PM


All times are GMT +1. The time now is 07:14 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"