| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ENTER DATA INTO 2 CELLS AT THE SAME TIME
I would like to be able to enter data on sheet 1, and also into another cell
on a different sheet with a different layout at the same time. Is this possible? I am not too good on excel so step by step guide for idiots would be appreciated. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
ENTER DATA INTO 2 CELLS AT THE SAME TIME
Maybe just reference it
in sheet 1A1 you will enter the value In Sheet2B4 enter this =Sheet1!A1 Nopw sheet2B4 will always change when you change SHeet1A1 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
ENTER DATA INTO 2 CELLS AT THE SAME TIME
You could do it with a link =sheet2!a2 or a worksheet_change event macro.
-- Don Guillett SalesAid Software "Alan" wrote in message ... I would like to be able to enter data on sheet 1, and also into another cell on a different sheet with a different layout at the same time. Is this possible? I am not too good on excel so step by step guide for idiots would be appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formulas won't enter into cells in Excel 2000 only as useless data | Excel Worksheet Functions | |||
| Convert data into standard military time format | Excel Discussion (Misc queries) | |||
| HOW DO I ENTER SAME DATA IN EACH CALENDAR DAY AT SAME TIME? | Excel Discussion (Misc queries) | |||
| trying to create an (almost) circular formula between cells and data validated cells with lists | Excel Worksheet Functions | |||
| Excel - cursor moves to other cells after I enter data, without h. | Excel Discussion (Misc queries) | |||
Linear Mode
