Find a particular column and cut it and paste in a new sheet

[donlincolnmre2]

Hello

I have a spread sheet with bunch of column almost 40 or so and some time more, and some where in that spread sheet the following columns are spread out, the heading always appears in row 1, i'm looking for a macro that will the search for following items, example LIST PRICE or EXPIRED DATE and when it find it anywhere in the sheet then cut the entire column and paste it in a new sheet. below are the 6 columns.

Thanks.


List Date List Price Days On Market Expired Date Status Date
5/12/2017 2890000 33 6/14/2017 6/14/2017
4/13/2014 2200 0 6/14/2017 6/14/2017
5/8/2017 649900 37 6/14/2017 6/14/2017

 

[alansidman]

crossposted: Find a particular column and cut it and paste in a new sheet | Chandoo.org Excel Forums - Become Awesome in Excel

 

[My Aswer Is This]

Glad to see you noticed this. I never help on post I know have been cross posted.

crossposted: Find a particular column and cut it and paste in a new sheet | Chandoo.org Excel Forums - Become Awesome in Excel

 

[donlincolnmre2]

crossposted: Find a particular column and cut it and paste in a new sheet | Chandoo.org Excel Forums - Become Awesome in Excel

well when i posted on excel forum NO ONE REPLIED. so i searched internet and found that web site and posted there, seems like no know how to write this macro either they are incompetent or just looking, here is the post status. on excel web site.

So if its not a very long lengthy complicated macro for you then you can help me with this if not then oh well you will be the

19 th view.

0 replies | 18 view(s)

 

[Joe4]

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule #13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.