what criteria needed to copy non blank cells to another location?

J

jill.mullen

I am trying to collate multiple worksheets to a single master sheet. then
e-mail all non blank cells ? I have managed to collate, but can't sort a
criteria to copy all non blank cells to a new location to then e-mail
HELP

and I AM A NEWBIE ON EXcel........................ so assume I know nothing!
thanks
 

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 Portions of Data 0
Return Each Last Non-blank Cell, Value 2 Column Offset, Many GAPS 1
Conditional formatting/non blank cells 4
Can't save my Office documents (after computer rebuild and reauthorization) 0
Next-To-Last, Non-Blank, Rightmost Value in a Row 6
If function across sheets prints value of cell 4
Return last non-blank cell in column 3
Need Array Formula for Counting Blank & Non Blank Cells (Multiple Criteria) 3

Top