Pulling an entire Column "IF" a cell contains "x"

**jdskin2** · 02-14-2012, 01:39 PM

Ok, so I found this macro that does what I want, the problem is I want it to search through a row, and copy the whole column. Instead of searching columns and returning rows.

Here is the original macro

Please Login or Register  to view this content.

Can anyone help me edit the original macro to search through row (will be row 4) and copying the whole column into the next sheet if true?

**Fotis1991** · 02-14-2012, 03:57 PM

Hi.

Pls
3. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Select your code and click the [#] button at the top of the post window (if you are editing an existing post, press Go Advanced to see the [#] button). The result will appear like this in the post window:

Please Login or Register  to view this content.

... and appear like this when posted:

Code:

your code here ...
and here ...
and here

You can also type the code tags in manually if you prefer. For more information about these and other tags, click here.

**jdskin2** · 02-14-2012, 07:11 PM

example1.xlsm I have created an example file, the macro currently searches and copies the data in the format on the first tab, but all my data is like the data on the sheet4.

Is there a simple edit to the macro to search a row and copy columns instead of searching a column and copying rows?

Thanks,

**jdskin2** · 02-17-2012, 02:31 PM

anyone have some ideas?

**watersev** · 02-17-2012, 04:55 PM

hi jdskin2, please check attachment, run code "test", input value to filter columns for

**jdskin2** · 02-23-2012, 01:44 PM

Thanks for the reply. Few questions, when I search for 3456 it it copies columns into a new worksheet but includes some that do not contain the value. Also, is there a way to search a string input? I tried inputing A, B, C, etc. but it did not return anything.

Thanks Again