LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 364
Default Linking between worksheets

"mab1963" wrote in message
...
I have a workbook, with two worksheets, A and B, where A is a master
worksheet.
Both have the identical columns and headings.. I want the cells in
worksheet B, to equal the data entered into the cells on the master
worksheet
A. I know I need to either link or reference the two worksheets, but so
far I
am unable to figure this out.
Thanks


In sheet B you put formulas that refer to the equivalent cells in sheet A.
So, for example, in SheetB!B2 you need =SheetA!B2
You can enter this formula in one cell (B2), copy the cell and paste into
all the other cells of interest.

Hope this helps. (I do wonder, though, why do you want two identical
worksheets?)


 
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
linking across worksheets mike donnauro Excel Worksheet Functions 1 September 6th 06 10:09 PM
linking worksheets bails New Users to Excel 3 July 13th 06 07:58 PM
linking worksheets Graham7979 Excel Discussion (Misc queries) 4 May 29th 06 01:59 AM
Linking worksheets Linking Blank Cells Excel Worksheet Functions 1 November 11th 05 05:23 PM
Linking worksheets Smith Links and Linking in Excel 1 March 18th 05 07:17 AM


All times are GMT +1. The time now is 12:32 PM.

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"