Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking cell A in sheet 1 with several cells in sheet 2
I've got 2 spreadsheets and I wish to link both spreadsheets this way,
1. Cell A belongs to spreadsheet 1 2. The data in Cell A changes daily 3. I wish to import the data in Cell A into spreadsheet 2 daily Today I key in the number "1" into Cell A, the number "1" is also shown in spreadsheet 2 row 10. Tomorrow I delete the number 1 in Cell A and key in a number "2", I want to have the number "2" shown in row 11 of spreadsheet 2, without affecting row 10 How can I do that? Thank You so much :) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking cell A in sheet 1 with several cells in sheet 2
Copy/paste the following code to the code section of your input worksheet:
Private Sub Worksheet_Change(ByVal Target As Range) Dim c As Range ' A1 is your input cell - change to suit If Target.Address = "$A$1" Then ' Mylist is your destination range - change name to suit For Each c In Application.Range("Mylist") If c.Value = "" Then Application.EnableEvents = False c.Value = Target.Value Application.EnableEvents = True Exit For End If Next c End If End Sub This should work Kathrine "o0KelviN0o" wrote: I've got 2 spreadsheets and I wish to link both spreadsheets this way, 1. Cell A belongs to spreadsheet 1 2. The data in Cell A changes daily 3. I wish to import the data in Cell A into spreadsheet 2 daily Today I key in the number "1" into Cell A, the number "1" is also shown in spreadsheet 2 row 10. Tomorrow I delete the number 1 in Cell A and key in a number "2", I want to have the number "2" shown in row 11 of spreadsheet 2, without affecting row 10 How can I do that? Thank You so much :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Button linking to another cell and sheet | Links and Linking in Excel | |||
Linking Cells to different sheet | Excel Discussion (Misc queries) | |||
Linking cells with a diffrent sheet with 2 cells | Excel Worksheet Functions | |||
Linking a dinamic cell value from one sheet to another | Excel Discussion (Misc queries) | |||
linking of outside charts to each cell in the sheet | Charts and Charting in Excel |