Copying text from multiple cells.

S

Spearhead

I have a seven spreadsheets (by day of the week and one consolidated sheet)
that keeps track of how many hours a student misses in a week. Calulating the
time on a consolidation sheet is no problem. I am trying to combine any
Text (reason for absents) into one cell for that student on the consolidated
sheet that would show one reason after the other with a comma seperation.

can anyone help???
 

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

Copying Cell from Multiple Worksheets to a Summary Worksheet 4
Matching 2 Text fields 3
sumif across multiple sheets in excel 2007 based on a condition 7
Adding same cells across multiple worksheets 2
complicated drop down menu question 1
Selecting data from multiple worksheets 5
search and copy text from one sheet to others 4
I want to tally my sheet 6

Top