hi, I am trying to copy from one sheet to another sheet , but I dun not wan to new sheet to contain the empty cells over.
for example , copy those column A and B to sheet2 ,but without those empty rows
hi, I am trying to copy from one sheet to another sheet , but I dun not wan to new sheet to contain the empty cells over.
for example , copy those column A and B to sheet2 ,but without those empty rows
1. Select the entire data range ie A1:B30
2. Go Data>Filter>Autofilter
3. in the A1 dropdown select non-blanks
4. Select the range of values and go Edit>Copy and swicth to Sheet2 and go Edit>Pastespecial>Values.
Richard
Richard Schollar
Microsoft MVP - Excel
hmm that will works, but I would like it if can copy using formula.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks