Copy visible cells after filtered paste to first empty cell

X

Xrull

I need a vba code that will enable me to copy only the filtered cells in a
range of 4 columns on Sheet1, and paste it to the first empty cell on Sheet2.
Eg. Filter Column A to D on Sheet1, then copy only the visible cells, and
paste the range to, starting from say Column A1 to D1 on Sheet2; filter
Sheet1 again, and paste the visible cells starting where the last paste
ended. It would be nice if I could leave it to run until it ends. To manually
cut and paste these visible cells take me about 2 hrs.
I searched for a macro, but none I've seen were suitable.
 
D

Don Guillett

Easy with a looping macro using
dlr=sheets("desinationsheet").cells(rows.count,"d").end(xlup).row+1

If all else fails, send your workbook to my address below with snippets of
this and a detailed explanation of what you desire.
 

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

Copy Visible Cells and paste in another workbook visible cells only 5
loop to copy paste 5
How to copy several nonajacent cells and paste to ajacent cells in one row 7
Copy columns and paste with blank column between 5
How to copy and paste only visible cells from Excel using vbscript 0
VBA set thick borders around non empty cells in range 0
Copy Paste all data tough filtered 3
loop to copy paste 3

Top