Previous Topic Next Topic

Excel Macro - Selection of data from column using flag (0 or 1)

Closed
Kunal Kumar Posts 1 Registration date Sunday 19 May 2013 Status Member Last seen 19 May 2013 - 19 May 2013 à 09:17
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 21 May 2013 à 11:29
Hi,

In Excel, I have a column of data and corresponding flags (either 0 or 1) in another column.
I want to copy only those data which correspond to a given flag in a continuous manner in another coulumn. Please help me write an excel macro for that.

Thanks!
Kunal
Related:

1 response

Réponse 1 / 1
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
21 May 2013 à 11:29
Hi Kunal,

Why don't you sort your data on the flags column?

Best regards,
Trowa

Similar discussions

Copying data from one Excel sheet to another.
Remedial -
Kav -

30 responses
How to extract data from one excel file to another
zamorin -
zamorin -

2 responses