I am getting Run Time Error '9'Subscript out of Range
http://wikisend.com/download/296926/PEPSI VOLUME 1Q13.xlsx I copy a COF to Worksheet tab if there is an X in Column 'I' I would like the data to move to DrPepper Worksheet and be deleted from Worksheet tab Thank You!
File ID Number 48966 http://wikisend.com/download/489916/PEPSI VOLUME 1Q13.xlsx
I hate to bother you again but, the macro is moving all Rows from 'data sheet' with X in column I to the Dr Pepper sheet. What I need it to do is... when I paste a certain COF in the 'worksheet tab' for those rows on the 'worksheet tab' with X in column I to move to DrPepper sheet. Thank you so much for your help
I'm still having trouble. For example, when I filter data tab and select COF 1014 and paste that info in worksheet tab. I run the macro and the only thing that happens is that my hearder (Row2) moves to Dr Pepper sheet
File ID 704942
Almost...I ran Macro on worksheet tab it moved 4 of the eight rows that were to be moved to Dr Pepper tab. I saved and uploaded fileID 217362
Perfect! THANK YOU!