Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking between worksheets
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking between worksheets
The reference, if on sheet 1, cell a1 would look like the following:
=Sheet1!A1 However, you can keyboard & click your way to the formula. Move the cell that you want to place the formula in. Type an = sign to start the formula. Press <PgUp to move the sheet 1 and click on the cell you wish to reference. copy the formula down the column as far as necessary. Repeat as needed for additional rows or columns. -- Kevin Backmann "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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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?) |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking between worksheets
Hi Stephen, these are test cases for software apps. each worksheet
corresponds to a specific machine we test on, but the test cases are identical. I could have 5 machines under test, thus 5 worksheets, plus the master. The test cases are a series of steps to follow and will be identical for all the machines. For example in columns a thru f, I want those test cases/steps identical on the other worksheets. There will be an additional column on the other worksheets, which we record results, but these need to be specific to that machine, so I wouldnt want any data from other worksheets to get referenced. .. "Stephen" wrote: "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?) |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking between worksheets
The general method(s) given by myself, Kevin B and Stephen should work for
you. Just set up the formulas for data entry and calculations individually. Actually, there is probably a better way. Set up sheet A exactly the way you want it to be set up, including formulas for cells on that sheet. Then: Right-click on the sheet's name tab and choose Move or Copy Pick a place to put the copy of the sheet and be sure and check the Make Copy option and click OK. Sheet A will be duplicated and you can give it a new sheet name. Repeat for as many sheets as you need. Each of the copies will be independent of the others when it is all done. However, changes in instructions made on one will NOT be updated on the others, but there's a way around that also! To make a change in the same cell or group of cells on all sheets in a workbook: click the first sheet to make the change to, then hold down the [Ctrl] key and click the name tabs of any other sheets that you want the same change applied to. When you have all the sheets you want changed selected (grouped) make the change(s) - whatever you do to one while they are grouped will be done to all of them. Be sure to ungroup them when you have finished making your changes. "mab1963" wrote: Hi Stephen, these are test cases for software apps. each worksheet corresponds to a specific machine we test on, but the test cases are identical. I could have 5 machines under test, thus 5 worksheets, plus the master. The test cases are a series of steps to follow and will be identical for all the machines. For example in columns a thru f, I want those test cases/steps identical on the other worksheets. There will be an additional column on the other worksheets, which we record results, but these need to be specific to that machine, so I wouldnt want any data from other worksheets to get referenced. . "Stephen" wrote: "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?) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
linking across worksheets | Excel Worksheet Functions | |||
linking worksheets | New Users to Excel | |||
linking worksheets | Excel Discussion (Misc queries) | |||
Linking worksheets | Excel Worksheet Functions | |||
Linking worksheets | Links and Linking in Excel |