Copying specific value in cell into next empty row on different sheet

  • Thread starter Thread starter michaelberrier
  • Start date Start date
M

michaelberrier

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Paste to next empty cell in named range of cells 3
Summarize data from multiple sheets 2
Copying same data range to a summary sheet 8
Copying from different files into 1 1
Copy adjacent Sheet and name from a list 42
count if multiple sheets in workbook 2
#VALUE! when using defined name 3
Linking different cells from one sheet to another in same workbook 2

Back
Top