Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have the following statements in a VBA procedu
rcount9 = Application.WorksheetFunction.CountA(Worksheets("w orking data").Range("A1:A65536")) Worksheets("working data").Range("A1:K" & rcount9).AdvancedFilter _ Action:=xlFilterCopy, _ CriteriaRange:=Range("K1:K2"), _ copytorange:=Worksheets("Items not in F4106").Range("A1:K" & rcount9) Is there an easy way to then take the data that this advanced filter just copied to the "Items not in F4106" workbook and delete them from their original location in the "working data" workbook ? Both workbooks are in the same Excel spreadsheet file. Thanks ! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Just a quick thank | Excel Programming | |||
Quick question - quick answer about assigning shortcut keys | Excel Programming | |||
HELP QUICK I NEED TO KNOW HOW TO ... | Excel Discussion (Misc queries) | |||
NEED HELP QUICK AGAIN! | Excel Discussion (Misc queries) | |||
Quick VB Help | Excel Programming |