I have looked all over the forums and could not find specific code to do exactly this (only pieces of code that probably put together would do what I want).
Would it be possible to do the following:
•Filter Column B of Sheets("Test1") for word "R/R" -- this sheet pulls its data from an external access query and is setup as a table (not sure if this matters)
•Copy Visible cells in Column P
•Paste as is to a text file in a specific destination (By as is I mean how it would look if you manually copied and pasted the cell range into a text file)
I wanted to do this with the Write or Print and not simply copy to the clipboard and paste.
Please see below for my code. It filters and copies/pastes to the desired text file however it stops at the first filtered cell, i.e. there are 5 rows with "R/R" in column B (571,4213,4510,5191,5192), but it only pastes cell P571.
Please Login or Register to view this content.
Bookmarks