Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
linking worksheets
I am wondering how to link worksheets so that if i have a value on worksheet
1 that it will transfer to the other worksheets along with the entire row of data. For example if I have a 1 in 1a on worksheet one all of the data in row one will transfer to worksheet two. OR if i have 2 in 1a on worksheet one all of the data in row 1 will transfer to worksheet three. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
linking worksheets
Hi,
You would need to write VBA code if you want it to happen automatically. If you want help from this site you will need to provide extensive details on exactly what each sheet looks like and where you want the data to come from and got to and what you want to trigger that. And you should be prepared to start learning programming to some extent so you can maintain your code. -- Thanks, Shane Devenshire "eewalt" wrote: I am wondering how to link worksheets so that if i have a value on worksheet 1 that it will transfer to the other worksheets along with the entire row of data. For example if I have a 1 in 1a on worksheet one all of the data in row one will transfer to worksheet two. OR if i have 2 in 1a on worksheet one all of the data in row 1 will transfer to worksheet three. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
linking worksheets
Here is the basic code...
Sub CopyRow() Dim i As Integer i = Worksheets("Sheet1").Cells(1, 1).Value Sheets("Sheet1").Cells(i, 1).EntireRow.Copy Sheets(i).Activate Cells(1, 1).Select ActiveSheet.Paste End Sub -- Always provide your feedback so that others know whether the solution worked or problem still persists ... "ShaneDevenshire" wrote: Hi, You would need to write VBA code if you want it to happen automatically. If you want help from this site you will need to provide extensive details on exactly what each sheet looks like and where you want the data to come from and got to and what you want to trigger that. And you should be prepared to start learning programming to some extent so you can maintain your code. -- Thanks, Shane Devenshire "eewalt" wrote: I am wondering how to link worksheets so that if i have a value on worksheet 1 that it will transfer to the other worksheets along with the entire row of data. For example if I have a 1 in 1a on worksheet one all of the data in row one will transfer to worksheet two. OR if i have 2 in 1a on worksheet one all of the data in row 1 will transfer to worksheet three. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking 2 worksheets | Excel Discussion (Misc queries) | |||
linking worksheets | Excel Discussion (Misc queries) | |||
linking worksheets | Excel Worksheet Functions | |||
Linking worksheets | Excel Worksheet Functions | |||
Linking Worksheets | Excel Worksheet Functions |