Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
linking cells to other sheets within a workbook
I'm trying to link/copy specific rows of data to other specific sheets within
a workbook. For example, in the main sheet, data cells entered on row 16 would be copied to the first unused row of the sheet specified by contants of row a16. Then, contents of row 17 would be transferred to first open/unused row of sheet specified by contents of cell A17. Rows transferred may /or not be to the same sheet with each transfer/copy. Can anyone help with this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
linking cells to other sheets within a workbook
To copy cells from one sheet to first unused row in another sheet you need
VBA code. See Ron de Bruin's Copy/Paste/Merge examples. http://www.rondebruin.nl/tips.htm Maybe specifically this page. http://www.rondebruin.nl/copy1.htm Gord Dibben MS Excel MVP On Wed, 11 Feb 2009 09:47:18 -0800, SPL wrote: I'm trying to link/copy specific rows of data to other specific sheets within a workbook. For example, in the main sheet, data cells entered on row 16 would be copied to the first unused row of the sheet specified by contants of row a16. Then, contents of row 17 would be transferred to first open/unused row of sheet specified by contents of cell A17. Rows transferred may /or not be to the same sheet with each transfer/copy. Can anyone help with this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking cells on different sheets within a workbook. | Excel Worksheet Functions | |||
linking sheets in the workbook and getting rid of the ZERO | Excel Discussion (Misc queries) | |||
linking sheets in a workbook | Excel Discussion (Misc queries) | |||
Linking sheets in the same workbook | Excel Worksheet Functions | |||
linking sheets in workbook | Excel Worksheet Functions |