Copying certain columns returned from a filter

[daveonion]

Hi I have a spreadsheet where one column is filtered (column a), i then want to copy columns f - k and the filtered data into another spreadsheet into columns e - j onto another spreadsheet, any ideas

thanks

 

[GlennUK]

Why don't you macro record this?

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[Loomah]

Hi
Try working with this
Worksheets(1).Columns("F:K").Copy Worksheets(2).Range("E1")


;-)

If a man says something and there are no women there to hear him, is he still wrong?
How do I get the best answers?​

 

[SkipVought]

I thnk that you need to Copy -- PasteSpecial - VALUES

Skip,

_{[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount!}