Simply Copy and pasting data from one sheet to another sheet but certain cells....

How do you copy and paste certain cells to another sheet behind the scenes, when recording a macro it obviously runs and you can see the mess and its annoying how do I get away fro this...

Here is what I have, basically a data sheet that has inventories on one page, they are in the same cells everytime so I need to select say cell B1, B15, B30, C12 and so on and paste them into a row that is simply the inventories so B2, B3, B4, B5, B6 straight across matching them with their header... they will always be copied from the same cells and always be pasted into the same cell location....


T

TEST.xlsx

[ATTACH=CONFIG]313656[/ATTACH


The attached has SHEET 1 with the inventory amounts in different places, they need to be transferred to SHEET 2 and go with A B C D E as they are in SHEET 1... its a simple copy and paste but in a large file its not but I know once I get the basic down I can make it more complex...

TEST.xlsx

I added notes in their and before and after on sheet 2, let me know if you need anything else...

TEST.xlsx