Advanced Filter Macro

  • Thread starter Thread starter Alex.W
  • Start date Start date
A

Alex.W

Spreadsheet "Register" has columns A to Q of data. I want to move all data in
rows where there is an entry in the corresponding cell in column "P".

I want to move the data to Spreadsheet "Closed". Both spreadsheets are set
up identically for columns and headings.

Rather than paste over existing data in "Closed", I want it to be pasted
from the next vacant row down.
 
Why not record a macro when you use Data|Filter|Autofilter.

You can filter to show the nonblanks, then copy the visible rows (avoiding the
header) and past under the last used row.
 

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

Macro - Copy row base on criteria 3
pasting with filter results into sequentual cells not same row? 1
SUBTOTAL not refreshing when using advanced filter 2
move a row of data values to a column in sorted order 2
Appending Data from one spreadsheet to another 4
Macro to add data 3
Excel: keeping rows together when ordering order of left column 1
Copy/Paste with Hidden Rows/Columns Excel 2007 3

Back
Top