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!!
Configuration: Windows XP Internet Explorer 6.0
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:
|
C sharp excel read sheet copy cells Excel advanced filter not working Excel auto filter does not work Excel formula filter blank values Excel formula to copy from one sheet to the next Excel formula to copy value until another value is found Excel freezes when copying cells Excel how to copy formula to a different worksheet Excel macro 2007 copy sheet Excel macro filter rows value Excel macro filter then copy to new worksheet Excel macro put copy data into a variable Excel macro to copy data then close file and paste into other file Excel macro to copy the contents of another workbook to current workbook Excel macro vba copy based on column value tutorial Excel vba hiperlinks copy cell Filter excel file and copy paste new file Vba excel 2007 disable "copy sheet"