Can I Pull Data Automatically from One Column to Another?

BRYCEPIETROWIAK

New Member
Joined
May 12, 2021
Messages
4
Office Version
  1. 365
Platform
  1. Windows
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.
1623789144752.png

Thanks!
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

kweaver

Well-known Member
Joined
May 8, 2018
Messages
2,118
Office Version
  1. 365
  2. 2010
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?
 

Forum statistics

Threads
1,143,909
Messages
5,721,465
Members
422,363
Latest member
Bogus_Potatoes

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top