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
Bookmarks