Previous Topic Next Topic

Excel 2003Advanced Filter....copy to location

Closed
amyl00 Posts 2 Registration date Wednesday 14 January 2009 Status Member Last seen 15 January 2009 - 15 Jan 2009 à 14:03
 Crazzydreamer - 19 Feb 2009 à 05:07
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!!
Related:

1 response

Réponse 1 / 1
amyl00 Posts 2 Registration date Wednesday 14 January 2009 Status Member Last seen 15 January 2009 2
15 Jan 2009 à 14:13
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?"
Crazzydreamer
19 Feb 2009 à 05:07
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!

Similar discussions

How to change Fubo location using VPN
confused -
HelpiOS -

1 response