How to copy without copying

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Here is the deal - In a wookbook, I have a worksheet with 30 colums and 1000
roows, and the number of rows grow each day. I need to build additional
worksheets that will conditionally populate based on criteria.

For example, on the master sheet, there may be a number of rows that all
have an entry, "active", in one column. I want all of those rows to populate
in the second sheet (without blank rows), where I can build a pivot table or
add custom filters.

Ideas?
 
You could use autofilter, filter on active and select the values, (select the
range, press F5, click special and select visible cells), and then copy and
paste it. You could also automate this using a macro

Regards,

Peo Sjoblom
 
You must log in or register to reply here.

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 subrange without macros 5
Excel 2003 Macro - Finding rows with data to copy 1
Formula Copying 1
Copying info from worksheet to worksheet if info matches 2
Main Form - copy exact data from multiple worksheets with live lin 1
Finding and copying whole rows 1
COPY RIGHT AND TRANSPOSE 2
Function or Formula help - get data from another sheet 10

Back
Top