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

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