Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula issues
How do you enter data, simultaneously, in two different worksheets?
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula issues
Group them first, select both worksheets, do your stuff, then ungroup them
-- Regards, Peo Sjoblom "adella40" wrote in message ... How do you enter data, simultaneously, in two different worksheets? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula issues
Select sheet1 then CTRL + Click on sheet2.
This groups them and what you do to one will be done to the other. Or, without grouping the sheets, in sheet2 in a cell enter =sheet1!A1 What you enter in A1 of sheet1 will be returned to the cell in sheet2 Gord Dibben MS Excel MVP On Fri, 4 May 2007 16:03:00 -0700, adella40 wrote: How do you enter data, simultaneously, in two different worksheets? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 formula issues | Excel Worksheet Functions | |||
Issues with my excel formula as it needs Circular reference - hlp | Excel Worksheet Functions | |||
Issues with formula not duplicating | Excel Worksheet Functions | |||
Excel formula issues, wierd.. | Excel Discussion (Misc queries) | |||
Issues with sorting | Excel Discussion (Misc queries) |