Column Search and Data manipulation

[apc3usa]

I have a workbook with 10 sheets. My "raw data" is on the last sheet with 50 rows by 25 colums, and I am having issues with figuring out how to seach a column and moving the data to another page.

The "Raw Data" sheet is a group of 25 people with their travel requirements. one of the requirements is for a rental car type. not everyone gets a rental car, and i want to put the persons name and rental car type on another page.

Any insights would be greatly appreciated.

-Patrick

 

[just_jon]

Welcome to MrExcel - we need more details about your raw data sheet - the key row involved, etc; and what column/row fields you wish to copy and where you want them copied to.

Maybe you could post a small sample using Colo's utility at the bottom of the page.