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

Here's the easy way:
Go to sheet B, click in cell A1 (I'm assuming your information on the A
sheet starts in A1). Type in an = symbol into sheet B, cell A1

Choose the A sheet, click in cell A1 and press the [Enter] key.

You've just linked sheet B, cell A1 to sheet A, cell A1.

If you look at the formula in sheet B, cell A1, you will see something like
=A!$A$1
where "A" is the sheet name

If you will edit this and delete the $ symbols in the formula, you can then
fill to the left and then down the sheet to automatically pick up all values
from sheet A. To find out more about how to fill, use Excel Help and search
for

Fill Data in worksheet cells

and you will get detailed instructions on several ways to do it.

"mab1963" wrote:

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

 
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 11:13 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"