Can I Pull Data Automatically from One Column to Another?

[BRYCEPIETROWIAK]

Hello,

I receive an excel file report that has a lot of information on it that ultimately needs to be reformatted into a different file. Is it possible to the original excel report that I get, paste it into a new Excel sheet on my file, then automatically have the information in the new Excel sheet on my file update in another sheet? See picture for example.

In other words, can I paste the report that I get in "Sheet A" and have "Sheet B" automatically update the columns shown? The column names are different in Sheet A than Sheet B, so I would need to find a way to tell Excel to take all the information for this sheet and this column and populate it into this new sheet in this column.

I do not want to have to manually copy and paste each column since it would be very time consuming.

Thanks!

 

[kweaver]

Yes, this is possible, but it would help if you show sample data for both sheets. When showing a sample, please use XL2BB so that anyone helping you doesn't have to try to recreate your data.
Is a VBA solution an option?