Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel wont let me create a formula between worksheets
I am using a spreadsheet that has mutiple worksheets. I want to copy some
information already in cell A1 on sheet 1 to cell B2 on sheet 2. I therefore create a formula Cell B2 in sheet 2 that states '+sheet1!A1'. This is achieved pushing the + sign in cell b2 on sheet 2 and then clicking on cell A1 in sheet 1. As is normal the cell A1 is highlighted by a flashing dotted line. However when I press enter a circular reference is created, the tab at the bottom goes clear and sheet one is placed into a frame. On sheet 1 the formula that I wnated on sheet 2 cell B2 now appears in the cell b2 on sheet 1. In Cell B2 Sheet2 it remains blank and a cisculer reference is created. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel wont let me create a formula between worksheets
I think you need a "=" instead of the "+".
NickHK "fiolexem" wrote in message ... I am using a spreadsheet that has mutiple worksheets. I want to copy some information already in cell A1 on sheet 1 to cell B2 on sheet 2. I therefore create a formula Cell B2 in sheet 2 that states '+sheet1!A1'. This is achieved pushing the + sign in cell b2 on sheet 2 and then clicking on cell A1 in sheet 1. As is normal the cell A1 is highlighted by a flashing dotted line. However when I press enter a circular reference is created, the tab at the bottom goes clear and sheet one is placed into a frame. On sheet 1 the formula that I wnated on sheet 2 cell B2 now appears in the cell b2 on sheet 1. In Cell B2 Sheet2 it remains blank and a cisculer reference is created. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel wont let me create a formula between worksheets
Hi fiolexem
Select B2 in sheet2 hit + (you can use =; + or -) With mouse select sheet1 tab (both sheets are now selected but sheet1 is Bold) Select cell A1 (in formulaline you have now: =+Sheet1!A1) Enter (back to sheet2 below cell B2, depending on your "move selection after Enter") -- Best Regards Joergen Bondesen "fiolexem" wrote in message ... I am using a spreadsheet that has mutiple worksheets. I want to copy some information already in cell A1 on sheet 1 to cell B2 on sheet 2. I therefore create a formula Cell B2 in sheet 2 that states '+sheet1!A1'. This is achieved pushing the + sign in cell b2 on sheet 2 and then clicking on cell A1 in sheet 1. As is normal the cell A1 is highlighted by a flashing dotted line. However when I press enter a circular reference is created, the tab at the bottom goes clear and sheet one is placed into a frame. On sheet 1 the formula that I wnated on sheet 2 cell B2 now appears in the cell b2 on sheet 1. In Cell B2 Sheet2 it remains blank and a cisculer reference is created. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create a formula in a worksheet that links two other worksheets | Excel Worksheet Functions | |||
How use info in Excel shared worksheets to create new worksheets | Excel Worksheet Functions | |||
Date format from excel to CVS file wont. Change in CVS wont stay. | Excel Worksheet Functions | |||
How do I create a formula using cells from multiple worksheets? | Excel Worksheet Functions | |||
excel 2000 wont let me create chart | Charts and Charting in Excel |