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
|