Cut/copy from columns into one vertical column, except certain values.

**costin** · 03-31-2013, 04:29 PM

Hi all,

I found an useful thread for the issue I have, but I would like to add one question: how can I copy the columns, except rows that contains certain values/text, like "FALSE". I attached the example together with the code that mike7952 provided as an answer to Andrew's post. Hope nobody minds that I'm using it here.

There are 10 rows out of 1815 containing "FALSE". So, the final result should be 1805 rows copied in sheet2

Thank you all for support,
copycolumns.xlsm

**xladept** · 03-31-2013, 05:07 PM

Hi Costin,

Try this:

Please Login or Register  to view this content.

Directions for running the routine(s) just supplied

Copy the code to the clipboard

Press ALT + F11 to open the Visual Basic Editor.

Open a macro-enabled Workbook or save your Workbook As Macro-Enabled

Select “Module” from the Insert menu

Type "Option Explicit" then paste the code under it

With the cursor between Sub and End Sub press F5 (F8 to Single Step)

OR

Press ALT + Q to close the code window.

Press ALT + F8 then double click on the macro name

**AB33** · 03-31-2013, 06:50 PM

If you wanted Mike's code

Please Login or Register  to view this content.

**costin** · 04-02-2013, 02:01 AM

thank you very much guys, it works perfectly. U guys are great !

**costin** · 04-02-2013, 11:01 AM

ok, i have to return with a question: I'm using the code from AB33. It's working fine, but i didn't notice that this code does copy/paste starting with A1;B1 ... A2;B2 ... I need actually to do like this: A1;A2 ... B1;B2 ... I've tried to figure out to bounds of array but no success.
Hope that you understand what I wanted to say, I must admit that after 6 hours working in excel my thoughts are not that clear

Thanks,

**AB33** · 04-02-2013, 11:25 AM

costin,
This thread was closed and you are was supposed to start a new thread with new request, but I will do it this time round.

Please Login or Register  to view this content.

**costin** · 04-02-2013, 12:36 PM

now it's really closed. Thank you, I appreciate your help.

Cut/copy from columns into one vertical column, except certain values.

LinkBack

Thread Tools

Rate This Thread

Display

Cut/copy from columns into one vertical column, except certain values.

Re: Cut/copy from columns into one vertical column, except certain values.

Re: Cut/copy from columns into one vertical column, except certain values.

Re: Cut/copy from columns into one vertical column, except certain values.

Re: Cut/copy from columns into one vertical column, except certain values.

Re: Cut/copy from columns into one vertical column, except certain values.

Re: Cut/copy from columns into one vertical column, except certain values.

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions