Excel 2003Advanced Filter....copy to location

[Closed]
Report
Posts
2
Registration date
Wednesday January 14, 2009
Status
Member
Last seen
January 15, 2009
-
 Crazzydreamer -
Hello,
I am trying to use the Advanced filter...and copy the info to different worksheet.
It's not working out for me :(

I have been trying to do this for about 3 weeks now........
I clicked on the the Advanced Filter on the worksheet that I want the info to copy to titled "Completed"
I highlighted my database on worksheet titled "Sheet 1"




Looks like this
List Range Sheet 1'!$D:$E$A$1:$G$2
Criteria Range 'Sheet 1'!$I$5:$J$6
Copy To: 'Completed'$A$2:$G$2

I either get the "extract range" error or nothing at all happens. Please help!!

1 reply

Posts
2
Registration date
Wednesday January 14, 2009
Status
Member
Last seen
January 15, 2009
2
I was just trying to play with this again. Using the same above info...I changed the Copy To destination to Completed!$C$2:$D$40 and I get this error message:

"The destination range is not large enough to accommodate all copies rows. Data below the destination range will be lost. Continue copying anyway?"
2
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month


The best thing to do is to use the advance filter and copy the information to a cell on the same spreadsheet. You should then be able to cut and paste this data to your Completed sheet. Seem the long way round but it works!