Interesting.
I do that quite often
Filter data, then copy the resulting data to another sheet.
What version of Excel are you using?
Paul
From: Susan
To: MS EXCEL AND VBA MACROS
Sent: Mon, January 24, 2011 10:35:32 PM
Subject: $$Excel-Macros$$ Copy data
can u pls attach a sample file...
Regards,
Manoj Kumar
On Tue, Jan 25, 2011 at 9:05 AM, Susan wrote:
> Hi,
> I’m trying to copy a list from column A2 to A30 (which was created
> using Data Validation), on sheet 2 to column C2 to C30 on sheet 1.
> I’ve tried everything, but error keeps coming b
Hi,
I’m trying to copy a list from column A2 to A30 (which was created
using Data Validation), on sheet 2 to column C2 to C30 on sheet 1.
I’ve tried everything, but error keeps coming back that I ‘can only
copy filtered data to the active sheet’.
Thanks.
Susan
--
---
