Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW ENTER DATA IN DIFFERENT WORKSHEET IN DIFFERENT CELL SAMETIME
I want to enter the same data in different worksheet and in different cell at
the same time.. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW ENTER DATA IN DIFFERENT WORKSHEET IN DIFFERENT CELL SAMETIME
Hi,
Select your cell in the 'different' workbook and type = navigate to your first workbook where you will enter the data and select the approriate cell. Press the green tick Mike "Sheshmani I. Pandey" wrote: I want to enter the same data in different worksheet and in different cell at the same time.. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW ENTER DATA IN DIFFERENT WORKSHEET IN DIFFERENT CELL SAMETIME
Either use a link or:
Private Sub Worksheet_Change(ByVal Target As Range) Set r1 = Range("A1") If Intersect(Target, r1) Is Nothing Then Exit Sub r1.Copy Sheets("Sheet2").Range("B2") End Sub Will automatically copy data entered in cell A1 to Sheet2 cell B2 -- Gary''s Student - gsnu200732 "Sheshmani I. Pandey" wrote: I want to enter the same data in different worksheet and in different cell at the same time.. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to enter new data in worksheet | Excel Discussion (Misc queries) | |||
Auto enter date when data in enter in another cell | Excel Worksheet Functions | |||
cannot enter data in existing worksheet | Excel Discussion (Misc queries) | |||
How do to enter data in a combo box on a worksheet? | Excel Discussion (Misc queries) | |||
AUTOMATICALLY ENTER DATA FROM ONE WORKSHEET TO ANOTHER | Excel Worksheet Functions |