Excel VBA - Move data based on column

[longtimelurker]

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.

 

[hiker95]

longtimelurker,

Thanks for the feedback.

You are very welcome. Glad I could help.

And, come back anytime.

Hopefully I can get to a stage where I can do something like this in a few years :D

Practice, practice, and, more of the same.


See the link below for my latest list.

Training / Books / Sites as of 1/30/2014
http://www.mrexcel.com/forum/excel-...umber-statement-end-statment.html#post3706277


And, as your skills increase, try answering threads on sites like:
MrExcel.com | Excel Resources | Excel Seminars | Excel Products
Excel Help Forum
Excel Templates | Excel Add-ins and Excel Help with formulas and VBA Macros
http://www.vbaexpress.com
Excel, Access, PowerPoint and Word VBA Macro Automation Help