| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
linking data between sheets
I'm trying to link/copy specific rows of data to specific sheets from a main
worksheet. For example, row 16 of the main sheet would be copied to the first unused row of the sheet specified by the contents of cell A16 of the main sheet. Contents of row 17 of the main sheet would be copied to the first unused row of the sheet specified by the contents of cell A17 of the main sheet. Can you suggest a method to do this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
linking data between sheets
Hi,
If you mean copy, then there is no function to do this automatically, you will need to write a VBA program. If you mean link then you might create a rather complex formula to do it. But you need to decide exactly what you want and you need to tell us how the program should decide what sheet to copy or link to. What is in A17 that clues us in? -- If this helps, please click the Yes button Cheers, Shane Devenshire "SPL" wrote: I'm trying to link/copy specific rows of data to specific sheets from a main worksheet. For example, row 16 of the main sheet would be copied to the first unused row of the sheet specified by the contents of cell A16 of the main sheet. Contents of row 17 of the main sheet would be copied to the first unused row of the sheet specified by the contents of cell A17 of the main sheet. Can you suggest a method to do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| linking data to specific sheets | Excel Discussion (Misc queries) | |||
| Linking data in workbook to its sheets | Excel Worksheet Functions | |||
| linking data between sheets using drop down list | Excel Worksheet Functions | |||
| linking selected data between Excell sheets | Excel Discussion (Misc queries) | |||
| Linking sheets when sorting row and column data | Excel Worksheet Functions | |||
Hybrid Mode
