Excel: Excel VBA - Move data based on column

Hi Guys, Long time lurker here (^_^) I have been getting by for a year or so now but in need of some help :) At work, I have columns under specific names at a random row. "Description" is a header name for example. I need everything under Description to go to (C:2) in sheet2 I am trying to have excel search by name, aka Description in sheet 1, then move all data under it to C:2 (there are 10 other headers) So that's really it :) Because it's random row, I can no longer use hard code :( Feel free to ask any questions, or if pictures are needed, etc ask away! Thank you Mrexcel forums.

This question generated 21 answers. To proceed to the answers, click here.

This thread is current as of February 09, 2014.

For more resources for Microsoft Excel