Copy/paste non-contiguous cells-but same row -- into diff wrksht,sme workbk - nxt empty row
Posted by Laura leigh on January 25, 2002 12:39 PM
I have a workbook that I am having some MAJOR work redundacnies on and I can't (for the life of me) find
out how to do this simple task.
I have a row where the last column asks a question-
answer is Y or N. If the answer is y, then I want the
code to copy the values(in the same row) from columns a, b, e, h, and l. Then paste them into sheet3.
We'll call the first worksheet: sheet1(for testing purposes). I know that using Ctrl to select non-contiguous cells in Excel - then - copying/pasting them puts them contiguously into the pasted locations. That's what I want to happen, so no prob.
It will go into the next empty row & start @ column A is fine!
Please, can anyone help?????
Thank you SO - So - SO MUCH!!