Hi there. I'm hoping someone can help me with this problem. I can'
figure it out.

I have 3 spreadsheets, sheet A, sheet B and sheet C. I have used
filter on A, and now some rows are visible and some aren't. I woul
like to be able to copy the rows corresponding to the ones showing i
sheet A, from B to C. That is, if only rows 3 and 5 are showing in A
i would like to copy rows 3 and 5 of B to C. Or, i could make sheet
show the same rows as A, so that only rows 3 and 5 are showing. Bu
sheet B does not have the same information as A, so i can't just run
filter on it.

I have found ways to do the copying, but they involve straight copyin
and pasting of the rows, and each sheet has thousands or rows, so thi
takes too long, and made Excel crash once because of memor
constraints.

I'm not sure if i'm explaining my problem clearly. Please help!

thanks

--
Message posted from http://www.ExcelForum.com