Copy variable number of rows into another worksheet

I

ironguy

I have a list that contains two types of data. I can sort the data s
one is 'above' the other row-wise. The number of rows each type of dat
uses will vary from day to day. Is there a way to take the number o
rows (I use COUNTIF) and copy the rows to another worksheet. Basicall
I want to use the COUNTIF value as the row reference with a fixe
column reference to copy data to another worksheet
 

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

Excel 2002 copy multiple rows to another worksheet 5
Copying Formulas from One Worksheet to Another -- Very Easy Questi 3
copy worksheet 2
Copy data from one worksheet to another 2
Sort on 3 columns when number of rows vary daily 1
VBA group the number in the Column and Copy to the new worksheet. 0
How do I find and copy rows based on specific criteria? 3
How to modify a primary worksheet linked to another worksheet 7

Top