Macro copy paste data from multiple worksheets into one

l_lolo

New Member
Joined
Feb 20, 2022
Messages
3
Office Version
  1. 365
  2. 2019
  3. 2016
Platform
  1. Windows
Hi,

I have been searching for a macro that will copy and paste data that I have in multiple worksheets to my "tremplate worksheet". I have seen a lot of posts but none of the macros totally works for me (I am new in this).

If someone could please help me I'd be very gratefull.

I attach an example pic (and add steps that I need and "restrictions"):
Restrictions:​
- The worksheets I use come directly form SAP. As you can see in the examples the collumn names that I have written in my template are not necesarilly same as the ones from the downloaded worksheets.​
- In one of the sheets (source 1), I have a collumns that I need to separate by the delimitator (-). For that I need to first add automatically a new collumn and then separe the other into 2.​
- As some orders may be cancelled and reopened (the data that I would have already in my template sheet may thus change), I need for the data to update automatically. Same if new rows are added to one of the sources, I need for them to be added automatically to the template sheet.​
Objetive:​
- add 1 collumn on the right in one of the source worksheets​
- Copy and paste cells from various sources in one worksheet​
- Update the already copied data f anything in the surces changes (for example, from I receive material from and order than has been placed and appears already in my "template").​
Any ideas?? Thanks a lot in advance,​

1646733420596.png
 

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

l_lolo

New Member
Joined
Feb 20, 2022
Messages
3
Office Version
  1. 365
  2. 2019
  3. 2016
Platform
  1. Windows
Another restriction: although the data of one source and another have a connection (in one sheet you have a prod, in another prod&order, and on the 3rd order&price) they are not int he same order. Hence I belive thatin the macro it also needs to appear some function that will look for the order and copy the price of the order (some kid of vlookup).
 

Forum statistics

Threads
1,182,103
Messages
5,933,660
Members
436,904
Latest member
DangerKennedy

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