BRYCEPIETROWIAK
New Member
- Joined
- May 12, 2021
- Messages
- 6
- Office Version
- 365
- Platform
- 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.
Thanks!
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!