Copying Rows with values in column A pasting in a new doccument and saving that doc

[Pistolade]

So basically I have a table (see attached). Now, this table is generate
based off of a macro that opens a file, cuts some information (A2:C3000
pastes it into an existing table on the original file, some formula
drop down all 3000 rows and do what they're supposed to. Now this i
where I need help.
when these 3k rows are in the document the next step is to Filter ou
anything blank in column A, Filter out errors in Column F (#N/A, #REF!
#VALUE!), then copy the remaining values, paste them into a ne
document, and save that document as "Import.xlsx"

this may have been a poor explanation but it is the best way I can thin
of explaining it.
Any Help is appreciated,
-Pistolade

+-------------------------------------------------------------------
|Filename: New Compressed (zipped) Folder.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=941
+-------------------------------------------------------------------

 

[Pistolade]

So basically I have a table (see attached). Now, this table is generate
based off of a macro that opens a file, cuts some information (A2:C3000
pastes it into an existing table on the original file, some formula
drop down all 3000 rows and do what they're supposed to. Now this i
where I need help.
when these 3k rows are in the document the next step is to Filter ou
anything blank in column A, Filter out errors in Column F (#N/A, #REF!
#VALUE!), then copy the remaining values, paste them into a ne
document, and save that document as "Import.xlsx"

this may have been a poor explanation but it is the best way I can thin
of explaining it.
Any Help is appreciated,
-Pistolade-

Never Mind, I got it

+-------------------------------------------------------------------
+-------------------------------------------------------------------