VBA Help

[BarneyLTD]

Hi all, i'm hoping someone can help me write a little code to perform the below action?

So, I have 2 workbooks. I need to copy cells A-E from the active sheet to a closed workbook and paste the values in to the first sheet (named Original Order) from cell A1.
The destination workbook resides in different locations so I need to be prompted to open the file. I also need this file to remain open so a copy can be saved in a shared folder.

Is this something that can be done?

I'm overhauling some processes for work so I might be back with a few more questions

Thanks in advance

Tom

 

[BarneyLTD]

EDIT:

all sorted, for now

Thanks both for you support on this. its very much appreciated.

 

[gallen]

You can manually filter and then wont need the filter code, just

wsFrom.Range("A:E")[COLOR=#ff0000].SpecialCells(xlCellTypeVisible)[/COLOR].Copy

    wsTo.Range("A1").PasteSpecial xlPasteValues

What is the table name?