Moving only certain cells to another worksheet.

  • Thread starter Thread starter beverly
  • Start date Start date
B

beverly

Can someone tell me how to move certain cells from
workbook to another. Let me explain. I have a workbook
that I am using to generate progress reports for school.
I want to record their homework. If a students misses a
homework assignment I was going to put an x in the cell
for them. If they did the homework, I was going to leave
it blank. Now, I want to move only those cells with the
x from that workbook into another workbook. Can anyone
help. If you can please send response to
(e-mail address removed)
 
Hi

The easiest way would be to filter your list after entering the data. Use
Data / Filter / AutoFilter to select x in the required column. You can then
select these (with Ctrl Shift 8) and copy/paste them into another sheet.
 

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

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel Protection 2
automatic move row from sheet to another 1
Excel Move or Copy Stopped Working? 0
YTD total and YTD commission 0
move worksheet to end of another workbook 3
Copy cells in Excel 1
Transfer data from a cell to another workbook if certain criteria 14

Back
Top