Add multiple ranges to an array then paste the data

Hello,

I am new to arrays so this may sounds stupid but I'll go for it. The attached workbook is a test data dump I receive on a monthly basis that includes more columns than I need and I must format it. My plan is to loop through the top row that includes the title descriptions and search for specific column names. If a name matches then I set the range of the column area. Since there are a number of columns I figured I would loop through and add the ranges to an array and at the end paste just the columns I want to another location (for example sheet2 range A1 for instance.

Can this be done? I would perfer to do it this way and not delete column.

Thank you!

Hi ttd,

Do you want to do this with a formula or a macro solution?

A simple formula approach would be to put the Column Headings you want on row 1 of Sheet 2, and use HLOOKUP(), copying this formula down as far as you need to.

eg. =HLOOKUP(A$1,Sheet1!$B$10:$AH$19,ROW(),0)

Extract Data for ttd.xlsm

I hope this helps, please let me know!

Regards,

David

If this has been of assistance, please advise. A little thanks goes a long way.
- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

If several people have responded, when you reply please make it clear WHO you are responding
to by mentioning their name.

Thank you Jerry. For my own knowledge could you have added the hardcoded ranges to an array and then paste everything to another workbook or sheet?