Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Brava
 
Posts: n/a
Default Data entry in multiple worksheet

I am using Excel 2003. When I enter data in a cell on the first worksheet
it is also entered in each matching cell in all the other sheets in that
book. Any ideas.


  #2   Report Post  
Posted to microsoft.public.excel.misc
bob777
 
Posts: n/a
Default Data entry in multiple worksheet


make cell A1 in sheet 2 equal to cell A1 in sheet 1 etc etc

in sheet 2 in cell A1 =sheet1!a1


--
bob777
------------------------------------------------------------------------
bob777's Profile: http://www.excelforum.com/member.php...o&userid=28504
View this thread: http://www.excelforum.com/showthread...hreadid=508897

  #3   Report Post  
Posted to microsoft.public.excel.misc
ufo_pilot
 
Posts: n/a
Default Data entry in multiple worksheet

There may be a formula in each of the 'reading' cells or a code to copy
cells over from one worksheet to another.

"Brava" wrote:

I am using Excel 2003. When I enter data in a cell on the first worksheet
it is also entered in each matching cell in all the other sheets in that
book. Any ideas.



  #4   Report Post  
Posted to microsoft.public.excel.misc
Kevin B
 
Posts: n/a
Default Data entry in multiple worksheet

You can reference the other cells with a formula similar to the one below:

=Sheet1!A1

--
Kevin Backmann


"Brava" wrote:

I am using Excel 2003. When I enter data in a cell on the first worksheet
it is also entered in each matching cell in all the other sheets in that
book. Any ideas.



  #5   Report Post  
Posted to microsoft.public.excel.misc
flummi
 
Posts: n/a
Default Data entry in multiple worksheet


Maybe you incidentally selected all sheets.

Hans

Select sheets in a workbook

If you select more than one sheet, Microsoft Excel repeats the changes
you make to the active sheet on all other selected sheets. These
changes may replace data on other sheets.

To select Do this

A single sheet Click the sheet tab.


Two or more adjacent sheets Click the tab for the first sheet, and then
hold down SHIFT and click the tab for the last sheet.

Two or more nonadjacent sheets Click the tab for the first sheet, and
then hold down CTRL and click the tabs for the other sheets.

All sheets in a workbook Right-click a sheet tab, and then click Select
All Sheets on the shortcut menu.



  #6   Report Post  
Posted to microsoft.public.excel.misc
Brava
 
Posts: n/a
Default Data entry in multiple worksheet

Thanks for all advice Iseem to be getting it ok now I hope



"Brava" wrote in message
...
I am using Excel 2003. When I enter data in a cell on the first worksheet
it is also entered in each matching cell in all the other sheets in that
book. Any ideas.



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
external import of multiple worksheet data & create pivot table prospects Excel Worksheet Functions 0 November 3rd 05 10:27 PM
Putting data from multiple worksheets into one Teffy Excel Discussion (Misc queries) 3 July 16th 05 09:52 AM
Select rows of data in a worksheet on one criteria in multiple co MrSkoot99 Excel Worksheet Functions 5 July 11th 05 02:48 PM
Formatting a worksheet for data entry DV in Texas Excel Worksheet Functions 2 March 6th 05 08:48 PM
getting multiple data to populate another worksheet nick parker Excel Worksheet Functions 0 January 11th 05 03:59 PM


All times are GMT +1. The time now is 02:15 AM.

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

About Us

"It's about Microsoft Excel"