Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying specific value in cell into next empty row on different sheet
There are four classes, let's say Match, Science, English & Geogrpahy.
In this workbook, there are two sheets: "Summary" and "Entry" The student would enter classes of all kinds on the "Entry" page, but I would like for the four classes above to copy automatically into the next blank cell in a specific range on the "Summary" page. The entry range would be Sheets("Entry").Range("C6:C104") The summary range would be Sheets("Summary").Range("A34:A49") Two questions about this: 1. Can this be done with an in-cell formula without a macro? 2. If not #1, then what kind of code would be needed to just copy the cell contents and not the whole cell, formatting and all? thanks to all |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying specific value in cell into next empty row on different sheet
Hi michaelberrier
For code see http://www.rondebruin.nl/copy1.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "michaelberrier" wrote in message oups.com... There are four classes, let's say Match, Science, English & Geogrpahy. In this workbook, there are two sheets: "Summary" and "Entry" The student would enter classes of all kinds on the "Entry" page, but I would like for the four classes above to copy automatically into the next blank cell in a specific range on the "Summary" page. The entry range would be Sheets("Entry").Range("C6:C104") The summary range would be Sheets("Summary").Range("A34:A49") Two questions about this: 1. Can this be done with an in-cell formula without a macro? 2. If not #1, then what kind of code would be needed to just copy the cell contents and not the whole cell, formatting and all? thanks to all |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell References | Excel Discussion (Misc queries) | |||
Ms Excel, Copying Cell to current sheet using 'Right Click' | Excel Discussion (Misc queries) | |||
copying same cell diff worksheets to new sheet | Excel Discussion (Misc queries) | |||
Clicking Cell Link Changes Cell on Another Sheet | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |